apollo-enrichment

Apollo Enrichment

Take a list of leads in an Airtable table and find verified emails for as many as possible via Apollo's bulk match endpoint. Updates the Airtable rows in place with email + company + title + location, and creates Apollo contacts under a named label so the leads land in your Apollo CRM workflows. Match rate is highly audience-dependent - expect 50-70% on US founder / operator audiences, lower on consumer or non-US audiences.

When to use

• "Enrich these leads with Apollo: ".
• "Find emails for the rows in this table".
• Phase 3 of either LinkedIn pipeline (called by the orchestrator).
• You have an Airtable table populated with Profile URLs and want emails attached.

When NOT to use

• The leads aren't in Airtable yet - load them first with airtable-lead-loader.
• You only want to read Apollo data, not modify Airtable - this skill writes back to Airtable as part of its contract; if you only need a one-shot Apollo lookup, do it manually.

Connections I need

• Airtable (database) - Required. I read the rows, then write the enrichment fields back.
• Apollo (enrichment) - Required. I use the apollo_people_bulk_match endpoint and the apollo_contacts_create endpoint via Composio.

If either is missing I stop and ask you to connect it.

Information I need

• The Airtable base ID + table ID - Required. If called from an orchestrator, both are passed in. If called standalone, I list bases and tables and ask which one if there's any ambiguity.
• An Apollo contact label - Optional. Defaults to LinkedIn {sourceType} - {sourceAuthor} Post, derived from the table's Source Type and Source Author fields (every row in a given table has the same source). Override per call.

Steps

1. Pull all records. Page through the Airtable table 100 records at a time until done. Collect rows where Email is empty (don't re-enrich rows that already have an email). Stash the source Profile URL, Full Name, Headline, and Airtable record_id for each.