{"product_id":"enrich-google-sheets-domains-with-verified-decision-makers-apify","title":"Enrich Google Sheets Domains with Verified Decision Makers (Apify)","description":"\u003ch3\u003eEnrich Google Sheets domains with verified decision-maker contacts using Apify\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls company domains from your Google Sheets, runs the \u003cstrong\u003eApify Decision Maker Finder\u003c\/strong\u003e to find \u003cstrong\u003everified decision makers\u003c\/strong\u003e, and writes the results back into your Sheets—complete with per-domain classifications and an audit trail.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e and loads configuration values such as your \u003cem\u003espreadsheet ID\u003c\/em\u003e, the \u003cem\u003etarget persona\u003c\/em\u003e, batch size, and \u003cem\u003eApify polling limits\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads domains\u003c\/strong\u003e from an \u003cstrong\u003eInputs\u003c\/strong\u003e sheet and keeps only rows where the status is blank\/READY, then \u003cstrong\u003enormalizes and deduplicates\u003c\/strong\u003e domains.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlags valid rows as IN_PROGRESS\u003c\/strong\u003e in Google Sheets to lock the batch before enrichment begins.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts the Apify Decision Maker Finder Actor\u003c\/strong\u003e with \u003cstrong\u003eemail verification enabled\u003c\/strong\u003e and a \u003cstrong\u003emaximum run charge\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls Apify\u003c\/strong\u003e until the run succeeds, fails, or reaches the polling limit.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads the Apify dataset\u003c\/strong\u003e on success and classifies every requested domain, including cases where Apify returns missing\/empty results (e.g., outcomes like \u003cem\u003eVERIFIED_DM_REVIEW\u003c\/em\u003e or \u003cem\u003eNO_BILLABLE_RESULT\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts results\u003c\/strong\u003e into a \u003cstrong\u003eResults\u003c\/strong\u003e sheet and updates each original Inputs row with the final classification, processed timestamp, and any error message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites batch-level logs\u003c\/strong\u003e to a \u003cstrong\u003eRun_Log\u003c\/strong\u003e sheet; on failures it records a failed run, marks affected Inputs rows with the failure class, and stops with an error.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams enriching leads from a domain list stored in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a repeatable “domain → verified decision maker” enrichment pipeline.\u003c\/li\u003e\n  \u003cli\u003eOperations teams maintaining an audit trail for each enrichment run via a Run_Log sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGoogle Sheets: \u003cstrong\u003eInputs\u003c\/strong\u003e, \u003cstrong\u003eResults\u003c\/strong\u003e, and \u003cstrong\u003eRun_Log\u003c\/strong\u003e upserts\/updates.\u003c\/li\u003e\n  \u003cli\u003eApify: \u003cstrong\u003eDecision Maker Finder Actor\u003c\/strong\u003e with email verification enabled and polling until completion.\u003c\/li\u003e\n  \u003cli\u003en8n nodes\/tools mentioned: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, and \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, plus workflow annotations (sticky note).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45850625474739,"sku":"N8N-18293","price":27.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/dqmtFh-ImZkYeH_ww31No_SHi0mCH9.png?v=1786871197","url":"https:\/\/buyflowscripts.com\/products\/enrich-google-sheets-domains-with-verified-decision-makers-apify","provider":"N8N Commerce","version":"1.0","type":"link"}