Best answer

Formatter to Import CSV (sheet tab2)

  • 17 July 2021
  • 1 reply
  • 156 views

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?

icon

Best answer by SamB 9 August 2021, 16:15

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.

1 reply

Userlevel 7
Badge +11

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. :)