Google Sheets 'By ID' is 'undefinied'

Questions
1

Describe the problem/error/question

I’m creating a workflow where I create a Google Sheets, then I append rows to it. The Google Sheet is created. The ID of the Sheet is showing up. But when I try to append, the ID is undefined.

What is the error message (if any)?

Can not get sheet ‘By ID’ with a value of ‘undefined’

Please share your workflow

image
image1613×775 48.5 KB

Share the output returned by the last node

image
image1952×940 132 KB

Information on your n8n setup

  • I’m using cloud n8n
2

Hi,

You cannot reference the info like this

If you would like to reference it via $json you need a merge node in front of the last node

Otherwise you need to reference it through $(‘node name’)

The easiest way is to just drag and drop from the left view to the field expression and it will correctly reference the data.

Reg
J.

3

Thank you! I was able to fix the issue by merging as you said. I thought the data from the previous nodes was carried over. However, I actually need to use a merge node.

4

Hi,

great. can you please accept as solution? thanks

reg,J.