cotera

Airtable Lead Enrichment

Pull leads from your Airtable base, enrich them with Apollo and LinkedIn data, and write everything back automatically.

Lead enrichmentData hygieneOutbound prepCRM sync

The Challenge

Your Airtable base has hundreds of leads with just a name and email. To actually prioritize them, you need title, company size, LinkedIn activity, and more. Manually looking up each lead in Apollo and LinkedIn takes forever, and copy-pasting data back into Airtable is mind-numbing.

What This Prompt Does

Pull Leads

Search Airtable for records matching your criteria

Enrich via Apollo

Get title, company, seniority, and contact info

Get LinkedIn Intel

Pull recent posts and activity for each lead

Write Back

Update each Airtable record with enriched data

The Prompt

The Prompt

Task

Pull leads from an Airtable base, enrich each one with Apollo and LinkedIn data, and write the enriched data back to Airtable.

Input

The user provides:

  • The Airtable base ID and table name containing their leads
  • Which records to enrich (e.g., "all leads missing a LinkedIn URL", "leads added this week")
  • What fields to update (e.g., title, company size, LinkedIn URL, recent posts)

Example: "Enrich all leads in my 'Inbound Leads' table that don't have a LinkedIn URL yet"

Context

Enrichment Strategy

  1. Use @Airtable/Search RecordsName it "Airtable/Search Records" and call it with @Airtable/Search Records to pull leads matching the user's criteria (e.g., filter by empty LinkedIn URL field)
  2. For each lead, use @Apollo/Enrich PersonName it "Apollo/Enrich Person" and call it with @Apollo/Enrich Person with their email or name + company to get full profile data
  3. Use @LinkedIn/Get Profile with PostsName it "LinkedIn/Get Profile with Posts" and call it with @LinkedIn/Get Profile with Posts to get their recent activity and posts
  4. Use @Airtable/Update RecordName it "Airtable/Update Record" and call it with @Airtable/Update Record to write the enriched data back to each record

What to Enrich

From Apollo:

  • Current title and seniority
  • Company name, size, and industry
  • LinkedIn profile URL
  • Phone number (if available)

From LinkedIn:

  • Recent post topics (what are they talking about?)
  • Activity level (active poster vs. lurker)
  • Shared connections

Quality Checks

  • Skip records that already have enrichment data (don't overwrite)
  • Flag leads where Apollo returns no match
  • Note confidence level on each enrichment

Output

For each enriched lead, report:

  • Name and company (confirmed or corrected)
  • Fields updated in Airtable
  • LinkedIn summary: 1-2 sentences on what they post about
  • Skip reason if enrichment failed

End with a summary: "Enriched X of Y leads. Z had no Apollo match."

Example Usage

Try asking:

  • →"Enrich all leads in my Inbound table that are missing a LinkedIn URL"
  • →"Pull the 20 most recent leads from my Sales Pipeline base and enrich them"
  • →"Find all leads where Company Size is empty and fill it in from Apollo"