Find and pitch local business leads with Apify, Firecrawl, OpenAI, Gmail, Sheets and Slack

by Muhammad Hammad ✓ · 81 views · created 2026-09-25 · Lead Generation, AI Summarization

What this workflow does

This AI workflow has 39 nodes and runs when someone submits an n8n form (“Local Business Lead Machine”) (plus 2 other triggers). Along the way it connects Slack, Google Sheets, Gmail and OpenAI Chat Model. It also calls api.apify.com and api.firecrawl.dev over HTTP.

How it runs

Trigger: When someone submits an n8n form (“Local Business Lead Machine”) (plus 2 other triggers).

1. Build Apify Input (Code): runs custom JavaScript code
2. Config (Code): runs custom JavaScript code
3. Slack: uses Slack
4. Apify - Scrape Google Maps (HTTP Request): calls api.apify.com (POST)
5. Get Approved Leads (Google Sheets): uses Google Sheets
6. Normalize & Dedupe (Code): runs custom JavaScript code
7. Has Email? (Filter): keeps only the items that match a condition
8. Got Results? (If): checks a condition and branches into true / false
9. Daily Cap (20) (Limit): keeps the first few items
10. Fetch Website (HTTP Request): calls an HTTP API

…plus 24 more steps. See the full node list below.

Services it uses

SlackGoogle SheetsGmailOpenAI Chat Model

HTTP calls to: api.apify.com, api.firecrawl.dev

Uses Firecrawl. New users get 10% off with our link.

Before you upgrade to n8n 3.0

Nodes used (17)

• n8n Form Triggern8n-nodes-base.formTrigger
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Ifn8n-nodes-base.if
• Slackn8n-nodes-base.slack
• Mergen8n-nodes-base.merge
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Waitn8n-nodes-base.wait
• Google Sheetsn8n-nodes-base.googleSheets
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Filtern8n-nodes-base.filter
• Limitn8n-nodes-base.limit
• Error Triggern8n-nodes-base.errorTrigger
• Gmailn8n-nodes-base.gmail
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi

From the author

Quick overview This workflow collects local business leads from Google Maps via Apify, audits each website using HTTP requests and Firecrawl, scores opportunities, generates outreach copy with OpenAI, saves results to Google Sheets, posts summaries to Slack,…

View the original on n8n.io → Check your own copy