Search LinkedIn Companies, Score with AI, and Add to Google Sheet CRM
detail.loadingPreview
Automate LinkedIn company prospecting, score leads with AI based on predefined criteria, and manage them in a Google Sheet CRM.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow automates the process of finding companies on LinkedIn based on specific targeting criteria. It then uses AI to score these companies based on their potential interest in your product or service, and finally adds them to a Google Sheet serving as your CRM if they meet certain conditions. This is ideal for sales and marketing teams looking to streamline lead generation and qualification.
Key Features
- Dynamically search LinkedIn for companies based on keywords, location, and employee count.
- Filter companies by website existence and follower count.
- Check for existing company entries in a Google Sheet CRM to avoid duplicates.
- Utilize AI (GPT-4.1) for intelligent scoring of company potential based on positive and negative indicators.
- Automatically add qualified and new companies to your Google Sheet CRM.
How To Use
- Configure Credentials: Set up HTTP Header authentication for the LinkedIn API and Google OAuth2 for Google Sheets.
- Set Variables: Customize the 'Set Variables' node with your specific target industry, employee size, location IDs (obtained via the provided GhostGenius tool), your product/service, and AI scoring indicators.
- API Base URL: Ensure your
API_BASE_URLenvironment variable is correctly set for the LinkedIn API. - Google Sheets Setup: Prepare your Google Sheet with a 'Companies' tab and an 'ID' column. Ensure the 'CRM' document ID is correct.
- Run Workflow: Execute the workflow. It will fetch companies, score them, and add them to your Google Sheet CRM.
Apps Used
Workflow JSON
{
"id": "228e2d72-1eee-44f2-a00d-3b43b3d442eb",
"name": "Search LinkedIn Companies, Score with AI, and Add to Google Sheet CRM",
"nodes": 0,
"category": "Sales & Marketing Automation",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 228e2d72-1eee...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Verification Info
Related Integrations
- Google Sheets + Schedule Trigger(394 workflows)
- Google Sheets + Split Out(277 workflows)
- Gmail + Schedule Trigger(270 workflows)
- Google Sheets + Slack(268 workflows)
- Gmail + Google Sheets(245 workflows)
- Google Drive + Google Sheets(203 workflows)
- Form Trigger + Google Sheets(163 workflows)
- Google Drive + Google Drive Trigger(135 workflows)
- Google Drive + Split Out(134 workflows)
- Gmail + Split Out(132 workflows)
Related Workflows
Discover more workflows you might like
Leadfeeder Enrichment to Google Sheets
Enrich Leadfeeder accounts with Clearbit and save the data to Google Sheets.
Automate Personalized Sales Outreach Using LinkedIn and Twitter Data
This workflow automates personalized sales outreach by fetching leads from Google Sheets, gathering their LinkedIn and Twitter activity, and using AI to draft a compelling cover letter. It then sends the personalized email, streamlining your sales process.
Automate Instagram Reel Analysis with Gemini and Apify
Unlock deeper insights into your Instagram Reels by automating analysis. This workflow leverages Apify to fetch reel data and Gemini AI to dissect key elements like background, pose, text, and context, enabling better content replication.
Telegram Profanity & Toxicity Filter
This n8n workflow automatically monitors incoming Telegram messages for profanity and toxic language. It leverages Google's Perspective API to analyze message content, and if a message is deemed inappropriate, the workflow sends an automated warning response back to the sender.
Automate Competitor Tracking with Crunchbase & ClickUp
Streamline competitor analysis by automatically fetching data from Crunchbase and creating review tasks in ClickUp. Stay informed about market changes without manual effort.
Convert Any Webpage to PDF and Save Locally
This n8n workflow provides a simple way to convert any public webpage URL into a PDF document. Once converted, the PDF file is automatically saved to your local disk, making it easy to archive or share web content offline.