Hi @Dania 

Good question.

It may be related to the dynamic Spreadsheet variable value.

@Dania 

You may want to try using the GSheets API via this Zap action: GSheets - App Extensions

Use the AI to help you configure.

Thanks @Troy Tessalone I will give the API a try

@Troy Tessalone I successfully pulled the sheet data using the API but now am at  a loss at how to utilize the data. I tried parsing out the tab ids, but even with that I can’t access the individual tab ids to pass into a step to the query the information on specific tabs. 

Any suggestions you have would be great. 

Thanks!

@Dania 

Try asking ChatGPT for help with a Code step.

@Troy Tessalone I feel like I’m missing something very simple. I’ve used the formatter by Zapier many of times. When I format my results for the Tab Id’s I get this response. 

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?

@Dania 

We would need to see detailed screenshots with how your Formatter step is configured.

@Troy Tessalone Here’s the formatter step.

When testing it returns

When trying to access the formatted data I get this.

@Dania 

Here’s an article to reference to help isolate the desired Worksheet ID based on the name:

@Troy Tessalone Thanks for all of your assistance. It turns out my issue was a space in the beginning of the tab name. That was the root cause of my error from the beginning . After removing the space everything is working as expected. 

That’s awesome @Dania! Big thanks to Troy for lending a hand here.

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help!