Angi Roofing Leads Scraper: n8n + Apify, SerpApi & Hunter

Automatically scrape Angi roofing contractor leads every day—dedupe, enrich, and store them in Google Sheets with Slack alerts

This n8n workflow (“Angi Roofing Leads Scraper: n8n + Apify, SerpApi & Hunter”) runs on a daily schedule to pull Angi roofing contractor profiles, removes duplicates against your existing lead list, enriches new leads with a likely website domain and contact email, and then appends everything to Google Sheets—with Slack notifications for new vs. skipped leads.

What this workflow does

• Daily scheduled run: Starts via a daily schedule trigger.
• Scrape from Apify: Calls the Apify API to scrape Angi roofing contractor profiles for Austin, TX, normalizing results and removing duplicates within the same scrape batch.
• Dedupe against Google Sheets: Loads existing leads from the Google Sheets “Leads” tab and flags scraped records that match by proId, phone, or a fallback key (name + location).
• Enrich with SerpApi: Sends new leads to SerpApi (Google Search) to discover a likely company domain while skipping common directory and social sites.
• Find email with Hunter: If a domain is found, queries the Hunter Domain Search API and selects the best available email based on seniority/title; otherwise the lead is marked as phone-only.
• Save + notify: Appends finalized leads to Google Sheets and posts to Slack when a new lead is saved, plus a separate message when a duplicate is skipped.

Use cases

• Roofing sales ops teams building a steady stream of qualified contractor leads for outreach.
• SaaS operators automating lead capture workflows with n8n + Google Sheets and team alerts.
• Automation engineers who need reliable deduplication and enrichment pipelines using Apify, SerpApi, and Hunter.

Technical details

• n8n nodes/logic: if, set, code, http request, slack, and supporting notes.
• Integrations: Apify (HTTP Header Auth), SerpApi, Hunter, Google Sheets OAuth2, and Slack OAuth.
• Setup includes replacing REPLACE_WITH_SHEET_ID and ensuring the Google Sheets sheet name is correct.