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 very new to Zapier and am trying to create a zap which would take a .csv attached to a mail sent to my gmail and to automatically import the contents of the .csv into a google sheets document. This is basically what is discussed in this thread.

The problem is that I am unable to make this work and I am unsure what I am doing wrong. When testing the formatter import csv step the csv_text simply returns the title of the csv and the line_items are empty. This then makes the final google sheets step not work. Do you have any clue as to why this may be happening?

Thanks in advance.

Hi @VilleKarlin 

can you please share screenshots of how you have zapier set up? 

Thanks!

Hi,

I got the same issue.

I have retrieved a csv file (“test123.csv”, see attached) from google drive and want to use the Zapier Formatter Utilities-action to import the file into a google spreadsheet. But when testing the action the output won’t show any values from the CSV file.

csv_text only shows the filename

line_items are empty

 

 

Does someone have an Idea what could be wrong here?

Many Thanks!

 

 

Hi @Lord_Mueksch!

Based on the screenshot you provided, it looks like you’ve mapped the wrong field to the CSV File field. You’ve added the title of the file, rather than the file itself.

You’d be looking for something like, instead (source): 

Can you give that a shot to see if it works?

Hi @nicksimard,

you are totally right!

Selecting “File” makes much more sense and it works like charm now :wink:

Many thanks!!!

 

Hey @Lord_Mueksch!

Glad it was a simple fix — thanks for confirming :)

Terms & Conditions