Automated Local Lead Finder & Cold Email Sender with Apify, AI, and Gmail
n8n template #8986Summary
Use templateLocal Lead Finder + Cold Email Sender (Form → Apify → AI → Gmail + Google Sheets) Fill a short form with business type, location, and how many leads you want. This workflow finds local businesses, grabs a valid email from each website, writes a cold email in your chosen style, sends it, and logs everything to Google Sheets. Benefits Simple form input (business type, location, lead count, email style) Finds local businesses with Apify and filters only those with a website Scrapes one best email address from each site Writes cold emails with AI (style: Friendly / Professional / Simple) Sends via Gmail and updates Google Sheets with status + send time How It Works Form Submit: Enter Business Ty
Hand off to your agent
Prompt
Help me set up the n8n workflow "Automated Local Lead Finder & Cold Email Sender with Apify, AI, and Gmail" (https://n8n.io/workflows/8986). It uses: Google Sheets, HTTP Request, Gmail, OpenAI Chat Model, Google Gemini Chat Model, Information Extractor. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.
Paste into Claude Code and it will do the rest.
Apps and nodes
Similar workflows
NameViews
- Explore n8n Nodes in a Visual Reference Library5,197
- Automate Customer Support with Gmail, Google Sheets, ERP Data & GPT-4o AI778
- Automated Resume Scoring with Gemini LLM, Gmail and Notion Job Profiles237
- ✨🤖Automate Multi-Platform Social Media Content Creation with AI205K
- AI Powered Web Scraping with Jina, Google Sheets and OpenAI : the EASY way44K
- AI-Generated LinkedIn Posts with OpenAI, Google Sheets & Email Approval Workflow28K
- Create & Upload AI-Generated ASMR YouTube Shorts with Seedance, Fal AI, and GPT-424K
- API Schema Extractor24K