Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello everyone,


I am new to Zapier and testing out it’s capability, mainly with integration to MySQL database.

My goal is to upload new rows in a MySQL database based from an automated report from Appfolio that is sent to my Gmail daily, I also created a zap that downloads attachments to a google drive folder.

 

Now, what I am trying to do is to upload this csv file from GDrive to Mysql, but on the mapping stage to mysql, it shows the google drive format and not what’s inside the csv file.

 

Ex: my csv file contains the following columns: Unit Address, Unpaid rent, Paid rent and Tenant

But the mapping is showing the following instead: Title, File, Embedded Link, Description, Alternate Link etc. 

Which I assume are the information of the file in GDrive and not the contents.

 

Any help would be appreciated.

Hi @tobita 

Good question.

Try using the Formatter > Utilities > Import CSV: https://help.zapier.com/hc/en-us/articles/8496060898701-How-to-Import-CSV-Files-with-Formatter#common-problems-with-the-import-csv-file-utility-0-1

Hi @Troy Tessalone ,

 

Thank you for responding! I’ll try this out!

@Troy Tessalone  Sorry for troubling you, I tested it out, looks to be on the right path, but it combines all of the rows in to a single value, I think this is due to the csv, would you know how I can separate this out so that each row will be separate?

@tobita 

Please provide detailed screenshots with how your Zap steps are configured in order for us to have enough context, thanks.

You need to make sure you get the CSV version of the file from GDrive. (there should be a specific CSV export version of the file)

The file needs to be in a CSV flat file format. (row 1 is headers preferably, no grouped rows/columns, no empty rows)

 

Hi @Troy Tessalone  thank you for your time.

I added screenshots, I’m currently testing out a step to split by comma, which I’m not sure if it will work.

 

@tobita

Check this existing help article:

 

Then you’ll likely have to use the Looping app to iterate thru the CSV rows in order to add those to MySQL.

NOTE: There are limits for the # of records the Formatter > Utilities > Import CSV File can handle, and same for Looping.

 

 

Reply


Terms & Conditions