Get Google Sheet by name (expressions don't work for it)

Describe the problem/error/question

I need to read a sheet in the spreadsheet using an expression for its name. Because it contains current date. But in the expressions mode, the “list” option is whited out.

How can I do that?

Please share your workflow

Here’s just a random file in the node. You can see that in the expression mode the list option is unavailable

Information on your n8n setup

  • n8n version: 1.21.1
  • Database (default: SQLite): default
  • n8n EXECUTIONS_PROCESS setting (default: own, main): default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker compose
  • Operating system: Ubuntu 22

Hi @artildo :wave: Sorry you’re running into this - does this happen on all sheets, or just the one? Would you be able to share an example sheet with us? I tried just there with a test, and was able to always be able to select from a list, so an example would help :bowing_man:

Hi, @EmeraldHerald

It’s not about selection. It is about choosing a sheet using expression.
If you want to use fixed value, you can choose from all three options: List, ID, URL
If you want to use dynamic value, you can choose from only two options: ID and URL. You can’t choose the sheet from the list

Hey @artildo,

Try updating your n8n version, We added this 2 weeks ago in 1.24.0.

1 Like

Thank you @Jon, that solved the whole case.


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