Generate personalized cold emails with AI and send them automatically

The automation researches each lead, drafts a personalized email with AI, and sends it through Smartlead automatically.

How the work actually flows

A straight line. Runs once per one per lead.

Pattern: Sequence (1) ยท Multiple Instances without Synchronization (12)

flowchart TD trig(["scheduled outreach run"]):::trigtime s0["pull list of leads"]:::task s1[["ai drafts personalized email"]]:::mi s2["send email automatically"]:::task s3[("log send status to sheet")]:::store trig --> s0 s0 -->|"one per one per lead"| s1 s1 --> s2 s2 --> s3 out[/"personalized emails sent and logged"/]:::out pay{{"scalable outreach without manual drafting"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepRuns once per itemA record or sheetResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
Email AutomationSpreadsheet & Database Ops
Connects
Google SheetsSmartleadGoogle GeminiSupabase

The problem it solves

Writing a truly personal cold email for every single lead takes forever, so most outreach ends up generic and gets ignored. You want your prospecting to feel one-to-one without spending your whole day drafting messages.

Who it fits

Sales teams and founders running cold email outreach campaigns.

How it works

  1. On a schedule, the system pulls your list of leads
  2. AI reads each lead's company, role, and industry to write a personal opening line
  3. AI expands that opener into a full email with subject line and call to action
  4. The email sends automatically through Smartlead
  5. Every draft and send status is logged in Google Sheets for review
What you get

Personalized emails sent per lead

Every lead gets a cold email personalized to their company and role, sent automatically through your outreach platform.

What you get

A log of personalized emails sent and tracked, with drafts saved for review.

What you need

A Supabase database, a Smartlead account, a Google Gemini API key, and Google Sheets access.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Turn your Google Sheets data into a searchable AI knowledge base

Pulls your data from Google Sheets and turns it into an AI-searchable knowledge base you can ask questions of.

Advanced

Search your hardware inventory instantly with an AI assistant

An AI assistant searches thousands of inventory items by meaning, so typos and different terms still find the right part.

Advanced

Turn any link into ready-to-post social content across platforms

Send a link on Telegram and get AI-written posts with images automatically published to Facebook, Instagram, and LinkedIn.

Advanced

Turn your website chat into a lead capture and scoring system

A website chatbot answers visitor questions, captures their contact info, and scores each lead automatically.

Advanced
Back to the AI Playbook