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
My issue:
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?
With that link, you could get a CSV of the second worksheet’s values and import that into the Master Spreadsheet file. You’d need to replace the {spreadsheet_ID} with the spreadsheet ID from the step that uploads the XLS file to Google Drive. And replace {worksheet_name} with the worksheet name, which I’m assuming is the same every time.
With that link, you could get a CSV of the second worksheet’s values and import that into the Master Spreadsheet file. You’d need to replace the {spreadsheet_ID} with the spreadsheet ID from the step that uploads the XLS file to Google Drive. And replace {worksheet_name} with the worksheet name, which I’m assuming is the same every time.