Best answer

Zap a gmail csv attachment in to Google Sheet

  • 12 June 2020
  • 7 replies
  • 1631 views

Hi,

 

I need help making a Zap for a daily report that sends out to my Gmail as a CSV attachment.

I need to connect it to the main Google Sheet and it has to update everytime I receive the report in Gmail as a CSV attachhment. 

Can you please help me make a Zap for this? I can’t figure it out. 

icon

Best answer by Mercology 19 June 2020, 00:50

With the 150K limit, you are at a dead end.

David

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.

7 replies

Userlevel 2
Badge

@sfbrian,

Zapier can automatically save your email attachments to Google Drive. Whenever you get a new email in Gmail with an attachment, this Zap will save it to the Google Drive folder you want - just be sure to pick one when setting this up, otherwise we'll add the file to the root of your Drive.

Take a look at https://zapier.com/apps/gmail/integrations/google-drive/192/save-new-gmail-attachments-to-google-drive

Also, take a look at this to take you from file to sheet...https://help.gocanvas.com/hc/en-us/community/posts/360002727113-csv-to-zapier-to-google-sheets

David

 

@David Mercer  Thanks for the reply. I have checked the following links. But I think what it does it only adds the attached CSV into Google Drive or create new worksheets?

What we need is a  MASTER GOOGLE SHEET  that will automatically update each time we receive an email with an attached CSV.

Do you think this can be done?

 

Thank you

 

 

Userlevel 4
Badge +4

Thank for the clarification.  Take a look at the capabilities of Zapier Formatter and CSV files.  https://zapier.com/help/doc/how-import-csv-files-formatter

 

David

@Mercology thanks. I’ll check


@Mercology  @David Mercer I have tried to use Formatter but this won’t accept my CSV file because it is more than 150kb. So there is a data limit in order for Zapier to import the data into Google Sheets? 

@David Mercer @Mercology 

 

This is the error message that I am getting :

 

CSV Import only supports file sizes < 150K error
The utility only supports importing files that are 150K or less (which is around 1000 rows of a 10 column CSV file.) You'll need to split the CSV file into multiple files if it's too large.

Userlevel 4
Badge +4

With the 150K limit, you are at a dead end.

David