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?