"Read Excel Sheet Names" Equivalent for Google Sheets

[jchristopherson]

I am looking to achieve the same functionality as the Read Excel Sheet Names node presents but for Google Sheets.
More specifically, I want to read data from every single sheet in a Google Sheets workbook. The standard solution I have found so far (typically aimed at Excel users). Is to read all sheet names and then loop the reader node over the names.
I’m fine implementing this but I’m not sure how to obtain the list of sheets programmatically.

Thanks!

[armingrudd]

Hi @jchristopherson,

You can use Google Sheets API to get the list of sheets:
GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}

Method: spreadsheets.get  |  Sheets API  |  Google...

[duristef]

Hi @jchristopherson ,
I’ve played a bit with the API and I’ve created some workflows I hope will be helpful.
In order to run them you must first create a Google Cloud Project. The GCP must be enabled to use the Sheets API and have an OAuth 2.0 Client ID and an API key.

read_google_spreadsheet_1.knwf (20.0 KB)
read_google_spreadsheet_2.knwf (30.5 KB)