Always save more than one when an event occurs in google sheet

[Imam_Hanafi]

Describe the problem/error/question

I want the number entered from the webhook to be saved in Google Sheet. Meanwhile, if the number is already in Google Sheet, there is no need to save it again.
However, always save more than one when an event occurs.

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

• **n8n version:1.52.2
• **Database (default: SQLite):Default
• **n8n EXECUTIONS_PROCESS setting (default: own, main):Default
• **Running n8n via (Docker, npm, n8n cloud, desktop app): Docker via easypanel
• **Operating system:Ubuntu 22.04.4 LTS

[ihortom]

@Imam_Hanafi , I believe there is a logical bug in your workflow. You are getting the numbers from the Googlesheet and then comparing the number from the Webhook with every number returned by the Googlesheet GET node. Thus, for every number not matching that from the webhook you get it added.

What you should be checking in a presence of the webhook number in the whole list of Googlesheet numbers, not individually.

This could be achieved with an addition of the Aggregate node between Googlesheet GET node and IF node. The IF node itself would have to be updated to check the presence of the webhook number in the array of numbers from Googlesheet. For example,

{{ $json.Nomer.includes($('Webhook').item.json.body.from) }}

where $json.Nomer is the array produced by Aggregate node.

Also make sure the data type of the numbers match in the outputs of Webhooks and Googlesheet. That is their are either numerical or string in both.