Build a LinkedIn prospect list with Google Search and Airtable

Searches Google for LinkedIn profiles matching your criteria and saves each one to Airtable automatically.

How the work actually flows

It branches. Exactly one path is taken; runs once per each search result profile.

Pattern: Exclusive Choice (4) · Multiple Instances with a priori Design-Time Knowledge (13)

flowchart TD trig(("you provide search keywords")):::human s0["search google for matching profiles"]:::svc s1[["extract details from each result"]]:::mi s2["check for duplicate prospects"]:::task s3[("add new prospects to airtable")]:::store trig --> s0 s0 -->|"one per each search result profile"| s1 s1 --> s2 gx{"× is the prospect a duplicate"}:::gate s2 --> gx p00["add to airtable"]:::task gx -->|"new prospect"| p00 p10["skip entry"]:::task gx -->|"duplicate prospect"| p10 p00 --> s3 p10 --> s3 out[/"airtable prospect list built"/]:::out pay{{"scales prospecting beyond linkedin limits"}}:::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
A stepAn outside serviceRuns once per itemA personA record or sheetOne path onlyResultPayoff
Build size
Advanced

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

Business functions
Spreadsheet & Database Ops
Connects
Google SearchAirtableLinkedIn

The problem it solves

Manually searching LinkedIn for the right job titles or industries and copying each profile into a spreadsheet takes hours you'd rather spend actually reaching out to people. LinkedIn's own search limits make it hard to find and track prospects at any real scale.

Who it fits

Sales teams, recruiters, and business development professionals building targeted prospect lists.

How it works

  1. You provide keywords for the job titles, industries, or locations you're targeting
  2. The system searches Google for matching LinkedIn profiles
  3. It pulls the name, title, and profile link from each result
  4. It checks for duplicates before saving
  5. New prospects are added to your Airtable base
What you get

Prospects added to your outreach list

You build a targeted LinkedIn prospect list automatically, added straight to Airtable for your team to work.

What you get

An Airtable base of LinkedIn prospects matching your search criteria, with duplicates filtered out.

What you need

A Google Custom Search API key and an Airtable 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