About

I need an Airtable script to auto-identify LinkedIn engagers via Apollo. (Open to alternative solutions that are easier to implement or have higher accuracy) ** What I’m doing** - Tracking contacts who like my LinkedIn posts - I paste the list of engagers into Airtable - Paste gives me first name, last name or initial, job title, the LinkedIn mini-profile description, sometimes company - If a contact only shows an initial, I manually open their profile and paste the LinkedIn URL into Airtable **What I want** I want to record contacts and identify them without having to open every LinkedIn profile first. I want an Airtable script that uses the Apollo.io API to identify people faster than looking up each one manually. **Scope** In an Airtable Automation script: 1. Check whether the contact in Cleaning table already exists in another Airtable table called Engagers. If it does, then create a link to that contact. 2. If a new contact in Cleaning table already has a LinkedIn URL, call Apollo People Match to confirm and pull title and company, then link to new contact in Engagers table 3. Otherwise, → call Apollo People Search to find a person from these inputs: full name or initials, job title, description tokens, optional company Limit search to a short list of countries I provide – AU, NZ, SE Asia, US, UK Write back to Airtable: suggested LinkedIn URL, suggested company, confidence score, a simple verify flag Only attempt enrichment when I don’t already have a match, with a cooldown to avoid repeat calls **Tables exist** Posts, Cleaning, Engagers. Cleaning holds pasted engagers per post. Engagers should stay one row per person linked to many posts **Deliverables** Working Airtable Automation with a clean JavaScript file Minimal fields added only if needed 10–20 sample records tested One-pager on how to change countries and thresholds **Nice to have** Simple “find existing Engager first” check so we skip API calls for known people Logging of last attempt date and attempt count **Budget and time** For an expert in Airtable scripting and Apollo – 4–8 hours including setup, test, and handover Fixed price preferred with hourly for minor tweaks **Tell me in your proposal** Two similar Airtable or Apollo projects How you will avoid wasting API credits When you can start **Docs** Apollo People Search: https://docs.apollo.io/reference/people-search Apollo People Match: https://docs.apollo.io/reference/people-match Airtable Run a script: https://support.airtable.com/docs/run-a-script-action Airtable Automations overview: https://support.airtable.com/docs/automations-overview