Keep your email list clean while you work. New emails in your Google Sheet are checked for duplicates and verified before campaigns go out. Marketers and sales teams use it to cut bounces and protect sender reputation.

A Google Sheets trigger scans the sheet every minute and looks for rows with an Email value. An If check skips empty cells, and a Remove Duplicates step keeps only one entry per email to avoid extra API calls. Each unique email is sent to an email verification API with a secure key using an HTTP request. The result is written back to the same Google Sheet so the team sees status without leaving the sheet.

Set up requires access to the target Google Sheet and an API key from your email verification provider. Map the Email column as the match field so updates land on the right row. Expect faster list prep, fewer bounces, and better campaign results. Use it for newsletter lists, webinar sign ups, and cold outreach prep.

• Google Sheets trigger polls every minute to catch new or changed rows
• If check filters out rows where the Email field is empty
• Remove Duplicates keeps one record per email to save API calls
• HTTP Request sends each email to a verification API using an API key
• Update step writes verification results back into the same Google Sheet
• Match on the Email column to update the correct row every time

• Reduce manual list cleaning from 2 hours to 5 minutes
• Improve data quality by up to 85 percent through verification and deduping
• Automate 100 percent of email checks once the sheet updates
• Cut bounce rates and protect sender score with verified contacts
• Connect Google Sheets and an email verification API without code

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and Effibotics Email Verification. See the Tools Required section above for links to create accounts with these services.
3. Prepare your Google Sheet with a header row that includes a column named Email and optional columns for Status and Reason.
4. Open the Google Sheets Trigger node, choose the correct Google account, then select your spreadsheet and the target sheet. Confirm the polling schedule is set to every minute or adjust to your needs.
5. In the n8n credentials manager, create a Google Sheets OAuth2 credential by clicking Create new credential in the trigger node and follow the on screen steps. Name it clearly for future use.
6. Open the If node and confirm the condition checks that the Email field exists or is not empty. Save any changes.
7. Open the Remove Duplicates node and make sure the Email field is selected as the field to compare.
8. Open the HTTP Request node. Click Create new credential if prompted and follow the on screen instructions. Add your API key as a header named api_key and set the body parameter email to the Email field from the sheet.
9. Open the Update Google Sheets node. Select the same spreadsheet and sheet. Set Email as the match field and map the verification response fields to your Status and Reason columns.
10. Test the flow: add one valid and one invalid email to the sheet. Wait for the next poll or manually execute. Confirm duplicates are removed and status fields update correctly.
11. If updates do not appear, check Google Sheets sharing and permission, verify the API key is correct, ensure the Email column name matches exactly, and slow the polling interval if you hit rate limits.
12. Turn the workflow on. Monitor logs in n8n for any errors and fine tune mapping as your sheet structure changes.