I’m building a zap to pull information from a number of worksheets within the same Google sheet and then generate a form letter using that information. Everything is good, except for one step where I need to look up information on a specific worksheet that matches information retrieved earlier in the zap.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/c7a2b715-df8f-45d4-bb89-3e0d696006f4.png)
The first (trigger) step fires when a new line is added to the source sheet. It retrieves that new row and stores it for the next step. The second box (in red) is meant to find a specific worksheet in that same sheet using information retrieved in step 1. For reference, these are the tabs available in the sheet:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/07c386ea-86f3-4c84-a967-2312bd9ceb62.png)
The trigger reads the new row from the ‘onboarding’ worksheet. This is step is working. The Insurance field is meant to be used in step 2
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/06e800dc-307c-41a7-a696-8b6a362ef927.png)
Step 2 is configured to find the worksheet tab that matches the Insurance value retrieved above (and lookup the city):
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/2b63417d-d3e1-4271-b59c-b24e7e99ea38.png)
When configured this way, Zapier says that it can’t find the worksheet despite the name criteria matching (no spaces, spelling errors, etc):
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/2dc239a7-b707-45d1-a878-b32d283166b0.png)
That value exactly matches the name of the worksheet (see up-thread), but no dice. Setting the worksheet name statically (i.e. the string “InsuranceA”) works.
I’ve tried the following:
- Checked spelling
- Checked file permissions
- Scrapped and re-created the step
- Restarted the testing process with new data
- Lots of googling
If anyone has pointers it would be greatly appreciated.