AI Cold Outreach Automation by victor folorunsoAI Cold Outreach Automation by victor folorunso

AI Cold Outreach Automation

Portfolio project
victor folorunso

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 = emailed
Follow-Up Branch (runs after cold emails):
Reads leads with status = emailed and fewer than 5 follow-ups
Fetches 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 = 0
Step 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.

Tags