AI Cold Outreach & CRM Automation — Lead Enrichment, Personalized Email, Reply Tracking
CREATED BY
1 Template
0LAST UPDATED
March 2, 2026INTEGRATIONS USED
DESCRIPTION
This workflow automates your entire cold email outreach pipeline from a raw CSV of leads to a fully logged CRM with no manual work.
It enriches each lead using AI (role, industry, pain points), writes a personalized cold email, checks for duplicates against your existing CRM, sends via Gmail, detects replies, and logs every result to Google Sheets automatically.
Built for agencies, startups, and founders who want more replies without more manual effort.
What it does:
-> Reads leads from a CSV (name, company, email, website)
-> AI enrichment via Gemini: role, industry, pain points, value angle
-> AI email writer: personalized subject and body per lead
-> Duplicate check: skips anyone already in your CRM
-> Sends via your Gmail account
-> Checks for replies at run time
-> Logs everything to Google Sheets with full status tracking
Use cases:
-> Agencies automating outreach for clients
-> Startups scaling lead outreach without hiring SDRs
-> Founders replacing hours of manual email work
Setup time: under 10 minutes. No code required.
HOW DO YOU SET THIS UP?
1.
Connect Apollo API
Authenticate your Apollo account in the Apollo node to enable lead validation and enrichment.
2.
Authorize Gmail
Click the Gmail Sender node, connect your Google account. This is the account emails send from.
3.
Connect Google Sheets
Click each Sheets node (CRM Writer, Enrichment Failures, Email Failures). Paste your sheet URL and map columns
4.
Upload your CSV
CSV needs four columns: name, company, email, website. Upload to the CSV Reader node
5.
Run a test
Use the included sample-leads.csv (3 fake leads) to verify all connections before real data
Hand-picked by the Gumloop team
Similar Templates
467 views
last week
29 views
2 weeks ago
