How can I check for email duplicates in Google Sheets?

I have a workflow triggered by Typeform and there is a chance that subscribers try to submit more than once, and with the same email. I want to prevent that and stop the workflow if the subscriber’s email is already in Google Sheets. How could I do that?

@Allan_Nascimento we have a pretty nifty new node for syncing called the “Compare Datasets” node. In sync usecases, it’s all about identifying unique records in system A or B (since if you know it’s unique to A, it’s a simple “add to B” step afterwards and visa versa).

Here is a workflow template that uses Compare Datasets node. It’s not exactly the same usecase, but might prove as a helpful reference: Two way sync Pipedrive and MySQL | n8n workflow template

2 Likes

That’s really helpful, thanks!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.