Email List Validation and Cleanup with Google Sheets and Verifiemail (via n8n)

This n8n workflow provides a robust solution for validating and cleaning up email lists stored in Google Sheets. It allows you to trigger an email validation process for a specified range of emails, process them through a validation service (implied by the workflow structure, though the specific service isn't explicitly defined in the provided JSON), and then update your Google Sheet with the validation results.

What it does

This workflow automates the following steps:

1. Receives a Trigger: It starts by listening for a webhook trigger, which is expected to contain information about the Google Sheet to process (Spreadsheet ID, Sheet Name, and the range of emails to validate).
2. Reads Emails from Google Sheets: It connects to Google Sheets to read the email addresses from the specified range.
3. Prepares Data for Validation: A Function node processes the retrieved email data, likely formatting it for a validation service.
4. Validates Emails (Implied): The workflow is designed to send the email addresses for validation. Although the specific validation service node is not present in the provided JSON, the overall structure and naming suggest this crucial step.
5. Processes Validation Results: A Code node is used to handle the results from the validation step, likely parsing and standardizing the output.
6. Filters Valid Emails: An If node filters the validated emails, separating valid ones from invalid or risky ones.
7. Merges Results: A Merge node combines the results from both the "valid" and "invalid/risky" branches.
8. Updates Google Sheet: Finally, it updates the original Google Sheet with the validation status for each email address.
9. Responds to Webhook: It sends a response back to the triggering webhook, indicating the completion of the process.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Account: A Google account with access to Google Sheets.
• Google Sheets Credential in n8n: Configured Google Sheets OAuth2 or API Key credentials in your n8n instance.
• Email Validation Service (External): An account and API access to an email validation service (e.g., Verifiemail, ZeroBounce, Hunter, etc.). Note: The specific node for this service is not in the provided JSON, but it's a logical component for this type of workflow.
• Basic JavaScript Knowledge: For customizing the Function and Code nodes if needed.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the three-dot menu in the top right and select "Import from JSON".
   • Paste the JSON and click "Import".
2. Configure Credentials:
   • Locate the "Google Sheets" node.
   • Click on the credential field and select your existing Google Sheets credential or create a new one (OAuth2 is recommended for full access).
   • If you add an email validation service node, configure its credentials as well.
3. Configure the Webhook Trigger:
   • The "Webhook" node (ID: 47) will provide a unique URL. This URL is what you will call to trigger the workflow.
   • The webhook expects a JSON body with spreadsheetId, sheetName, and range parameters to specify which emails to process.
4. Customize Function and Code Nodes:
   • Review the Function (ID: 14) and Code (ID: 834) nodes. These nodes contain custom JavaScript logic. You may need to adjust them based on the exact format of your Google Sheet data and the expected output from your email validation service.
5. Add Email Validation Service Node (Crucial, if not already present):
   • Given the workflow's purpose, you will need to insert an email validation service node (e.g., "HTTP Request" to an API, or a dedicated app node like "Verifiemail" if available in your n8n version) between the Function node (ID: 14) and the Code node (ID: 834).
   • Configure this node to send the email addresses for validation and receive the results.
6. Activate the Workflow:
   • Once configured, make sure to activate the workflow by toggling the "Active" switch in the top right corner of the workflow editor.

To run the workflow, send a POST request to the Webhook URL with a JSON body similar to this:

{
  "spreadsheetId": "YOUR_GOOGLE_SHEET_ID",
  "sheetName": "Sheet1",
  "range": "A:A"
}