What I need automated:
I get a xlsx file daily from RingCentral that has 2 tabs. Everyday I open the file copy the call data on tab2 and paste it into a Master file in Google Sheets. I want to automate this process.
I am close, however I am running into a problem with Formatter Import a CSV in my Zap.
Here is my current Zap:
- GMail - Get XLXS attachment
- Drive - Copy file to Drive, convert to CSV
- Find a File - Find the CSV
- Formatter - Import CSV
- Looping by Zapier - Loop through rows
- Google Sheets - Create Spreadsheet Rows in Master File
Step 4, Formatter - Import CSV is only getting sheet tab1. The call data I need to get is on sheets tab2
Any suggestions to solve this, and/or recommendations on how to streamline this zap?