🔓 Unlock all 10,000+ workflows & prompts free Join Newsletter →
✅ Full access unlocked — explore all 10,000 AI workflow and prompt templates Browse Templates →
Home › n8n › Workflow
January 22, 2026

LinkedIn + Google Sheets: leads scored and messaged

LinkedIn + Google Sheets: leads scored and messaged - n8n workflow automation template
Lisa Granqvist Partner Workflow Automation Expert
LinkedIn + Google Sheets: leads scored and messaged - n8n workflow automation template
Get a free AI assessment → Get a free AI assessment → ⬇️ Use template

LinkedIn lead gen usually falls apart in the boring parts. Copying profiles into a sheet, skimming company sites, guessing who’s “worth” messaging, then rewriting the same outreach for the tenth time.

Marketing ops teams feel this when the pipeline looks busy but conversions don’t move. A solo founder feels it when “quick prospecting” turns into a two-hour rabbit hole. And agencies running outbound for clients? Same mess, bigger volume. This LinkedIn lead scoring automation pulls prospects into Google Sheets, enriches them with OpenAI, then drafts messages you can approve.

Below, you’ll see exactly what the workflow does, what you get out of it, and where teams usually trip up when they try to automate LinkedIn outreach.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: LinkedIn + Google Sheets: leads scored and messaged

The Problem: LinkedIn Prospecting Becomes Busywork

Finding good prospects on LinkedIn is not the hard part. The hard part is everything you do after you find them. You open ten tabs, scan a site for clues, read a few posts, try to guess intent, then paste scraps into a spreadsheet that no one trusts. Next day, you can’t remember why Lead #14 looked promising, so you re-research them. It’s exhausting, and it quietly kills consistency, which is what outbound needs to work at all.

It adds up fast. And the friction compounds once you try to scale beyond a handful of leads.

  • Prospect data ends up scattered across LinkedIn tabs, notes, and half-filled rows in Google Sheets.
  • Lead quality is decided by gut feel, so two people will score the same profile very differently.
  • Personalized messaging turns into a template factory, which means replies drop and you end up blaming the offer.
  • Manual follow-ups break the moment your week gets busy, and the “pipeline” goes stale overnight.

The Solution: Turn an ICP Into Scored Leads and Drafted Outreach

This workflow takes you from “Here’s who we want to target” to “Here are the best leads, ranked, with outreach drafted” without living inside LinkedIn all day. You start by giving the AI Agent your Ideal Customer Profile in plain English (for example, “marketing directors at SaaS companies with 50–200 employees”). The workflow converts that ICP into LinkedIn search parameters, finds matching prospects, and saves the structured lead data into Google Sheets. Then it enriches each lead by pulling context from sources like the company website, relevant posts, and recent mentions, and asks OpenAI to evaluate intent signals. Finally, it scores each lead on a 1–10 scale and prepares connection requests and follow-up messages, so you can move quickly while keeping control.

The workflow starts with an ICP prompt (often sent via Telegram or a webhook, depending on how you prefer to kick it off). It gathers prospects, merges and cleans fields, and loops through leads in batches to stay stable. Then OpenAI generates both a lead score and an outreach draft, and the workflow can send messages to the top-scoring leads once your connection is accepted.

What You Get: Automation vs. Results

Example: What This Looks Like

Say you want to message 40 new LinkedIn prospects a week. Manually, if you spend about 8 minutes collecting basics and another 7 minutes skimming for context and writing a first message, that’s roughly 10 hours. With this workflow, you spend maybe 15 minutes writing or tweaking your ICP prompt, then let it run in batches while it fills Google Sheets, scores leads, and drafts outreach. You still review before sending, but the heavy lifting is done, so your “prospecting day” becomes a short review session instead of a half-day project.

What You’ll Need

  • n8n instance (try n8n Cloud free)
  • Self-hosting option if you prefer (Hostinger works well)
  • Google Sheets to store and review leads.
  • OpenAI to enrich context, score, and draft messages.
  • AnySite API key (get it from your AnySite.io dashboard)

Skill level: Intermediate. You’ll connect credentials, create a sheet with the right columns, and adjust a couple of prompts to match your offer.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A message, webhook, or scheduled run kicks things off. You provide an ICP description, and the workflow uses it as the single source of truth for targeting. Keep it simple at first. You can tighten it later.

Lead discovery and capture happens next. The LinkedIn search runs, results are cleaned up with basic logic (like “If” rules and field mapping), and leads are written into Google Sheets so you have a visible, auditable list.

Enrichment and scoring happen in a loop. For each lead, the workflow fetches additional context via HTTP requests, merges it into a single view, then asks OpenAI to score the lead (1–10) based on your criteria and the intent signals it finds. Frankly, this is where most teams see the biggest upgrade, because it removes the “who do we do first?” debate.

Outreach is drafted and optionally sent. The workflow prepares connection requests and follow-up messages for high-scoring leads, and it can send messages when a connection is accepted (so you don’t have to babysit timing). You review the drafts in your sheet or notifications, then approve what goes out.

You can easily modify the scoring criteria to match your offer and market based on your needs. See the full implementation guide below for customization options.

Common Gotchas

  • Google Sheets credentials can expire or need specific permissions. If things break, check the Google connection inside n8n credentials first and confirm the sheet is still shared with the same account.
  • If you’re using Wait nodes or external enrichment via HTTP Request, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
  • Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Related Workflows

If your team also needs a simpler “list building first” setup, Google Sheets + LinkedIn, smarter prospect lists pairs nicely, then you can layer scoring and messaging once the data looks clean.

For teams doing outbound at higher volume, Apollo to Instantly.ai, launches faster outreach can handle the sending infrastructure while this workflow focuses on better targeting and message quality.

When replies start landing in your inbox and you want to keep speed without sacrificing personalization, Gmail + Brevo: score leads and draft replies helps you triage and respond while interest is hot.

Need the same “leads plus draft copy” outcome, but sourced from a database instead of LinkedIn search? Apollo to Google Sheets, leads with outreach copy is a strong alternative when you already rely on Apollo.

Finally, if you want to score and route inbound leads the moment they arrive, JotForm + HubSpot: score leads and route fast is a great complement to keep inbound and outbound operating with the same prioritization logic.


Quick reference:

Frequently Asked Questions

How long does it take to set up this LinkedIn lead scoring automation?

Plan on about 60–90 minutes if your accounts and sheet are ready.

Do I need coding skills to automate LinkedIn lead scoring?

No. You’ll mostly connect accounts, paste API keys, and edit a couple of prompts.

Is n8n free to use for this LinkedIn lead scoring workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API usage (often a few dollars a month at low volume).

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this LinkedIn lead scoring workflow for my ICP and messaging style?

Yes, and you should. Swap the ICP prompt inside the AI Agent node, then adjust the scoring prompt in the “Company Score Analysis” step so it reflects what a good-fit lead looks like for you. Most teams also tweak the message template used by the AnySite LinkedIn Send Message action to match brand tone, and they add simple filters (like location or industry) before a lead is allowed to be messaged.

Why is my LinkedIn connection failing in this workflow?

Usually it’s one of three things: the AnySite API key is missing/expired, the AnySite LinkedIn community node isn’t installed correctly, or your LinkedIn account is hitting rate limits. Double-check the AnySite credentials in n8n first, then confirm you’re running on a self-hosted instance (n8n Cloud will not support that community node). If it still fails, slow the workflow down with batching and spacing so requests look more human and you stop getting blocked.

How many leads can this LinkedIn lead scoring automation handle?

On a typical self-hosted setup, hundreds of leads per week is realistic as long as you respect LinkedIn limits (roughly 100–200 connection requests weekly). The workflow itself can process more, but LinkedIn is the bottleneck, so batching and scheduling matter more than raw compute.

Is this LinkedIn lead scoring automation better than using Zapier or Make?

Often, yes, because this kind of workflow needs branching logic, looping in batches, and more control over how data is merged and evaluated. n8n also gives you the option to self-host, which is a big deal when you’re running frequent lead enrichment and don’t want every run metered. The catch is important though: this workflow relies on a community LinkedIn node that won’t run on n8n Cloud, and Zapier/Make may be simpler if you only want to move leads between apps. If you’re unsure, Talk to an automation expert and describe your volume and risk tolerance.

Once this is in place, your Google Sheet becomes the control center: who to contact, why they’re a fit, and what to say next. You keep the judgment. The workflow handles the grind.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Talk to Automation Expert →

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

×

Use template

Get instant access to this n8n workflow Json file

Copy and import json workflow into your n8n workflow

💬
Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.