← All N8N workflows
Data & databasesAirtableHTTP RequestIfManual TriggerEdit Fields

Search LinkedIn companies and add them to Airtable CRM

Configured with Airtable, HTTP Request, Loop Over Items, Split Out. Review the connections and setup before adapting this template.

Workflow preview
TriggerWhen clicking ‘Testworkflow’Manual TriggerRoutingProcess Each CompanyLoop Over ItemsWeb / APIGet Company InfoHTTP RequestRoutingFilter Valid CompaniesIfData storeCheck If Company ExistsAirtableRoutingIs New Company?IfData storeAdd Company to CRMAirtableTransformSet VariablesEdit FieldsWeb / APISearch CompaniesHTTP RequestTransformExtract Company DataSplit Out

Node categories in this workflow

  • Trigger
  • Routing
  • Web / API
  • Data store
  • Transform

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
When clicking ‘Test workflow’TriggerManual TriggerSee node parameters
Process Each CompanyRoutingLoop Over ItemsSee node parameters
Get Company InfoWeb / APIHTTP RequestSee node parameters
Filter Valid CompaniesRoutingIfSee node parameters
Check If Company ExistsData storeAirtablesearch
Is New Company?RoutingIfSee node parameters
Add Company to CRMData storeAirtablecreate
Set VariablesTransformEdit FieldsSee node parameters
Search CompaniesWeb / APIHTTP RequestSee node parameters
Extract Company DataTransformSplit OutSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • airtableTokenApi
  • httpHeaderAuth

Workflow notes

LinkedIn Company Search

LinkedIn Company Search

This section initiates the workflow and searches for your target companies on LinkedIn using the Ghost Genius API.

You can filter and refine your search using keywords, company size, location, industry, or even whether the company has active job postings. Use the "Set Variables" node for it.

Note that you can retrieve a maximum of 1000 companies per search (corresponding to 100 LinkedIn pages), so it's important not to exceed this number of results to avoid losing prospects.

Example: Let's say I want to target Growth Marketing Agencies with 11-50 employees. I do my search and see that there are 10,000 results. So I refine my search by using location to go country by country and retrieve all 10,000 results in several batches ranging from 500 to 1000 depending on the country.

Tips: To test the workflow or to see the number of results of your search, change the pagination parameter (Max Pages) in the "Search Companies" node. It will be displayed at the very top of the response JSON.

Company Data Processing

Company Data Processing

This section processes each company individually.

We retrieve all the company information using Get Company Details by using the LinkedIn link obtained from the previous section.

Then we filter the company based on the number of followers, which gives us a first indication of the company's credibility (200 in this case), and whether their LinkedIn page has a website listed.

The workflow implements batch processing with a 2-second delay between requests to respect API rate limits. This methodical approach ensures reliable data collection while preventing API timeouts.

You can adjust these thresholds based on your target market - increasing the follower count for more established businesses or decreasing it for emerging markets.

CRM Integration

CRM Integration

This section handles the Airtable CRM integration.

It first checks if the company already exists in your database (using LinkedIn ID) to prevent duplicates because when you do close enough searches, some companies may come up several times.

If it's a new company, it adds the record to Airtable with comprehensive details including name, LinkedIn URL, website, tagline, description, and category.

The workflow automatically tags companies as 'Growth Marketing Agency 11-50 🌍' and sets the country to '🇺🇸 United States' (customize according to your use case).

Introduction

Introduction

Welcome to my template! Before explaining how to set it up, here's some important information:

This automation is very easy to implement and is designed for anyone wanting to build and enrich a solid CRM through LinkedIn research.

The initial data source can be changed as long as you have the LinkedIn URL of the company.

For any questions, you can send me a DM on my LinkedIn :)

Setup

Setup

  • Create an account on Ghost Genius API and get your API key.

  • Configure the Search Companies and Get Company Info modules by creating a "Header Auth" credential: Name: "Authorization" Value: "Bearer api_key"

  • Create an Airtable base named "CRM" and add at least the following columns: name (default), website (url), LinkedIn (url), id (number).

  • Configure your Airtable credential by following the n8n documentation.

  • Add your company search selection criteria to the “Set Variables” node.

Tools

Tools

(You can use the API and CRM of your choice; this is only a suggestion)

Search LinkedIn companies and add them to Airtable CRM

Search LinkedIn companies and add them to Airtable CRM

Purpose and structure

This folder contains the Search LinkedIn companies and add them to Airtable CRM workflow. Its executable nodes use airtable, httpRequest, if, manualTrigger, set, splitInBatches, splitOut. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

When clicking ‘Test workflow’

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Splitout/1564_Splitout_Manual_Create_Webhook.json MIT; preserve source notices.

More in Data & databases