← All N8N workflows
AI & researchGoogle SheetsHTTP RequestIfManual TriggerOpen Ai

Search LinkedIn companies, Score with AI and add them to Google Sheet CRM

Configured with Google Sheets, HTTP Request, Open Ai, Loop Over Items, and additional nodes. Review the connections and setup before adapting this template.

Workflow preview
RoutingProcess Each CompanyLoop Over ItemsWeb / APIGet Company InfoHTTP RequestRoutingFilter Valid CompaniesIfRoutingIs New Company?IfTransformSet VariablesEdit FieldsWeb / APISearch CompaniesHTTP RequestTransformExtract Company DataSplit OutData storeCheck If Company ExistsGoogle SheetsAI & modelsAI Company ScoringOpen AiWaitWait 2sWaitData storeAdd Company to CRMGoogle SheetsTriggerStartManual Trigger

Node categories in this workflow

  • Routing
  • Web / API
  • Transform
  • Data store
  • AI & models
  • Wait
  • Trigger

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
Process Each CompanyRoutingLoop Over ItemsSee node parameters
Get Company InfoWeb / APIHTTP RequestSee node parameters
Filter Valid CompaniesRoutingIfSee node parameters
Is New Company?RoutingIfSee node parameters
Set VariablesTransformEdit FieldsSee node parameters
Search CompaniesWeb / APIHTTP RequestSee node parameters
Extract Company DataTransformSplit OutSee node parameters
Check If Company ExistsData storeGoogle SheetsSee node parameters
AI Company ScoringAI & modelsOpen AiSee node parameters
Wait 2sWaitWaitSee node parameters
Add Company to CRMData storeGoogle Sheetsappend
StartTriggerManual TriggerSee 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

  • googleSheetsOAuth2Api
  • httpHeaderAuth
  • openAiApi

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 (this node also allows you to customize the AI Lead Scoring prompt).

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.

The last two modules 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.

AI Scoring and Storage

AI Scoring and Storage

This section scores the company and stores it in a Google Sheet.

It's important to properly fill in the "Set variables" node at the beginning of the workflow to get a result relevant to your use case. You can also manually modify the system prompt.

Regardless of the score obtained, it's very important to always store the company. Note that we add a 2-second "wait" module to respect Google Sheet's rate limits.

We add the company to the "Companies" sheet in this Google Sheet which you can make a copy of and use.

This AI scoring functionality is extremely impressive once perfectly configured, so I recommend taking some time to test with several companies to ensure the scoring system works well for your needs!

Introduction

Introduction

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

This automation is an alternative version of this template that differs by using Google Sheets instead of Airtable and adding a Lead Scoring system allowing for more precision in our targeting.

This automation therefore allows you, starting from a LinkedIn search, to enrich company data and score them to determine if they might be interested in your services/product.

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 a copy of this Google Sheet by clicking on File => Make a copy (in Google Sheet).

  • Configure your Google Sheet credential by following the n8n documentation.

  • Create an OpenAI key here and add the credential to the "AI Company Scoring" node following the n8n documentation.

  • Add your information 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, Score with AI and add them to Google Sheet CRM

Search LinkedIn companies, Score with AI and add them to Google Sheet CRM

Purpose and structure

This folder contains the Search LinkedIn companies, Score with AI and add them to Google Sheet CRM workflow. Its executable nodes use googleSheets, httpRequest, if, manualTrigger, openAi, set, splitInBatches, splitOut, wait. 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

Start

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/Wait/1465_Wait_Splitout_Create_Webhook.json MIT; preserve source notices.

More in AI & research