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.

Best answer

Can't get CSV Import to work

  • 10 February 2021
  • 5 replies
  • 240 views
V

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.

icon

Best answer by nicksimard 17 February 2021, 01:41

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

GetUWired
Userlevel 7
Badge +12

Hi @VilleKarlin 

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

Thanks!

A

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!

 

 

1 Attachment
nicksimard
Userlevel 7
Badge +11

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?

A

Hi @nicksimard,

you are totally right!

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

Many thanks!!!

 

nicksimard
Userlevel 7
Badge +11

Hey @Lord_Mueksch!

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

Terms & Conditions