Search LinkedIn Companies and Add them to Airtable CRM

This n8n workflow automates the process of searching for companies on LinkedIn and then adding their details to an Airtable CRM base. It's designed to help sales, marketing, or research teams efficiently populate their CRM with company information found on LinkedIn, ensuring data consistency and reducing manual entry.

What it does

This workflow performs the following steps:

1. Manual Trigger: The workflow is initiated manually, allowing you to control when the search and data addition process begins.
2. HTTP Request (LinkedIn Search): It sends an HTTP request to a LinkedIn search API (or a similar service that provides LinkedIn company data) to find company information based on predefined criteria.
3. Split Out: The results from the LinkedIn search are processed, and individual company records are extracted for further handling.
4. Loop Over Items: Each company record is then processed individually in a loop.
5. Edit Fields (Set): For each company, relevant fields are extracted and formatted to match the structure of your Airtable CRM. This step ensures data cleanliness and consistency before insertion.
6. If (Check for Existing Company): Before adding a company, the workflow checks if a company with the same name already exists in your Airtable CRM.
   • If TRUE (Company Exists): If a matching company is found, the workflow does nothing or could be extended to update the existing record.
   • If FALSE (Company Does Not Exist): If no matching company is found, the workflow proceeds to add the new company.
7. Airtable (Create Record): The details of the new company are then added as a new record to your specified Airtable base.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• LinkedIn Search API Access: Access to an API that can search for LinkedIn company profiles and return structured data. (The specific API endpoint and authentication details will need to be configured in the "HTTP Request" node).
• Airtable Account: An Airtable account with a CRM base set up.
• Airtable API Key: An Airtable API key for authentication.
• Airtable Base ID: The ID of your Airtable CRM base.
• Airtable Table Name: The name of the table within your Airtable base where company records will be stored.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Airtable:
     • Locate the "Airtable" node.
     • Click on "Credentials" and add your Airtable API Key.
     • Specify the "Base ID" and "Table Name" where you want to add company records.
   • HTTP Request (LinkedIn Search):
     • Locate the "HTTP Request" node.
     • Configure the URL, authentication (e.g., API key in headers or query parameters), and any other necessary parameters for your LinkedIn search API.
3. Configure Search Logic:
   • In the "HTTP Request" node, adjust the request body or query parameters to define how you want to search for companies on LinkedIn (e.g., by industry, size, keywords).
4. Configure Data Mapping:
   • In the "Edit Fields" (Set) node, ensure the fields being extracted and renamed match the column names in your Airtable CRM table.
5. Configure "If" Node:
   • The "If" node is set up to check if a company with the same name already exists in Airtable. Review and adjust the condition if your matching logic is different (e.g., matching by website URL instead of name).
6. Activate the Workflow: Once all configurations are complete, activate the workflow.
7. Execute the Workflow: Click the "Execute Workflow" button on the "Manual Trigger" node to run the workflow and start populating your Airtable CRM.