Clean & Score Email Lists in Google Sheets with n8n + Apify

Clean & Score Your Email Leads in Google Sheets (with n8n + Apify)

Run one workflow to validate and score the emails in your Google Sheets, write results back to your leads, and automatically build a “Ready to send” list using Apify’s salomon.labs/bulk-email-validator—so you can suppress risky addresses before outreach.

What this workflow does

• Starts on demand in n8n via a manual run trigger.
• Reads lead rows from a Google Sheets tab and collects all values from the email column into a single batch.
• Validates & scores emails with Apify by sending the batched list to the salomon.labs/bulk-email-validator Actor through an HTTP Request.
• Normalizes Apify results into one item per email address and removes non-email summary records.
• Updates your original Google Sheet by matching on email and writing:
  • safe_to_send_score
  • recommended_action
  • recommendation_detail
• Filters out unsafe addresses where recommended_action is suppress or manual_review.
• Appends only validated “safe to send” emails to a second tab named Ready to send.

Use cases

• Before sending campaigns, automatically validate new lead lists stored in Google Sheets.
• Keep ongoing CRM-like spreadsheets updated with deliverability signals (score + action + details).
• Generate a clean outbound audience tab that excludes addresses flagged for suppression or manual review.

Technical details

• Google Sheets integration: OAuth-authenticated reads/writes to your leads tab and Ready to send tab.
• Apify integration: HTTP Request to salomon.labs/bulk-email-validator Actor using your Apify API token.
• n8n components: Code, Filter, Aggregate, Sticky Note, HTTP Request, Google Sheets.

Setup tip: Create two tabs in your spreadsheet. In both tabs, add headers in row 1: email, safe_to_send_score, recommended_action, recommendation_detail—then configure the correct spreadsheet and tabs in the Google Sheets nodes.