Generate roofing contractor leads from Google Maps with ScrapeOps, Sheets and Slack
UnknownWhat this workflow does
This workflow has 12 nodes and runs when someone submits an n8n form (“Tell Which City”). Along the way it connects Google Sheets, Slack, Gmail and Scrapeops (community).
How it runs
Trigger: When someone submits an n8n form (“Tell Which City”).
- Set Google Maps Configuration (Edit Fields (Set)): sets or maps fields
- Scrape Ops: uses Scrape Ops
- Parse Business Listings (Code): runs custom JavaScript code
- Scrape Ops: uses Scrape Ops
- Parse Full Business Info (Code): runs custom JavaScript code
- Read Previous Entries from Sheet (Google Sheets): uses Google Sheets
- Compare & Deduplicate Leads (Code): runs custom JavaScript code
- Filter New Leads Only (If): checks a condition and branches into true / false
- Save New Leads to Sheet (Google Sheets): append
- Send Gmail Alert (Gmail): uses Gmail
…plus 1 more step. See the full node list below.
Services it uses
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @scrapeops/n8n-nodes-scrapeops is verified or supports 3.0 (used in ScrapeOps: Search Google Maps, ScrapeOps: Fetch Business Details).
Nodes used (8)
- Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if - n8n Form Trigger
n8n-nodes-base.formTrigger - Scrape Ops
@scrapeops/n8n-nodes-scrapeops.ScrapeOps
From the author
Overview This n8n template automates finding roofing contractors in any city using Google Maps. It deep-scrapes listings via ScrapeOps Proxy, deduplicates results against Google Sheets, saves fresh leads, and sends alerts via Gmail and Slack - all triggered…