When I create an automation, (purpose: get data from place A, example: MAUTIC and create it in place B, example: GOOGLE SHEETS) the N8N executes successfully… But without stopping, creating countless ‘records’…
In my case, the ‘appened or create’ needs to run the creation/update of the same email only once! Adding to the database, only if it’s a new email…
Purpose: if the same email is already on the GOOGLE SHEETS list (place B), the N8N does nothing;.
Hi @mancini, welcome to the community 
In my case, the ‘appened or create’ needs to run the creation/update of the same email only once!
This is what the Google Sheets node should do. Unfortunately you seem to have deleted all the details from the template when posting a new forum question, so I am not quite sure what your workflow looks like or which version of n8n you are running.
But assuming you’re using the current version of [email protected] and have a Google Sheet like this:
…and then execute a workflow like this:
…the existing row would be updated rather than an additional row being inserted:
This would of course also work with an “Email” column instead of an “ID” column like in my example.
My dear, thank you very much, from the heart !!
I really appreciate your help, in addition to learning how to use the forum, I learned the solution to my case !! Grateful.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
