Generate and enrich local business leads with Decodo, OpenAI and Gmail

End-to-End Local Business Lead Generation, Enrichment and Outreach Pipeline with Decodo

This workflow finds local business leads on Google Maps, enriches them with website and AI analysis, and sends personalized cold emails to qualified prospects automatically.

Who’s it for? This template is for agencies, freelancers, B2B growth teams, and sales operators who want a repeatable outbound lead generation system for local business prospecting.

How it works The workflow starts on a schedule and loads the search, scoring, and sender settings from one configuration node. Decodo scrapes Google Maps search results for businesses that match your niche and city. The workflow extracts lead details such as business name, address, phone number, website, and rating, then stores each lead in Google Sheets. Each discovered lead is checked for a website. If no website is available, the lead is marked and skipped from enrichment. For leads with a website, Decodo scrapes the site and OpenAI scores the business, summarizes it, and suggests enrichment fields such as business type, pain points, and contact email. The workflow updates the lead in Google Sheets with the enrichment data. Enriched leads are filtered by score threshold, website presence, email availability, and contact status. For each qualified lead, the workflow scrapes more website content and uses OpenAI to write a personalized outreach email. Gmail sends the email, and the lead is marked as contacted in Google Sheets.

How to set up Add credentials for Decodo, OpenAI, Google Sheets, and Gmail. Replace the placeholder Google Sheet ID in the configuration node. Create a Leads sheet with all required columns used in the workflow. Update the niche, city, geo, max leads, score threshold, and sender fields. This template uses the Decodo community node, so it is intended for self-hosted n8n only. Replace the placeholder image above with a real workflow screenshot before submission.