Skip to main content

Hello community.

 

I get an .xlsx file daily delivered to my Gmail that I open, go to sheet tab2, copy the rows in the file, then paste the rows into a MASTER Google Sheet. 

 

Here is my current ZAP workflow:

Gmail > Drive to Upload attachment (converted to .csv) > Drive to Find file > Formatter to Import CSV > Utilities.Looping > GSheets to import rows into MASTER sheet.

 

Here is my problem:

Formatter to Import CSV step only grabs sheet tab1 and the data I need is on sheet tab 2.

 

Any suggestions?

Hey @JMlynarek04,

It looks as though this is same question was asked in another thread: 
 


I’m going to close this one now so that this question can be discussed in a single thread. :)