Google Sheet Update Row Error: [Can't determine which item to use - execute node for more info]

Hi everyone,

I’m new to n8n and have just created my first workflow. I’m in the final node where I need to add the scraped data to the spreadsheet but I’m getting an error with update a row node. Error is [Can’t determine which item to use - execute node for more info]

Is this a bug? I only dragged it from Google sheets URL

If I try replacing the JSON with actual URL then it’s working.

Here is screenshot of my entire workflow:

Thank you.

You loop node is doing nothing the way it’s set up now. Try removing it and connecting Google Sheets directly to HTTP Request node. See if that works.

Another issue could be the Edit Fields node. If you don’t pass the previous data to the next node, you could loose reference to the items.

Can you please share your workflow with us?
You can copy and paste it inside a code block.

To create a code block you just have to click here:
image

Your workflow will show up like this: