Hello! I currently have a Zap set up that sends the contact name and email to a Google sheet every time I send an email. How do I set it up to not add contacts that are already in the sheet? Any help is greatly appreciated!
Best answer
How to prevent duplicates when adding contacts from Gmail to Google Sheets
Best answer by Troy Tessalone
Hi
Use this Zap action: GSheets - Lookup Row
Check the checkbox at the bottom of the Zap step config to create row if not found.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
- Answer
Hi
Use this Zap action: GSheets - Lookup Row
Check the checkbox at the bottom of the Zap step config to create row if not found.
⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
+6- Zapier Staff
That’s awesome
Just incase you need additional help, we have a help doc regarding updating spreadsheet rows here: https://help.zapier.com/hc/en-us/articles/8495978803213-Find-and-update-spreadsheet-rows-in-Google-Sheets-on-Zapier
Hopefully, this helps! If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.