Find sales leads and draft personalized cold emails automatically

Submit a target role and location, and the system finds leads, writes personalized emails, and logs everything to Sheets.

How the work actually flows

A straight line. Runs once per each lead found.

Pattern: Sequence (1) ยท Multiple Instances with a priori Design-Time Knowledge (13)

flowchart TD trig>"target role and location submitted"]:::trig s0["search and extract matching leads"]:::svc s1[["write personalized cold email"]]:::mi s2[("save leads and drafts to sheet")]:::store s3["send batch completion summary"]:::svc trig --> s0 s0 -->|"one per each lead found"| s1 s1 --> s2 s2 --> s3 out[/"lead list with drafted emails"/]:::out pay{{"faster personalized outreach at scale"}}:::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 itAn outside serviceRuns once per itemA record or sheetResultPayoff
Build size
Advanced

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

Business functions
Lead Generation & ProspectingEmail AutomationSpreadsheet & Database OpsWeb Scraping & Data CollectionSurvey & Feedback
Connects
BrowserActApollo.ioGoogle GeminiGoogle SheetsGmail

The problem it solves

Building a list of sales leads means searching profiles one by one, copying details into a spreadsheet, and then writing a personalized email for each person before you can start outreach. That process takes hours for even a small batch of prospects. Generic, copy-pasted emails also tend to get ignored, so the personalization work matters but is slow to do by hand.

Who it fits

Sales teams and business development reps who need a steady pipeline of researched, personalized leads.

How it works

  1. You submit a target job role and location through a form
  2. The system searches and extracts matching contacts from Apollo.io
  3. AI writes a personalized cold email for each lead based on their role and company
  4. Lead details and email drafts are saved to Google Sheets
  5. You get a Gmail summary confirming the batch is complete
What you get

Personalized cold emails ready for you to send

Submit a target role and location and get researched leads with personalized email drafts logged for you.

What you get

A Google Sheet of verified leads, each paired with a ready-to-send personalized email draft.

What you need

A BrowserAct account, a Google Gemini API key, a Google Sheets account, and a Gmail account.

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

Back to the AI Playbook