Save a LinkedIn profiles's current company headcount to Airtable

Steps:

Bardeen's automation playbook offers a seamless way to capture valuable data from LinkedIn profiles and organize it systematically in an Airtable base. For businesses looking to streamline their lead generation and data sourcing research, this workflow automates the collection of a company's headcount information directly from LinkedIn—saving you time and ensuring accuracy. This playbook is particularly useful for sales prospecting and competitive analysis, as it allows you to keep track of potential clients or competitor growth.

Here's how this workflow captures LinkedIn company headcount and saves it to Airtable:

• Step 1: Scrape LinkedIn Profile - The Scraper is set to run in the background to extract the current company and its LinkedIn page link from a LinkedIn profile you specify.
• Step 2: Prepare LinkedIn Company Link - Bardeen merges the company name with the LinkedIn page link to create a URL that can be used to scrape additional data.
• Step 3: Scrape LinkedIn Company Page - The Scraper then uses the newly created link to visit the company's LinkedIn 'About' page and scrape the headcount data.
• Step 4: Extract Headcount Number - A string containing the headcount is split to isolate the number of employees.
• Step 5: Prepare Data for Airtable - The headcount number is selected from the array and prepared along with the company name and LinkedIn link for Airtable.
• Step 6: Save to Airtable - Finally, the company's name, LinkedIn link, and headcount number are added as a new row to your Airtable base.

The new Bardeen – Find leads no one else does:

With our new Bardeen version, you can easily extract data from any website and discover new leads across the web. After extracting data from a website, use Bardeen’s powerful automation tools to validate and enrich your data, run additional scrapers on linked pages, or leverage AI to qualify leads and generate content automatically. Once your data is ready, you can easily export it to CSV, Google Sheets, Airtable, or Notion for further analysis and reporting.