I’m extracting an attachment from an email that is in xlsx format, and need a way to copy the data from the attachment into a Google Sheet.
The new gmail with attachment is the trigger. Step 2 is to upload the file to Google Drive.
Step 3 is to copy the file, using the “convert to document” option, which turns it into a Google Sheet.
In Step 4, I am trying to “Lookup Spreadsheet Row in Google Sheets”, for the spreadsheet just created in step 3.
I can use a custom value to select the spreadsheet (by pointing to the ID from step 3), but can only select the worksheet for that particular spreadsheet - as subsequent spreadsheets are created by the zap, it errors at step four because it’s not pointing to the correct worksheet.
Is there any workaround for this?
Best answer by GetUWired
View original