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.
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.
| Node | Category | Type | Operation |
|---|---|---|---|
| Process Each Company | Routing | Loop Over Items | See node parameters |
| Get Company Info | Web / API | HTTP Request | See node parameters |
| Filter Valid Companies | Routing | If | See node parameters |
| Is New Company? | Routing | If | See node parameters |
| Set Variables | Transform | Edit Fields | See node parameters |
| Search Companies | Web / API | HTTP Request | See node parameters |
| Extract Company Data | Transform | Split Out | See node parameters |
| Check If Company Exists | Data store | Google Sheets | See node parameters |
| AI Company Scoring | AI & models | Open Ai | See node parameters |
| Wait 2s | Wait | Wait | See node parameters |
| Add Company to CRM | Data store | Google Sheets | append |
| Start | Trigger | Manual Trigger | See node parameters |
Setup
- Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
- Connect your own credentials through n8n’s credential store. Replace
REPLACE_WITH_*values with your resource identifiers. - Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
- 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
googleSheetsOAuth2ApihttpHeaderAuthopenAiApi
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)
-
API Linkedin : Ghost Genius API
-
API Documentation : Documentation
-
CRM : Google Sheet
-
AI : OpenAI
-
LinkedIn Location ID Finder : Ghost Genius Locations ID Finder
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.