
AI-Powered Cold Outreach & Follow-Up Automation (with Do...While variant)
Automate the full cold email lifecycle — from intelligently crawling a prospect's website, to AI-writing a personalised email, verifying the address, creating a Gmail draft, and managing up to 5 context-aware follow-ups — all tracked in Google Sheets.
🤖 AI-Powered Cold Outreach Automation
Automate the full cold email lifecycle — from crawling a prospect’s website to writing a personalised email and managing follow-ups.
📌 Who is this for?
Freelancers, agencies, and sales teams doing outbound outreach at scale who want personalised emails without manual research.
⚡ What it does
Cold Email Branch (runs first):
Reads pending leads from Google Sheets
Crawls each lead’s website to understand their business
AI writes a tailored cold email (subject + body + contact email)
Email is verified; Gmail draft is created
Sheet updated to
status = emailedFollow-Up Branch (runs after cold emails):
Reads leads with
status = emailed and fewer than 5 follow-upsFetches the full Gmail thread for context
AI writes a context-aware reply in the same thread
Sheet increments
follow_ups count🔧 Credentials Required
Credential | Used For |
|---|---|
Google Sheets OAuth2 | Read/update lead database |
Firecrawl API | Sitemap crawl + batch scrape + agent |
Groq API | Fast URL filtering |
Google Gemini API | Email generation (both branches) |
Gmail OAuth2 | Create drafts, fetch threads |
VerifiEmail API | Validate email addresses |
📋 Sheet Column Reference
domain · niche · region · email · status · follow_ups🚀 Setup Checklist
Step 1 — Google Sheets
Create a sheet with columns:
domain | niche | region | email | status | follow_ups
Set new leads to status = pending, follow_ups = 0Step 2 — Add All Credentials
Add all 6 credential types in Settings → Credentials before running.
Step 3 — Customise the AI Prompts
Open “✍️ Write Cold Email” → edit the system prompt with:
Your name / company
Your offer / value proposition
Desired tone and length
Open “✍️ Write Follow-Up Email” → same customisation.
Step 4 — Point to Your Sheet
Update the
documentId in any Google Sheets node to your own spreadsheet ID.Step 5 — Test With One Lead
Add a single row with
status = pending and run manually to verify end-to-end.🤖 AI Cold Email Generation
Aggregates all scraped page markdown into a single payload and passes it to a Gemini-powered AI agent. The agent analyses the business and produces a JSON object with
subject, body, and the best contact email it found in the content.🔁 Follow-Up Pipeline
Runs automatically after cold emails. For each lead with
status = emailed and fewer than 5 follow-ups: fetches the full Gmail conversation, summarises it with memory-aware AI, and drafts a context-appropriate reply in the same thread. The follow_ups counter increments each time.Sample Workflow Diagram:
Here's how the AI cold outreach automation workflow functions:
⚠️ Notes
This template contains two complete, identical workflows side by side: Version A (standard) and Version B (Do...While). Choose the version suitable for your setup, then delete the other.
0 likes · 1 view · May 14, 2026
Automate cold outreach and follow-ups for leads using AI.