Search LinkedIn companies and add them to Airtable CRM

For Airtable, this workflow automates the process of searching for companies on LinkedIn and adding them to your CRM. It efficiently filters and processes company data, ensuring only valid entries with a minimum of 200 followers and a listed website are included. The integration prevents duplicates by checking existing records before adding new companies, streamlining your lead generation efforts and enhancing your CRM with relevant, credible prospects.

7/8/2025
16 nodes
Complex
manualcomplexsplitinbatchesairtablesticky notesplitoutadvancedapiintegrationlogicconditional
Categories:
Complex WorkflowManual TriggeredData Processing & Analysis
Integrations:
SplitInBatchesAirtableSticky NoteSplitOut

Target Audience

This workflow is ideal for:
- Marketing Professionals: Looking to enrich their CRM with targeted company data from LinkedIn.
- Sales Teams: Aiming to identify potential leads and enhance their outreach efforts.
- Business Development Managers: Seeking to expand their network and discover new business opportunities.
- Entrepreneurs: Wanting to gather information about competitors or potential partners in the market.
- Data Analysts: Interested in automating data collection and processing for better insights.

Problem Solved

This workflow addresses the challenge of manually searching for and collecting company data from LinkedIn. It automates the process of:
- Searching for companies based on specific criteria such as industry, size, and location.
- Filtering out non-credible companies based on follower count and website presence.
- Preventing duplicates in the CRM by checking if a company already exists before adding new entries.
- Saving time and effort by automating data retrieval and entry into Airtable CRM, allowing users to focus on strategic tasks.

Workflow Steps

  • Manual Trigger: The workflow starts when the user clicks ‘Test workflow’.
    2. Set Variables: Users define their target audience, company size, and location for the search.
    3. Search Companies: The workflow sends a request to the Ghost Genius API to search for companies based on the defined criteria.
    4. Extract Company Data: The response is processed to extract relevant company data.
    5. Process Each Company: Each company is processed individually for further details.
    6. Get Company Info: Additional information is retrieved for each company using the LinkedIn URL.
    7. Filter Valid Companies: Companies are filtered based on the presence of a website and a minimum follower count of 200.
    8. Check If Company Exists: The workflow checks Airtable to see if the company already exists.
    9. Is New Company?: If the company is new, it proceeds to add it to the CRM.
    10. Add Company to CRM: The valid company data is added to Airtable with relevant details like name, website, and LinkedIn URL.

    • Customization Guide

    Users can customize this workflow by:
    - Adjusting Search Criteria: Modify the target audience, company size, and location in the ‘Set Variables’ node to fit specific needs.
    - Changing API Endpoints: If using a different API, update the URLs in the ‘Search Companies’ and ‘Get Company Info’ nodes.
    - Modifying Validation Rules: Adjust the filtering conditions in the ‘Filter Valid Companies’ node to change the threshold for follower counts or other criteria.
    - Personalizing Airtable Fields: Customize the fields in the ‘Add Company to CRM’ node to match the user’s Airtable schema.
    - Adding Additional Processing Steps: Include more nodes to enrich the data further or to integrate with other tools.