About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

Mapping CSV file for Google Drive to MySQL Integration

  • 2 March 2023
  • 6 replies
  • 110 views
tobita

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.

6 replies

Troy Tessalone
Userlevel 7
Badge +14

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
tobita

Hi @Troy Tessalone ,

 

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

tobita

@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?

Troy Tessalone
Userlevel 7
Badge +14

@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)

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
tobita

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.

 

Troy Tessalone
Userlevel 7
Badge +14

@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.

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor

Reply


Terms & Conditions