{"product_id":"clean-score-email-lists-in-google-sheets-with-n8n-apify","title":"Clean \u0026 Score Email Lists in Google Sheets with n8n + Apify","description":"\u003ch3\u003eClean \u0026amp; Score Your Email Leads in Google Sheets (with n8n + Apify)\u003c\/h3\u003e\n\u003cp\u003eRun 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 \u003cstrong\u003esalomon.labs\/bulk-email-validator\u003c\/strong\u003e—so you can suppress risky addresses before outreach.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts on demand in n8n\u003c\/strong\u003e via a manual run trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads lead rows from a Google Sheets tab\u003c\/strong\u003e and collects all values from the \u003ccode\u003eemail\u003c\/code\u003e column into a single batch.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates \u0026amp; scores emails with Apify\u003c\/strong\u003e by sending the batched list to the \u003cstrong\u003esalomon.labs\/bulk-email-validator\u003c\/strong\u003e Actor through an \u003cstrong\u003eHTTP Request\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes Apify results\u003c\/strong\u003e into one item per email address and removes non-email summary records.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates your original Google Sheet\u003c\/strong\u003e by matching on \u003ccode\u003eemail\u003c\/code\u003e and writing:\n    \u003cul\u003e\n      \u003cli\u003e\u003ccode\u003esafe_to_send_score\u003c\/code\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003ccode\u003erecommended_action\u003c\/code\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003ccode\u003erecommendation_detail\u003c\/code\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters out unsafe addresses\u003c\/strong\u003e where \u003ccode\u003erecommended_action\u003c\/code\u003e is \u003ccode\u003esuppress\u003c\/code\u003e or \u003ccode\u003emanual_review\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends only validated “safe to send” emails\u003c\/strong\u003e to a second tab named \u003cstrong\u003eReady to send\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBefore sending campaigns, automatically validate new lead lists stored in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eKeep ongoing CRM-like spreadsheets updated with deliverability signals (score + action + details).\u003c\/li\u003e\n  \u003cli\u003eGenerate a clean outbound audience tab that excludes addresses flagged for suppression or manual review.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e: OAuth-authenticated reads\/writes to your leads tab and \u003ccode\u003eReady to send\u003c\/code\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration\u003c\/strong\u003e: HTTP Request to \u003cstrong\u003esalomon.labs\/bulk-email-validator\u003c\/strong\u003e Actor using your Apify API token.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n components\u003c\/strong\u003e: Code, Filter, Aggregate, Sticky Note, HTTP Request, Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup tip:\u003c\/strong\u003e Create two tabs in your spreadsheet. In both tabs, add headers in row 1: \u003ccode\u003eemail\u003c\/code\u003e, \u003ccode\u003esafe_to_send_score\u003c\/code\u003e, \u003ccode\u003erecommended_action\u003c\/code\u003e, \u003ccode\u003erecommendation_detail\u003c\/code\u003e—then configure the correct spreadsheet and tabs in the Google Sheets nodes.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45869898203315,"sku":"N8N-18414","price":69.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/cLwM5LK5q35YEpdnAm706_BCtH0X6I.png?v=1787131063","url":"https:\/\/buyflowscripts.com\/products\/clean-score-email-lists-in-google-sheets-with-n8n-apify","provider":"N8N Commerce","version":"1.0","type":"link"}