Automated Email Validation and Sheet Update Workflow

This n8n workflow automates the process of validating email addresses stored in a Google Sheet. It begins with a manual trigger, allowing the user to initiate the process on demand. The workflow then reads all email addresses from a specified Google Sheet using a service account for authentication, ensuring secure access. Each email is processed individually through a loop, where an HTTP POST request is sent to a third-party email validation API via RapidAPI, using the email as input. Based on the validation response, the workflow updates the original Google Sheet row with the email’s validity status, such as whether it is disposable or fake.

This setup is particularly useful for cleaning and verifying lead lists, enriching data quality, and automating lead qualification processes. It helps maintain high-quality contact data, saving time and reducing manual effort in data management tasks associated with marketing, sales, and CRM systems.