Quick overview
This workflow runs from an n8n form to collect a lead-gen campaign, searches Google Maps via Apify, enriches contacts using website scraping and Outscraper, qualifies leads, generates Gemini sales insights for high-fit prospects, and stores campaigns and leads in Notion.
How it works
- Receives campaign details from an n8n form submission and creates a Campaign record in Notion.
- Builds a Google Maps search query and uses Apify’s Google Maps actor to retrieve business listings.
- Normalizes results, handles empty searches, and removes duplicate leads by a stable lead key.
- For each unique lead, checks Notion to skip businesses already stored globally.
- Enriches each new lead by scraping the business website for emails and contact/social links, and falls back to Outscraper to find contacts when needed.
- Scores and labels each lead (high fit, low fit, or rejected) based on available contact signals.
- Sends only high-fit leads to Google Gemini to generate structured sales insights and an outreach message, then creates the Lead record in Notion.
- Queries all campaign leads in Notion, computes run metrics (stored, enriched, high-fit, insights generated), and marks the campaign as Done.
Setup
- Create or select a Notion database that contains the Campaign and Lead properties used by the workflow, then add a Notion API credential.
- Replace
REPLACE_WITH_NOTION_DATA_SOURCE_ID in the Configuration step with your Notion data source (database) ID.
- Install and authenticate the Apify community node and provide an Apify API token.
- Install and authenticate the Outscraper community node and provide an Outscraper API token.
- Add a Google Gemini (PaLM) API credential for the LangChain Gemini chat model used to generate sales insights.
- Review and adjust the form defaults (max results and qualification threshold) and the lead scoring rules and Gemini prompt text for your niche.