Search LinkedIn companies and add them to Airtable CRM

This workflow automates the process of searching for companies on LinkedIn through the Ghost Genius API, filtering and processing the company data, and then updating or adding records in an Airtable CRM. It is triggered manually for testing purposes and designed to streamline lead generation and CRM enrichment efforts.

The workflow starts with a manual trigger, allowing the user to initiate the search process. It then searches LinkedIn companies based on set criteria like industry, company size, and location, with batched requests to manage API limits.

For each company found, it retrieves detailed information such as website, followers, and description. The data is filtered to include only companies with a valid website and more than 200 followers, indicating credibility.

Next, it checks whether the company already exists in the Airtable CRM using the company ID. If the company is new, it adds a new record with comprehensive details, including LinkedIn URL, website, description, and category. This ensures that the CRM is kept up-to-date with potential leads.

This workflow is particularly useful for sales and marketing teams aiming to automate lead prospecting and data enrichment from LinkedIn into their CRM system, ensuring targeted outreach and efficient data management.