Search for string in all Google Sheets tabs

Question

Hi,

I'm working on a project where I need to take a string and see if it appears in any of the multiple sheets in a Google Sheet file.  I have my Client ID, Client Secret, and Connection token.  When I bring in the Google Sheets Input connector I can select the filename but it wants me to select a particular sheet, I can't select them all.

Is there any way to pull in all the sheets to search through?

Thanks

BonusCup · Answer

@JeffK

Unfortunately, no we do not have a BigQuery account.

JeffK · Answer

Hi @BonusCup - I believe in the current version of the Google Sheets Input Tool you can only select a particular sheet for each tool instance. You could use multiple Sheets Input tools and Union them together in your workflow to get one master table.

Do you happen to have a BigQuery account?

apathetichell · Answer

Not easily -  you would need to have an external list of worksheet names and feed them into the googlesheets input tool via batch macro.

I believe you can get a list of Google worksheet names via R or Python.