Scrape LinkedIn leads and approve cold emails from Sheets

Finds LinkedIn leads, drafts personalized cold emails with AI, and only sends after you approve them in Google Sheets.

How the work actually flows

It repeats. Repeats ai rewrites rejected email; runs once per each matched lead; a person has to approve before it continues; it retries when a step fails.

Pattern: Structured Loop (21)

flowchart TD trig(("you submit industry keywords")):::human s0["find linkedin leads"]:::svc s1["create hubspot record"]:::task s2[["ai drafts cold email"]]:::mi s3["send email via gmail"]:::task trig --> s0 s0 --> s1 s1 -->|"one per each matched lead"| s2 hg(("you approve in sheets")):::human s2 --> hg hg -->|"approved"| s3 hg -. "sent back" .-> s2 lp{"you approve the draft"}:::gate s3 --> lp lp -. "ai rewrites rejected email" .-> s2 lp -->|"finished"| out out[/"approved personalized email sent"/]:::out pay{{"safe reviewed outbound emails"}}:::pay out --> pay s2 -. "retries on failure" .-> s2 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
A stepAn outside serviceRuns once per itemA personRepeat or finishResultPayoff
Build size
Advanced

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

Business functions
AI Agents & Autonomous SystemsCRM & Sales PipelineEmail AutomationSpreadsheet & Database OpsWeb Scraping & Data CollectionSurvey & Feedback
Connects
LinkedInApifyHubSpotGmailGoogle SheetsOpenAI

The problem it solves

Outbound prospecting means hours of searching LinkedIn, copying details into your CRM, and writing emails that don't sound like a template. Send too fast without review and you risk sounding salesy or hurting your sender reputation.

Who it fits

Sales and business development teams running outbound email campaigns.

How it works

  1. You submit industry keywords through a form or a Google Sheets row
  2. Finds matching LinkedIn leads and pulls valid emails
  3. Creates the company and contact record in HubSpot
  4. AI drafts a personalized cold email for each lead
  5. Sends the email through Gmail once you approve it in Google Sheets, or rewrites it automatically if you reject it
What you get

Cold emails ready the moment you approve them

You get LinkedIn leads found and personalized cold emails drafted, waiting for your yes in a spreadsheet.

What you get

A logged, approved lead list in HubSpot and Google Sheets, with a personalized email sent through Gmail for each one you approve.

What you need

A LinkedIn scraping service, a HubSpot account, a Gmail account, a Google Sheets account, and an OpenAI API key.

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

Score and route new leads automatically with AI and LinkedIn data

AI researches, scores, and routes every new lead so your sales team focuses only on the hottest prospects.

Advanced

Automatically analyze and reply to customer feedback with AI

Reads incoming customer feedback, drafts a personalized reply, and flags anything urgent for your team.

Advanced

Scrape the web for qualified leads by industry automatically

Scrapes the web for companies in your target industry, has AI filter out weak leads, and sends the good ones to your team.

Advanced

Automatically find leads, enrich them, and send personalized outreach

Finds new sales prospects, checks their contact info, and sends them a personalized email and LinkedIn request.

Advanced
Back to the AI Playbook