Append row function

[Sona_Darbinyan]

Describe the problem/error/question

I am unable to pass the newly created sheet id to [append row] node.

What is the error message (if any)?

[undefined]

Please share your workflow

[withabdul]

I assume your Merge node is in Append mode. I have two suggestions:

1. Try this $json[1].spreadsheetId.
2. Change your Merge node mode to Combine mode

[fahmiiireza]

Hi there, the error is expected, looking from your workflow
Because as you can see on the merge node, before the sheet node,it has 12 Items

[
{…this is item 1},
{…this is item 2},
…
{…this is item 12}
]

The sheet node will be executed per item, and looking from your item from the merge node, not every tiem has a spreadsheetID

Which explains why it fets the error because the spreadsheetID is not there

[fahmiiireza]

So you need to make sure that every item has a spreadsheetID if you want to access it like you already did on the screenshot