{"product_id":"n8n-workflow-enrich-verify-leads-from-google-sheets-apollo-instantly","title":"n8n Workflow: Enrich \u0026 Verify Leads from Google Sheets (Apollo, Instantly)","description":"\u003ch3\u003eEnrich, verify, and push qualified leads from Google Sheets to Apollo \u0026amp; Instantly—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow processes your “ready” organisations from Google Sheets every weekday, enriches them with Apollo decision-makers, verifies emails with MillionVerifier, and (when enabled) sends high-scoring, safe leads into your Instantly campaign—while writing all results back to your sheets for full auditability.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on schedule (or manually):\u003c\/b\u003e Executes every weekday at 07:00 and loads configuration for batching, scoring, verification, and sending mode.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLoads a deduplicated batch from Google Sheets:\u003c\/b\u003e Reads the “Organisations” tab, selects a batch of ready organisations, and exits early with a clear message if there’s nothing to process.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNormalizes and categorizes organisations:\u003c\/b\u003e Normalizes organisation name\/domain and applies keyword-based category rules. Optionally uses \u003cb\u003eAnthropic\u003c\/b\u003e only for unclassified organisations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFinds decision-makers with Apollo (or reuses sheet data):\u003c\/b\u003e Uses the \u003cb\u003eApollo API\u003c\/b\u003e to pull up to the configured number of contacts per organisation. If Apollo isn’t configured, it falls back to contact details already present in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eScores contacts against your ICP:\u003c\/b\u003e Applies your configured ICP scoring rules to each contact.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eVerifies emails with MillionVerifier:\u003c\/b\u003e When verification is enabled, it verifies each email address and holds back unverified or risky emails by default (with reasons recorded).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eWrites outcomes back to Google Sheets:\u003c\/b\u003e Updates the “Organisations” and “Contacts” tabs with enrichment results, discovered contacts, and held-back reasons.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePushes safe leads to Instantly (optional):\u003c\/b\u003e If sending is enabled and safe contacts exist, it pushes them into the appropriate \u003cb\u003eInstantly\u003c\/b\u003e campaign.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams enriching target accounts and keeping a clean pipeline in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers operationalizing lead qualification (ICP scoring + email verification) in n8n.\u003c\/li\u003e\n  \u003cli\u003eOperators sending only verified, high-scoring contacts into Instantly to improve deliverability.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes\/tools:\u003c\/b\u003e \u003ci\u003eif\u003c\/i\u003e, \u003ci\u003ecode\u003c\/i\u003e, \u003ci\u003emerge\u003c\/i\u003e, \u003ci\u003eno op\u003c\/i\u003e, \u003ci\u003esticky note\u003c\/i\u003e, and \u003ci\u003ehttp request\u003c\/i\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e Google Sheets, Apollo, MillionVerifier, Anthropic (optional), Instantly\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eIdeal for:\u003c\/b\u003e n8n automation workflows that combine lead enrichment, verification, and controlled outbound sending—without losing transparency in your spreadsheets.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46067980533939,"sku":"N8N-19778","price":8.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/jQgAFvXBLwBlwh3LQXohu_gC46jtMN.png?v=1789981517","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-enrich-verify-leads-from-google-sheets-apollo-instantly","provider":"N8N Commerce","version":"1.0","type":"link"}