Enrich LinkedIn profiles in Airtable with Apify’s LinkedIn scraper

Description

Who it's for

This workflow is for sales teams, recruiters, and growth operators who maintain a list of LinkedIn profile URLs in Airtable and want to automatically enrich each record with detailed professional data — without manual copy-pasting.

How it works

The workflow is triggered manually and queries Airtable to fetch all records matching a defined filter (e.g. records with an empty "First name" field).
It loops over each record one by one using a batch iterator.
For each record, it sends the LinkedIn profile URL to the Apify LinkedIn scraper API via a POST request and waits for the result.
The enriched data (name, headline, job title, company, location, skills, positions, education, certifications, follower count, and more) is written back to the corresponding Airtable record.
The loop continues until all records have been processed.

How to set up

[ ] Connect your Airtable credentials in both the Search Records and Update LinkedIn Data nodes
[ ] Configure the correct Airtable base, table, and filter formula
[ ] Obtain an Apify API key and connect it in the Fetch LinkedIn Profile via Apify node
[ ] Ensure your Airtable table has a LinkedIn URL field populated with valid profile URLs
[ ] Review and adjust the field mappings in the Update LinkedIn Data node to match your schema

Requirements

Airtable account with API access
Apify account with access to the LinkedIn Profile Scraper actor

How to customize

Adjust the batch size in Loop Over Records in Batches to control request rate and avoid Apify rate limits
Add an error-handling branch after the HTTP Request node to flag failed lookups directly in Airtable
Replace the manual trigger with a scheduled trigger to run enrichment automatically on new records