Read list of sheets in Google Spreadsheet

Questions
1

Is there a way to list all the worksheets present in a Google Spreadsheet?

For example, if the workflow is triggered on a schedule, is it possible to access Google_Spreadsheet and get the list of all the worksheets present in that spreadsheet, like Worksheet_1, Worksheet_2,…?

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hi @

Not natively to n8n that I’m aware of, you’d need to use the HTTP node to make a call to list all worksheets under a given sheets.

Please refer to their documentation on how to achieve this: Google Sheets API Overview  |  Google for Developers

Hope this helps!

1 Like
4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.