Airtop + Google Sheets: LinkedIn leads scored fast
You pull a lead list, then spend the next hour bouncing between LinkedIn tabs, guessing job titles, and trying to decide who’s actually worth outreach. It’s messy, slow, and frankly easy to get wrong. LinkedIn lead scoring shouldn’t depend on your mood and caffeine.
This hits growth marketers first, but agency owners and scrappy founders feel it too. You want a clean sheet of leads, a consistent ICP score, and fewer “why did we email that person?” moments.
This workflow uses Airtop to enrich profiles from LinkedIn, calculates an ICP score, then outputs structured lead records into Google Sheets. You’ll see what it automates, what it changes day-to-day, and what you need to run it reliably.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Airtop + Google Sheets: LinkedIn leads scored fast
flowchart LR
subgraph sg0["On form submission Flow"]
direction LR
n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/form.svg' width='40' height='40' /></div><br/>On form submission"]
n1@{ icon: "mdi:play-circle", form: "rounded", label: "When Executed by Another Wor..", pos: "b", h: 48 }
n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Unify Parameters", pos: "b", h: 48 }
n3@{ icon: "mdi:cog", form: "rounded", label: "Extract Person Data", pos: "b", h: 48 }
n4@{ icon: "mdi:cog", form: "rounded", label: "Find Person Linkedin URL", pos: "b", h: 48 }
n5@{ icon: "mdi:cog", form: "rounded", label: "ICP Scoring", pos: "b", h: 48 }
n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Merge"]
n7@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Is corporate email?", pos: "b", h: 48 }
n8@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Is valid Linkedin URL?", pos: "b", h: 48 }
n5 --> n6
n2 --> n7
n0 --> n2
n3 --> n6
n7 --> n4
n8 --> n3
n8 --> n5
n8 --> n6
n4 --> n8
n1 --> n2
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0,n1 trigger
class n7,n8 decision
classDef customIcon fill:none,stroke:none
class n0,n6 customIcon
The Problem: LinkedIn research doesn’t scale
Lead lists are cheap. Clarity is expensive. The moment you try to qualify people manually, you hit the same loop: check the email, open LinkedIn, confirm it’s the right person, scan for seniority and company fit, then paste scraps of context into a spreadsheet you’ll “clean up later.” Later never comes. And when it does, you’re staring at half-filled rows, inconsistent notes, and a team arguing about what “good fit” even means.
It adds up fast. Here’s where it breaks down.
- People slip through because personal emails look “good enough” when you’re moving quickly.
- You end up validating LinkedIn URLs by hand, which gets old after the tenth tab.
- Scoring becomes subjective, so your “top leads” change depending on who reviewed them.
- Your Google Sheet fills with messy fields, which means outreach and reporting stay unreliable.
The Solution: Airtop enrichment + ICP scoring logged to Sheets
This workflow gives you a repeatable way to qualify leads using the same inputs every time: a person’s name, their work email, and an Airtop profile authenticated on LinkedIn. It starts by normalizing whatever data you submit (so “First name / last name” and “full name” don’t become separate headaches). Then it filters out non-corporate emails to keep your list focused on real business identities. After that, Airtop finds and verifies the correct LinkedIn profile, enriches the lead with professional details, and applies your ICP scoring logic based on what it discovers. Finally, everything is merged into one clean record ready to store and act on in Google Sheets.
The workflow can be triggered from a simple form intake or from an upstream workflow that feeds in a batch. From there, Airtop handles LinkedIn discovery and enrichment, while n8n consolidates and formats the output. The end result is a spreadsheet-ready lead row with enrichment plus an ICP score you can sort and trust.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you qualify 30 inbound leads each week. Manually, a quick check is still about 10 minutes per person (find the right LinkedIn profile, confirm role, add notes, and score them), which is roughly 5 hours weekly. With this workflow, you submit the name and work email once, then let Airtop enrich and score while n8n formats the record for Google Sheets. You’ll spend maybe 20–30 minutes reviewing the sorted sheet instead of doing the research yourself.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Airtop for LinkedIn-authenticated profile enrichment
- Google Sheets to store clean lead rows
- Airtop API Key (get it from your Airtop dashboard)
Skill level: Intermediate. You’ll connect accounts, configure sub-workflows, and confirm field mapping into your Sheet.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A lead comes in from a form or another workflow. The workflow supports two entry points: a form intake trigger for manual submissions and an upstream trigger for piping in leads from another n8n flow.
Inputs are cleaned up so they’re consistent. “Normalize Input Fields” converts whatever you collected into predictable fields (like full name and work email), which keeps enrichment and scoring stable.
Corporate email filtering happens first. If the email looks like a personal domain, it gets excluded early. That one gate prevents you from enriching people who will never be a real business prospect.
Airtop finds, validates, and enriches the LinkedIn profile. Sub-workflows handle LinkedIn URL discovery, validation, and data extraction. Then another sub-workflow calculates the ICP score from the enriched profile context.
Everything is combined into a single record for Google Sheets. “Combine Outputs” merges the enrichment payload and scoring result so you can write one clean row per lead and sort by ICP immediately.
You can easily modify your scoring rules to match your ICP (seniority, industry clues, keywords in the headline) based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Form Trigger
Set up the form entry point so new submissions can start the enrichment flow, and optionally allow upstream workflows to pass in data.
- Add and open Form Intake Trigger.
- Set Form Title to
Linkedin Profile Extractor. - Set Form Description to
<h2>Enrich New User's Data</h2> <p>This automation adds important information about a customer using name and work email address</p> <p>The automation requires an Airtop Profile name that is authenticated on Linkedin. Don't have one? Create a free Profile and log-in to X at Airtop profiles portal.</p>. - In Form Fields, add required fields:
Person Name,Work Email, andAirtop Profile (connected to Linkedin). - Open Upstream Workflow Trigger and confirm Workflow Inputs include
person_name,work_email, andAirtop_profilefor upstream execution.
Step 2: Normalize and Filter Input Data
Standardize incoming field names and filter out non-corporate emails before running enrichment.
- Open Normalize Input Fields and add three assignments.
- Set Person_name to
={{ $json["Person Name"] || $json.person_name }}. - Set Work_email to
={{ $json["Work Email"] || $json.work_email }}. - Set Airtop_profile to
={{ $json["Airtop Profile (connected to Linkedin)"] || $json.Airtop_profile }}. - Open Corporate Email Filter and keep the nine conditions that exclude personal domains, using Ignore Case set to
true.
={{ $json.Work_email }} against common personal domains and TLDs. Ensure the incoming email is correctly mapped in Normalize Input Fields to avoid false negatives.Step 3: Configure Sub-Workflows and LinkedIn Validation
Pass normalized data into sub-workflows and validate LinkedIn URL results before parallel enrichment.
- Open Run Sub-Workflow (Configure Required) 1 and select the target workflow in Workflow (currently empty).
- In Run Sub-Workflow (Configure Required) 1, set Person_info to
={{ $json.Person_name }} - {{ $json.Work_email }}and Airtop_profile to={{ $json.Airtop_profile }}. - Open LinkedIn URL Validation and confirm it checks
={{ $json.data.modelResponse }}for Not Empty and Not Starts WithNA. - Open Run Sub-Workflow (Configure Required) 2 and set Linkedin_URL to
={{ $('Run Sub-Workflow (Configure Required) 1').item.json.data.modelResponse }}and Airtop_profile to={{ $('Normalize Input Fields').item.json.Airtop_profile }}. - Open Run Sub-Workflow (Configure Required) 3 and set Linkedin_URL to
={{ $('Run Sub-Workflow (Configure Required) 1').item.json.data.modelResponse }}and Airtop_profile to={{ $('Normalize Input Fields').item.json.Airtop_profile }}.
LinkedIn URL Validation outputs to both Run Sub-Workflow (Configure Required) 2 and Run Sub-Workflow (Configure Required) 3 in parallel, and also to Combine Outputs in parallel.
Step 4: Merge Enrichment Results
Combine outputs from the parallel enrichment branches into a single stream.
- Open Combine Outputs and set Number of Inputs to
3. - Confirm that Run Sub-Workflow (Configure Required) 2 connects to input 1, LinkedIn URL Validation connects to input 2, and Run Sub-Workflow (Configure Required) 3 connects to input 3.
Step 5: Test and Activate Your Workflow
Validate the workflow end-to-end and enable it for production use.
- Click Execute Workflow and submit the form in Form Intake Trigger with a corporate email and a valid Airtop profile.
- Verify Normalize Input Fields outputs standardized fields and Corporate Email Filter passes the record.
- Confirm LinkedIn URL Validation routes valid outputs to both Run Sub-Workflow (Configure Required) 2 and Run Sub-Workflow (Configure Required) 3 in parallel.
- Check Combine Outputs contains merged results from all three inputs.
- Toggle the workflow Active to enable production runs.
Common Gotchas
- Airtop credentials can expire or need specific permissions. If things break, check your Airtop API key status and LinkedIn-authenticated profile session first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Google Sheets writes fail more often than people expect because of header changes. If you rename columns, re-check your field mapping or you’ll get blanks in the exact rows you care about.
Frequently Asked Questions
About 45 minutes if your Airtop and Google Sheets are ready.
No. You’ll connect Airtop and Google Sheets, then configure the sub-workflows. The only “technical” part is deciding your scoring rules.
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 Airtop API usage based on how many profiles you enrich.
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.
Yes, and you should. Most teams tweak the scoring inside the “Run Sub-Workflow (Configure Required) 3” scoring sub-workflow, then adjust what gets merged in “Combine Outputs.” Common customizations include weighting job titles, filtering for specific industries, and giving extra points for keywords in the headline or “About” section.
Usually it’s an expired Airtop API key or a LinkedIn-authenticated Airtop profile that lost its session. Regenerate the key (if needed), confirm the profile is still authenticated on LinkedIn, then re-run a single test lead through the flow. If the failure only happens in batches, you may be hitting rate limits or validation returning no LinkedIn URL, which causes downstream enrichment to fail.
If you self-host n8n, there’s no hard execution limit (it depends on your server and Airtop limits). On n8n Cloud, your monthly execution cap depends on the plan, so high-volume enrichment is usually where teams upgrade. Practically, process leads in batches so you can handle slow LinkedIn lookups without timeouts.
Often, yes. This workflow uses multiple gates (normalize, email filter, URL validation), plus sub-workflows and merging, which is the kind of logic that gets awkward and expensive in Zapier. n8n also gives you the option to self-host, so you’re not paying more just because you processed more leads. That said, if your process is just “new row in a sheet → send an email,” Zapier or Make can be quicker to set up. For LinkedIn enrichment and scoring specifically, n8n is usually the more flexible choice. Talk to an automation expert if you want help picking the simplest path.
Once this is in place, lead qualification stops being a daily grind and becomes a dependable system. Clean rows, consistent scores, and a list you can act on.
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.
