Help matching Google Sheets row with Clickup Task via Custom Field Value

[MutedJam]

Hi @ridiz, welcome to the community

What’s most likely happening here is that your Google Sheets Trigger node and your Get All Invoices node return a different number of items. I’ve described the problem and a way to work around this over here:

HTTP node misses the JSON payload for 2nd iteration

Hi @physx911, seeing you have more than one item on your HTTP Request node but only one item on the clean data node you’re referencing in your expression will lead to the following behaviour: For the first item arriving on the HTTP Request node, n8n will look up the first item on the clean data node which works fine For the second item arriving on the HTTP Request node, n8n will look up the second item on the clean data node which doesn’t exist So, what you most likely want here is have n8n a…

tl;dr you probably want to use something like {{ $("Google Sheets Trigger").first().json["Invoice Number"] }} in your IF node to always read the first (and only item) from your Google Sheets Trigger node.

Give me a shout if you still run into any errors with this