{"product_id":"verify-google-sheets-lead-emails-with-apify-in-n8n","title":"Verify Google Sheets Lead Emails with Apify in n8n","description":"\u003ch3\u003eVerify Google Sheets lead emails with Apify—before you launch campaigns\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks the validity of unverified email addresses in your Google Sheets lead list using the \u003cstrong\u003eApify Email Verifier API\u003c\/strong\u003e. It runs in batches, performs SMTP handshake validation plus disposable and catch-all detection, then writes a clear verdict back to the exact rows in your sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads unverified rows from Google Sheets:\u003c\/strong\u003e Fetches leads where the \u003cem\u003estatus\u003c\/em\u003e column is empty, so scheduled runs only process new contacts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates and batches:\u003c\/strong\u003e Cleans whitespace, removes duplicate email addresses to prevent duplicate charges, and groups emails into \u003cstrong\u003ebatches of 100\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLive verification via Apify:\u003c\/strong\u003e Sends batches to the Apify Email Verifier API to perform checks for \u003cstrong\u003esyntax, MX records, disposable addresses\u003c\/strong\u003e, and \u003cstrong\u003eSMTP catch-all\u003c\/strong\u003e behavior (without sending emails).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMaps verdicts back reliably:\u003c\/strong\u003e Matches responses by email address with case-insensitivity and email-tag handling, preserving sheet integrity even if results return reordered.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates your spreadsheet:\u003c\/strong\u003e Writes \u003cstrong\u003estatus\u003c\/strong\u003e, \u003cstrong\u003esub_status\u003c\/strong\u003e, \u003cstrong\u003escore\u003c\/strong\u003e, \u003cstrong\u003ecatch_all\u003c\/strong\u003e, \u003cstrong\u003edisposable\u003c\/strong\u003e, and \u003cstrong\u003everified_at\u003c\/strong\u003e back to the correct rows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce bounce rates in outbound email campaigns by filtering invalid leads from a Google Sheets list.\u003c\/li\u003e\n  \u003cli\u003eContinuously verify new SaaS signups or exported lead lists on a schedule.\u003c\/li\u003e\n  \u003cli\u003ePrevent deliverability issues by identifying disposable and catch-all emails before outreach.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/stack:\u003c\/strong\u003e code, sticky note, HTTP Request, Google Sheets, Manual Trigger\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired columns:\u003c\/strong\u003e \u003cem\u003eemail\u003c\/em\u003e, \u003cem\u003estatus\u003c\/em\u003e, \u003cem\u003esub_status\u003c\/em\u003e, \u003cem\u003escore\u003c\/em\u003e, \u003cem\u003ecatch_all\u003c\/em\u003e, \u003cem\u003edisposable\u003c\/em\u003e, \u003cem\u003everified_at\u003c\/em\u003e (only \u003cem\u003eemail\u003c\/em\u003e needs lead data initially)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify authentication:\u003c\/strong\u003e HTTP Header Auth with \u003cem\u003eAuthorization: Bearer YOUR_APIFY_TOKEN\u003c\/em\u003e (from \u003cem\u003econsole.apify.com\u003c\/em\u003e)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46248923791539,"sku":"N8N-21192","price":32.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Uwe9LczAA9g51CJ6ASziB_rQyexoHG.png?v=1792487564","url":"https:\/\/buyflowscripts.com\/products\/verify-google-sheets-lead-emails-with-apify-in-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}