Look up specific Sheet in a Worksheet

[hone]

I can't seem to find this. In Zapier I could find a Sheet in a Google Worksheet by using an event called 'Find Worksheet'. This gave me a specific Sheet ID that I could use for further updates e.g. Update row if row exists in SheetID 42432334.

To further illustrate if I have a main Worksheet file with different Sheets called Dogs, Cats, Birds and I have data I specifically want to look for in Cats.
I could say: "find Sheet ID for any sheet matching the text 'Cats'" - this would return the SheetID#, e.g 124323432

Does this make sense? Then I could say update a row in [SheetID: 124323432] which has the following value '[Date]' or similar.

I have the text value of the Sheet to search with but not the Google SheetID.

 

[Supreme]

Hey @hone

To further illustrate if I have a main Worksheet file with different Sheets called Dogs, Cats, Birds and I have data I specifically want to look for in Cats.
I could say: "find Sheet ID for any sheet matching the text 'Cats'" - this would return the SheetID#, e.g 124323432

Regarding your concern to process the specific SpreadSheets' sheet, you can try the following workaround. which will only pass the data in the desired or selected Sheets.

 

[hone]

Thanks. There is no Sheets[] array in List Sheets result?

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[Supreme]

Thanks. There is no Sheets[] array in List Sheets result?

Because you haven't captured the API response in advance format by toggling the Simple Resonse button.

Then try the given workaround accordingly.