{"product_id":"n8n-workflow-score-ad-prospects-draft-cold-emails","title":"n8n Workflow: Score Ad Prospects \u0026 Draft Cold Emails","description":"\u003ch3\u003eScore Ad Prospects \u0026amp; Draft Cold Emails — automatically (n8n workflow)\u003c\/h3\u003e\n\u003cp\u003eTurn a Google Sheets list of prospects into a weekly pipeline: this n8n workflow checks whether companies are actively advertising (via Apify), analyzes LinkedIn ad signals, detects website tracking\/hiring activity, then scores each prospect (0–100) and drafts a three-sentence cold-email opener using OpenAI—finally updating Google Sheets and posting the top matches to Slack.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand or every Monday at 7am\u003c\/strong\u003e, reading the \u003cstrong\u003eProspects\u003c\/strong\u003e tab from Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans and deduplicates domains\u003c\/strong\u003e, derives a LinkedIn company name for searching, and carries forward \u003cstrong\u003elast week’s platforms and score\u003c\/strong\u003e for comparison.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Apify (first call)\u003c\/strong\u003e to check multi-platform ad presence, detect website analytics\/pixels, and fetch hiring signals.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Apify (second call)\u003c\/strong\u003e for \u003cstrong\u003edetailed LinkedIn ad statistics\u003c\/strong\u003e only for companies confirmed to advertise on LinkedIn.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates a 0–100 prospect score\u003c\/strong\u003e from ad activity, platform gaps, LinkedIn activity\/ad types, hiring signals, and tracking installations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI\u003c\/strong\u003e to generate a \u003cstrong\u003eplain-text, three-sentence cold-email opener\u003c\/strong\u003e citing only the measured signals and naming the best \u003cstrong\u003e“ad gap”\u003c\/strong\u003e to pitch.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back to Google Sheets\u003c\/strong\u003e (score, signals, gaps, opener) and \u003cstrong\u003eposts the top five prospects to Slack\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts on week-over-week changes\u003c\/strong\u003e by comparing this week’s results vs last week and posting Slack notifications for starts\/stops in advertising, LinkedIn spend scaling, or new roles.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly lead research for SaaS outreach, using \u003cstrong\u003ead activity + tracking + hiring signals\u003c\/strong\u003e to prioritize ICPs.\u003c\/li\u003e\n  \u003cli\u003eAutomatically drafting outreach openers that reference \u003cstrong\u003emeasured “ad gaps”\u003c\/strong\u003e instead of generic cold email templates.\u003c\/li\u003e\n  \u003cli\u003eKeeping a sales channel current with \u003cstrong\u003eSlack alerts\u003c\/strong\u003e when prospect advertising behavior changes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTriggers: manual run or \u003cstrong\u003eMonday 7am\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eApify\u003c\/strong\u003e (requires an \u003cstrong\u003eApify API token\u003c\/strong\u003e), \u003cstrong\u003eSlack\u003c\/strong\u003e, and \u003cstrong\u003eOpenAI\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003en8n logic nodes: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003esort\u003c\/strong\u003e, \u003cstrong\u003elimit\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46157944324275,"sku":"N8N-20331","price":49.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/rnv2OxwfXbDtHhsjb9O__FTMDf78a.png?v=1791019249","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-score-ad-prospects-draft-cold-emails","provider":"N8N Commerce","version":"1.0","type":"link"}