Cant dynamically Map Sheet Name of Spreadsheet

Questions
,
1

Hi, I’m trying to load Google Sheets data dynamically without specifying the sheet name. I used the Google Drive Trigger to fetch the file and referenced:

Here is an image that showcases it: Its currently hardcoded:

Screenshot 2024-12-16 145937
Screenshot 2024-12-16 145937427×517 16.7 KB

Information on your n8n setup

  • n8n version: 1.69.2
  • Database (default: SQLite): QLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own, main
  • Running n8n via (Docker, npm, n8n cloud, desktop app): self-hosted in google cloud
  • Operating system: Windows10
2

Hey @Kiremit , you need to know the sheet names in advance. If the names are dynamic and you cannot know the names in advance you can try leveraging Google API with HTTP Request node, Method: spreadsheets.get  |  Google Sheets  |  Google for Developers.

3

That makes little sense. Since I always know what filetype to expect

4

I see no relevance of “I always know what filetype to expect” with the sheet name you want to enter dynamically. My suggestion was to find out the names of the sheets in the document you want interact with dynamically.

5

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