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!
Best answer by SamB
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:
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:
When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.
More about cookies
Customize which cookies to allow
Marketing cookies
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Social media cookies
label
These cookies are set by a range of social media services that we have added to the site to enable you to share our content with your friends and networks. They are capable of tracking your browser across other sites and building up a profile of your interests. This may impact the content and messages you see on other websites you visit. If you do not allow these cookies you may not be able to use or see these sharing tools.
Analytics/performance cookies
These cookies enable the website to provide enhanced functionality and personalization, and allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. These cookies may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly and we will not know how you are using our site.
Functional cookies
label
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
Essential cookies
Always active
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.