Hello, I am trying to automate moving data that is emailed to me as an attachment into an existing tab on a google sheet. I would like to overwrite the data on the sheet that it is added to. Here are are the details of the manual flow:Receive automated email with attachment (either ASCII or .xlsx file) Open file on desktop, copy and paste values into an existing tab on a google sheet (paste over old data as new data is always larger).The total row count is ~12,000 and will probably not got above 16,000. I would like to make this process trigger automatically whenever a new email with attachment exists.

Question

Zap to move data from email attachment into a Google Sheets

10 months ago
28 June 2023
2 replies
445 views

joellis90
New
0 replies

Hello,

I am trying to automate moving data that is emailed to me as an attachment into an existing tab on a google sheet. I would like to overwrite the data on the sheet that it is added to.

Here are are the details of the manual flow:

Receive automated email with attachment (either ASCII or .xlsx file)
Open file on desktop, copy and paste values into an existing tab on a google sheet (paste over old data as new data is always larger).

The total row count is ~12,000 and will probably not got above 16,000.

I would like to make this process trigger automatically whenever a new email with attachment exists.