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

Go to Workflow
25,022 views
Built by Matthieu Matthieu
Created on June 06, 2026

Description

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

Setup Video: https://youtube.com/watch?v=m904RNxtF0w&t

Who is this for?
This template is ideal for sales teams, business development professionals, and marketers looking to build a targeted prospect database with automatic qualification. Perfect for agencies, consultants, and B2B companies wanting to identify and prioritize the most promising potential clients.

What problem does this workflow solve?
Manually researching companies on LinkedIn, evaluating their fit for your services, and tracking them in your CRM is time-consuming and subjective. This automation streamlines lead generation by automatically finding, scoring, and importing qualified prospects into your database.

What this workflow does
This workflow automatically searches for companies on LinkedIn based on your criteria, retrieves detailed information about each company, filters them based on quality indicators, uses AI to score how well they match your ideal customer profile, and adds them to your Google Sheet CRM while preventing duplicates.

Setup
Create a Ghost Genius API account and get your API key
Configure HTTP Request nodes with Header Auth credentials
Create a copy of the provided Google Sheet template
Set up your Google Sheet and OpenAI credentials following n8n documentation
Customize the "Set Variables" node to match your target audience and scoring criteria

How to customize this workflow
Modify search parameters to target different industries, locations, or company sizes
Adjust the follower count threshold based on your qualification criteria
Customize the AI scoring system to align with your specific product or service offering
Add notification nodes to alert you when high-scoring companies are identified

Nodes Used (3)

Google Sheets
n8n-nodes-base.googleSheets
HTTP Request
n8n-nodes-base.httpRequest
OpenAI
@n8n/n8n-nodes-langchain.openAi