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.

  • Home
  • Get Help
  • Troubleshooting
  • Formatter CSV import encoding issue error - “’utf-8' codec can't decode byte 0xe2 in position 10: invalid continuation byte"

Hi community. I have a gmail where every day I receive a Google Ad Manager .csv

I’m trying to parse that .csv in Zapier through Trigger: Gmail > Actions: formattier utilites, but when I test the Action I get this error message: ‘The util_line_item could not be sent to Formatter by Zapier. The app returned "The CSV file couldn't be read, usually due to an encoding issue. Error message: 'utf-8' codec can't decode byte 0xe2 in position 10: invalid continuation byte".’

 

What should I do? I attach prints of the process.

 

Appreciate any help. Thanks!

 

 

 

Welcome to the Community, @MF22!

I’ve seen this error in the past where a zip file of multiple attachments is passed to Formatter, instead of a single CSV file. It looks like this could well be the case here as you’re using the New Email trigger for Gmail and I believe that automatically zips attachments. 

Can you try making a copy of your current Zap so you don’t loose its current setup. Then switch it to use the New Attachment trigger for Gmail instead? This allows the Zap to trigger for each individual attachment and would supply a single CSV file over to the Formatter step.

You’ll likely also want to add a Filter step to ensure that the Zap only attempts to import CSV files and ignore other types of files. You can find out more about setting up the Filter here:


Hope that helps! :)

Terms & Conditions