Hello I have a zap that I have set to search for a tab in a google sheet by name. I search for multiple tabs in the zap and it returns all of them except for one specific tab. I’ve tried renaming the tab but for some reason it will return the tab.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/65fe9972-fa26-4558-bf4d-8956072ebe6b.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/dc0caae4-f4a4-4df8-ac7f-7267dcf7fabe.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/f85a5118-9d00-49df-8c3a-15626299e9af.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/347d58d5-a5b4-469d-ba69-c348dd48c5ae.png)
Hello I have a zap that I have set to search for a tab in a google sheet by name. I search for multiple tabs in the zap and it returns all of them except for one specific tab. I’ve tried renaming the tab but for some reason it will return the tab.
Hi
Good question.
It may be related to the dynamic Spreadsheet variable value.
You may want to try using the GSheets API via this Zap action: GSheets - App Extensions
Use the AI to help you configure.
Thanks
Any suggestions you have would be great.
Thanks!
Try asking ChatGPT for help with a Code step.
When I try to use the formatted information I’m back to the string of text instead of the line items…..
Should I be able to access the rows of data from the format?
We would need to see detailed screenshots with how your Formatter step is configured.
When testing it returns
When trying to access the formatted data I get this.
Here’s an article to reference to help isolate the desired Worksheet ID based on the name:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.