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

[artildo]

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

[EmeraldHerald]

Hi @artildo 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

[artildo]

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

[Jon]

Hey @artildo,

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

[artildo]

Thank you @Jon, that solved the whole case.