I have a Zap that will is triggered by Trello card and goes as follows:
Trigger: Label “email” is added to trello card.
- Text in Formatter by Zapier → Extracts the number of the card name. e.g. 12345
- find folder in Google Drive → looks for the folder starting with 12345 in parent folder
- find file in Google Drive → looks for a google sheets file in the folder found in step 2
- lookup row → opens the file in Step 3 and looks inside the worksheet tab called “email” for a specific row.
- Draft Gmail → prepares a draft email with content from step 4.
Issue: When I set it up and test it, all goes fine. But then I noticed that in the configuration of step 4, when I define the sheet “Email”, it also shows sheet number ‘2139949480’ under the sheet name.
When I run the zap on any other card than the one that was used during the setup, I get an error on Step 4 as he cannot find sheet ‘2139949480’.
When I test the Zap step by step on another file, the worksheet tab “email” will have a completely different number, and thus I know that it will fail again in the future on another card.
The Google Sheet documents are structured identically with only different data inside.
I thought that in the past, it was no issue to do such operations, but I might be mistaken. How can I lookup a specific row of a specific worksheet, even if the Google sheets document is different?
