Google Sheet Node - Can't get values as Expression

[Itzik_Krikov]

Describe the problem/error/question

Google Sheet can’t get Document URL or ID as Expression even that the praser value is correct.

As Expression:

As Fixed:

Information on your n8n setup

• **n8n version:1.101.2

[fahmiiireza]

Hi there, i just try it and it works fine actually, have you maybe tried refreshing your n8n, the google sheet creds as well?

might be only a temporary issue

[cutecatcode]

It’s because you’re using dynamic state instead of static state.
Dynamic means, the sheet can’t be found, because the “n8n system” are “thinking” that maybe the URL will be changed for a mean time.

That’s why your sheet cannot be found when you’re using expression.
To fix that, you can add either Sheet data, or just make the Document URL be fixed.

But sometimes, it can be work, idk why