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.