Phone
+(02) - 094 980 547Address
Nenuya Centre, Elia Street,© Alrights reserved
by CrowdyFlow
The client needed an automated way to process email data, generate AI replies, and save results to Google Sheets — but without creating duplicate rows. Their old loop logic in Make.com was complex and caused repeated entries or manual clean-ups. When they tried doing this in n8n, it kept looping the whole workflow and overloaded the sheet, or skipped checks for duplicates.
We designed a reliable, clean n8n workflow that automatically:
Checks if a row already exists using a unique Email ID
Loops through each item one by one
Only appends new rows, skipping any duplicates
Generates AI replies with ChatGPT, merges them with the data, and saves them back to Sheets — without any manual work.
The key trick is using the “Always Output Data” option on the Google Sheets lookup. If a row is missing, the node outputs an empty object. The Switch node checks if the returned object has keys — if not, the row is new, so we add it. This ensures no duplicates, no sheet overload, and a 100% clean dataset.
This upgraded flow gives our client:
Zero manual checking for duplicate data
Fully automated AI reply generation
No data loss, no repeated rows
Clean, organized sheets every time
Want a custom n8n automation for your workflows? We help you migrate, upgrade, and automate smarter — with simple logic that saves you time.
Contact Us
©2025 | Techststeck Solutions