Automated local business lead generation with Google Maps & GPT-4
AI-Powered Local Lead Generation Workflow with n8n This workflow solves one of the biggest pain points for freelancers, agencies, and SaaS founders—finding accurate local business leads at scale without manual copy-pasting or unreliable scraping tools. Traditional lead generation is time-consuming and prone to errors. This template automates the entire process so you can focus on outreach, not data gathering. --- ✅ What the Workflow Does Accepts a business type (e.g., plumbers) and city (e.g., Los Angeles) as input Uses AI to generate hyperlocal search terms for full neighborhood coverage Scrapes Google Maps results to extract business details and websites Filters out junk, Google-owned links, and duplicates Scrapes homepage HTML for each business and extracts valid emails using Regex Outputs a clean, deduplicated lead list with business names, websites, and emails --- 🛠 Everything Runs Inside n8n With: OpenAI for AI-driven query generation Zyte API for reliable scraping JavaScript functions for email extraction Built-in filtering and batching for clean results --- 👥 Who is This For? Marketing agencies doing local outreach Freelancers offering SEO, design, or lead gen services SaaS founders targeting SMBs Sales teams scaling outbound campaigns --- ✅ Requirements n8n account (Cloud or self-hosted) OpenAI API key (stored in n8n credentials) Zyte API key (stored securely) Basic familiarity with Google Sheets if you want to export results --- ⚙️ How to Set Up Import the workflow JSON into n8n Go to Credentials in n8n and add OpenAI and Zyte API keys Replace placeholder credential references in the HTTP Request nodes Set your search parameters (business type and city) in the designated Set node Test the workflow with a single search to confirm scraping and email extraction steps Configure batching if you plan to scrape multiple neighborhoods Add an output step (Google Sheets, Airtable, or CRM) to store your leads --- 🔧 How to Customize Update the OpenAI prompt for different search formats (e.g., service + zip code) Adjust the Regex pattern in the JavaScript node for additional email validation rules Add extra filtering logic for niche-specific keywords Integrate with Instantly, HubSpot, or any email-sending tool for full automation
By ShahrukhGenerate personalized cold emails with Anthropic, GPT-4 & Google Sheets
Your Cold Email is Now Researched. This pipeline finds specific bottlenecks on prospect websites and instantly crafts an irresistible pitch --- 🎯 Problem Statement Traditional high-volume cold email outreach is stuck on generic personalization (e.g., "Love your website!"). Sales teams, especially those selling high-value AI Receptionists, struggle to efficiently find the one Unique Operational Hook (like manual scheduling dependency or high call volume) needed to make the pitch relevant. This forces reliance on expensive, slow manual research, leading to low reply rates and inefficient spending on bulk outreach tools. --- ✨ Solution This workflow deploys a resilient Dual-AI Personalization Pipeline that runs on a batch basis. It uses the Filter (Qualified Leads) node as a cost-saving Quality Gate to prevent processing bad leads. It executes a Targeted Deep Dive on successful leads, using GPT-4 for analytical insight extraction and Claude Sonnet for coherent, human-like copy generation. The entire process outputs campaign-ready data directly to Google Sheets and sends a critical QA Draft via Gmail. --- ⚙️ How It Works (Multi-Step Execution) 1\. Ingestion and Cost Control (The Quality Gate) Trigger and Ingestion: The workflow starts via a Manual Trigger, pulling leads directly from Get All Leads (Google Sheets). Cost Filtering: The Filter (Qualified Leads) node removes leads that lack a working email or website URL. Execution Isolation: The Loop Over Leads node initiates individual processing. The Capture Lead Data (Set) node immediately captures and locks down the original lead context for stability throughout the loop. Hybrid Scraping: The Scrape Site (HTTP Request) and Extract Text & Links (HTML) nodes execute the Hybrid Scraping strategy, simultaneously capturing website text and external links. Data Shaping & Status: The Filter Social & Status (Code) node is the control center. It filters links, bundles the context, and critically, assigns a status of 'Success' or 'Scrape Fail'. Cost Control Branch: The If (IF node) checks this status. Items with 'Scrape Fail' bypass all AI steps (saving 100% of AI token costs) and jump directly to Log Final Result. Successful items proceed to the AI core. 2\. Dual-AI Coherence & Dispatch (The Executive Output) Analytical Synthesis: The Summarize Website (OpenAI) node uses GPT-4 to synthesize the full context and extract the Unique Operational Hook (e.g., manual booking overhead). Coherent Copy Generation: The Generate Subject & Body (Anthropic) node uses the Claude Sonnet model to generate the subject and the multi-line body, guaranteeing coherence by creating both simultaneously in a single JSON output. Final Parsing: The Parse AI Output (Code) node reliably strips markdown wrappers and extracts the clean subject and body strings. Final Delivery: The data is logged via Log Final Result (Google Sheets), and the completed email is sent to the user via Create a draft (Gmail) for final Quality Assurance before sending. --- 🛠️ Setup Steps Before running the workflow, ensure these credentials and data structures are correctly configured: Credentials Anthropic: Configure credentials for the Language Model (Claude Sonnet). OpenAI: Configure credentials for the Analytical Model (GPT-4/GPT-4o). Google Services: Set up OAuth2 credentials for Google Sheets (Input/Output) and Gmail (Draft QA and Completion Alert). Configuration Google Sheet Setup: Your input sheet must include the columns email, website\_url, and an empty Icebreaker column for initial filtering. HTTP URL: Verify that the Scrape Site node's URL parameter is set to pull the website URL from the stabilized data structure: ={{ $json.website\_url }}. AI Prompts: Ensure the Anthropic prompt contains your current Irresistible Sales Offer and the required nested JSON output structure. --- ✅ Benefits Coherence Guarantee: A single Anthropic node generates both the subject and body, guaranteeing the message is perfectly aligned and hits the same unique insight. Maximum Cost Control: The IF node prevents spending tokens on bad or broken websites, making the campaign highly budget-efficient. Deep Personalization: Combines website text and social media links, creating an icebreaker that implies thorough, manual research. High Reliability: Uses robust Code nodes for data structuring and parsing, ensuring the workflow runs consistently under real-world conditions without crashing. Zero-Risk QA: The final Gmail (Create a draft) step ensures human review of the generated copy before any cold emails are sent out.
By Bhuvanesh RNews-to-blog automation with GPT, Leonardo AI & WordPress publishing
This workflow automates the end-to-end process of generating and publishing blog posts from live news headlines. Fetch Headlines – Collects the latest top stories from Google News and GDELT, merges them, and removes duplicates. Headline Selection & Classification – Picks top headlines, checks relevance, and applies style rules. Draft Generation – Uses GPT to create an initial blog article in a natural, human tone. Tone & Expansion – Refines the draft for clarity, length, and style (customized to your own writing voice). Image Generation – Sends the article topic to Leonardo AI, waits for the image to finish rendering, and retrieves the final asset. Publish to WordPress – Uploads the generated image, assigns alt-text, creates a WordPress post with the article and image, and logs the publication to Google Sheets for tracking. Purpose Designed for hands-off content automation, this workflow continuously produces SEO-ready blog posts enriched with AI-generated images and publishes them directly to WordPress. It’s ideal for: Running an automated blog that reacts to trending news. Keeping websites updated with fresh, styled content without manual effort. Creating a repeatable content engine that combines research, writing, and media assets in one pipeline. Setup Instructions: Add Your Credentials Go to Credentials in n8n and create: OpenAI (for article generation) Leonardo AI (for image generation) WordPress (to publish posts) (Optional) Google Sheets (to log published articles) Attach these credentials to the matching nodes in the workflow. Check the WordPress Node Update the WordPress site URL to your own blog. Make sure the category, tags, and status (publish/draft) are set the way you want.
By Dean GallopAutomate cancellation feedback collection with Stripe and Google Sheets
Who's it for This template is perfect for any SaaS business or subscription service using Stripe. Product managers, customer success teams, and founders can use this to automatically collect cancellation feedback without manual follow-up. Ideal for companies looking to reduce churn by understanding why customers leave. What it does When a customer cancels their Stripe subscription, this workflow instantly: Detects the cancellation via Stripe webhook Fetches customer details from Stripe API Sends a personalized feedback survey email with embedded customer information Logs all cancellations to Google Sheets for tracking Receives survey responses via webhook Automatically routes feedback to different Google Sheets based on reason (pricing concerns, feature requests, or other feedback) This organized approach helps you identify patterns in cancellations and prioritize improvements that matter most. How it works Stripe triggers the workflow when a subscription is canceled Customer data is fetched from the Stripe API (email, name, plan details) Personalized email is sent with a survey link containing customer data as URL parameters Cancellation is logged to a Google Sheets "Cancellations" tab When the customer submits the survey, a webhook receives the response Feedback is routed to dedicated sheets based on cancellation reason: Price Concerns → for pricing-related issues Feature Requests → for missing functionality Other Feedback → for everything else Set up steps Setup time: ~20 minutes Prerequisites Stripe account (test mode recommended for initial setup) Google account with Google Sheets Email service (Gmail, Outlook, or SMTP) Survey tool with webhook support (Tally or Typeform recommended) Configuration Stripe webhook: Copy the webhook URL from the "Stripe Subscription Canceled" node and add it to your Stripe Dashboard → Webhooks. Select the customer.subscription.deleted event. Email credentials: Configure Gmail, Outlook, or SMTP credentials in the "Send Feedback Survey Email" node. Update the fromEmail parameter. Survey form: Create a survey form with these fields: Hidden fields (auto-populated from URL): email, customer_id, name, plan Visible fields: reason dropdown ("Too Expensive", "Missing Features", "Other"), comments textarea Configure webhook to POST responses to the "Survey Response Webhook" URL Google Sheets: Create a spreadsheet with 4 sheets: "Cancellations", "Price Concerns", "Feature Requests", and "Other Feedback". Connect your Google account in the Google Sheets nodes. Survey URL: Replace [SURVEY_URL] in the email template with your actual survey form URL. Test: Use Stripe test mode to trigger a test cancellation and verify the workflow executes correctly. Requirements Stripe account with API access Google Sheets (free) Email service: Gmail, Outlook, or SMTP server Survey tool: Tally (free), Typeform (paid), or custom form with webhook capability n8n instance: Cloud or self-hosted How to customize Different surveys by plan: Add an IF node after getting customer details to send different survey links based on subscription tier Slack notifications: Add a Slack node after "Route by Feedback Type" to alert your team about price concerns in real-time Delayed email: Insert a Wait node before sending the email to give customers a 24-hour cooldown period CRM integration: Add nodes to sync cancellation data with your CRM (HubSpot, Salesforce, etc.) Follow-up workflow: Create a separate workflow that triggers when feedback is received to send personalized follow-up offers Custom routing logic: Modify the Switch node conditions to match your specific survey options or add more categories Tips for success Use Stripe test mode initially to avoid sending emails to real customers during setup Customize the email tone to match your brand voice Keep the survey short (2-3 questions max) for higher response rates Review feedback weekly to identify patterns and prioritize improvements Consider offering a discount or incentive for completing the survey
By Daiki Takayama