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
@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
With the 150K limit, you are at a dead end.
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
@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.