Google sheet search function

How can I search within a spreadsheet that has multiple tabs, a target tab that is dynamically determined by a value from a previous node (e.g., the value in column F from another Google Sheet node)?

For ex.: find tab-2 in spreadsheet Main_Spreadsheet and add a new row.

18-21_Jan-05-2025

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:

hi @life.tripod

You are able to dinamically add the name of the sheet by doing an expression rather than a static value:

Is this what you mean?

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