{"product_id":"angi-roofing-leads-scraper-n8n-apify-serpapi-hunter","title":"Angi Roofing Leads Scraper: n8n + Apify, SerpApi \u0026 Hunter","description":"\u003ch3\u003eAutomatically scrape Angi roofing contractor leads every day—dedupe, enrich, and store them in Google Sheets with Slack alerts\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e (“Angi Roofing Leads Scraper: n8n + Apify, SerpApi \u0026amp; Hunter”) runs on a daily schedule to pull \u003cstrong\u003eAngi roofing contractor profiles\u003c\/strong\u003e, removes duplicates against your existing lead list, enriches new leads with a likely website domain and contact email, and then appends everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—with \u003cstrong\u003eSlack notifications\u003c\/strong\u003e for new vs. skipped leads.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily scheduled run:\u003c\/strong\u003e Starts via a daily schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrape from Apify:\u003c\/strong\u003e Calls the \u003cstrong\u003eApify API\u003c\/strong\u003e to scrape Angi roofing contractor profiles for \u003cstrong\u003eAustin, TX\u003c\/strong\u003e, normalizing results and removing duplicates within the same scrape batch.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDedupe against Google Sheets:\u003c\/strong\u003e Loads existing leads from the Google Sheets \u003cstrong\u003e“Leads”\u003c\/strong\u003e tab and flags scraped records that match by \u003cstrong\u003eproId\u003c\/strong\u003e, \u003cstrong\u003ephone\u003c\/strong\u003e, or a fallback key (\u003cstrong\u003ename + location\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnrich with SerpApi:\u003c\/strong\u003e Sends new leads to \u003cstrong\u003eSerpApi (Google Search)\u003c\/strong\u003e to discover a likely company domain while skipping common directory and social sites.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFind email with Hunter:\u003c\/strong\u003e If a domain is found, queries the \u003cstrong\u003eHunter Domain Search API\u003c\/strong\u003e and selects the best available email based on seniority\/title; otherwise the lead is marked as \u003cstrong\u003ephone-only\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSave + notify:\u003c\/strong\u003e Appends finalized leads to Google Sheets and posts to \u003cstrong\u003eSlack\u003c\/strong\u003e when a new lead is saved, plus a separate message when a duplicate is skipped.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRoofing sales ops teams building a steady stream of \u003cstrong\u003equalified contractor leads\u003c\/strong\u003e for outreach.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators automating lead capture workflows with \u003cstrong\u003en8n + Google Sheets\u003c\/strong\u003e and team alerts.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who need reliable deduplication and enrichment pipelines using \u003cstrong\u003eApify, SerpApi, and Hunter\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes\/logic: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, and supporting notes.\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eApify\u003c\/strong\u003e (HTTP Header Auth), \u003cstrong\u003eSerpApi\u003c\/strong\u003e, \u003cstrong\u003eHunter\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e, and \u003cstrong\u003eSlack OAuth\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSetup includes replacing \u003cstrong\u003eREPLACE_WITH_SHEET_ID\u003c\/strong\u003e and ensuring the Google Sheets sheet name is correct.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46047358812339,"sku":"N8N-19655","price":50.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Qa8hr2XIGOP86yWT6DxBX_rDD9AllF.png?v=1789636429","url":"https:\/\/buyflowscripts.com\/products\/angi-roofing-leads-scraper-n8n-apify-serpapi-hunter","provider":"N8N Commerce","version":"1.0","type":"link"}