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

[ridiz]

Describe the issue/error/question

New n8n user and I’m trying to accomplish the following:

• Watch Google Sheets for updates to a document
• When triggered, get all tasks from a Clickup list
• If there is a task with a matching field value (Invoice number), update the task
• If there is not a matching task, create a new task

Please share the workflow

Share the output returned by the last node

The IF node does not match (return TRUE) on any items, even though there should be. The Google Sheet column is 'Invoice Number" and the Clickup task field is a custom field (short text) named “Invoice Number”

Information on your n8n setup

• n8n version: 0.212.0
• Database you’re using (default: SQLite): SQLite
• Running n8n with the execution process [own(default), main]: own
• Running n8n via [Docker, npm, n8n.cloud, desktop app]: Docker

Do I have the correct approach to this? How can I compare a Google Sheets column with a Clickup custom field? Thank you!

[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

[ridiz]

Thank you! I’ve decided to take a different approach that bypasses the need for google sheets, but I’m going to keep playing with this as it might come in handy in the future.