Airtop + Google Sheets for verified LinkedIn URLs
You’ve got a list of names and companies, and you need the right LinkedIn profile URLs. Then the time sink starts: searching, opening five tabs, second-guessing matches, and still ending up with wrong profiles mixed into your sheet.
SDRs feel it when prospecting targets pile up. Recruiters feel it when candidate lists need verification fast. And ops leads end up policing data quality after the fact. This Airtop Sheets automation fixes the messy middle by finding and validating the best LinkedIn URL for each person.
You’ll see what the workflow does, what you need to run it, and how the process works end-to-end so your lists stay clean without extra admin work.
How This Automation Works
Here’s the complete workflow you’ll be setting up:
n8n Workflow Template: Airtop + Google Sheets for verified LinkedIn URLs
flowchart LR
subgraph sg0["When clicking ‘Test workflow’ Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking ‘Test workflow’", pos: "b", h: 48 }
n1@{ icon: "mdi:database", form: "rounded", label: "Person info", pos: "b", h: 48 }
n2["<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/airtop.svg' width='40' height='40' /></div><br/>Search profile"]
n3["<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/code.svg' width='40' height='40' /></div><br/>Parse response"]
n4@{ icon: "mdi:database", form: "rounded", label: "Update row", pos: "b", h: 48 }
n1 --> n2
n3 --> n4
n2 --> n3
n0 --> n1
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 trigger
class n1,n4 database
class n3 code
classDef customIcon fill:none,stroke:none
class n2,n3 customIcon
Why This Matters: Wrong LinkedIn URLs Poison Your Lead List
Finding a LinkedIn profile sounds easy until you do it at scale. One “John Smith” turns into a ten-minute hunt, then you repeat it 50 times, and suddenly half your day is gone. Worse, you can’t always tell you picked the right person. The wrong URL looks “close enough” in the moment, then it breaks outreach later, confuses recruiters, and makes reporting unreliable. Honestly, it’s the kind of busywork that feels small… right up until it isn’t.
The friction compounds. Here’s where it breaks down most often.
- You end up manually Googling names, then re-Googling them when something feels off.
- Common names cause false matches, which means messages go to the wrong person or the wrong company.
- Copy-paste work introduces silent errors, especially when multiple tabs and similar profiles are open.
- Lists get “dirty” over time, so the team wastes another hour later doing cleanup and deduping.
What You’ll Build: Verified LinkedIn URL Enrichment in Google Sheets
This workflow takes the contact details you already have in Google Sheets (name, company, and any extra context like domain or location) and turns them into verified LinkedIn profile URLs. You manually start the run when you’re ready, then n8n pulls each row from your sheet and sends the person details to Airtop. Airtop performs an intelligent search (using Google search results under the hood), finds likely LinkedIn profile pages, and validates the best match against LinkedIn. After that, a small code step extracts the clean URL from the search output, and n8n writes it back to the same Google Sheet row so your list stays organized.
The workflow begins with a pull from Google Sheets, then Airtop handles discovery and validation. A parsing step cleans the output, and the sheet gets updated with a confirmed profile URL and status so you can filter and move on.
What You’re Building
| What Gets Automated | What You’ll Achieve |
|---|---|
|
|
Expected Results
Say you need verified LinkedIn URLs for 100 new leads this week. Manually, it’s usually about 5 minutes per lead once you include searching, clicking, double-checking, and pasting, which is roughly 8 hours of focused work. With this workflow, you can prep the sheet in about 10 minutes, run the enrichment, and spend maybe 30 minutes reviewing any edge cases. That’s most of a workday back, without lowering quality.
Before You Start
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets for storing your input rows and results.
- Airtop to discover and validate LinkedIn profile URLs.
- Airtop API key (get it from your Airtop dashboard).
Skill level: Beginner. You’ll connect accounts, map a few fields, and run a test on a small batch.
Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).
Step by Step
You launch the workflow manually. That’s deliberate. It lets you decide when to run enrichment (for example, after a list import or before an outreach push) instead of firing constantly in the background.
Google Sheets provides the people to enrich. n8n reads the rows you’ve prepared, typically with columns like full name, company, and optional fields such as domain or location. The cleaner your inputs, the less ambiguity the workflow has to fight later.
Airtop searches and validates the best LinkedIn match. The Airtop step uses the person details to form a query, finds candidate LinkedIn URLs, and then validates them directly against LinkedIn so you’re not just saving “a likely link.” If you choose to sign in to LinkedIn via an Airtop profile, validation can be even stronger because it’s checking the real page context.
The workflow extracts the URL and updates your sheet. A short code step parses Airtop’s output into a clean field, then n8n writes the result back to the right row in Google Sheets. You end with a filled LinkedIn URL column and a status you can filter on.
You can easily modify the input columns to match your sheet layout based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Manual Trigger
This workflow starts on demand and then pulls person data from Google Sheets.
- Add the Manual Launch Trigger node as the starting point of the workflow.
- Connect Manual Launch Trigger to Retrieve Person Details.
- (Optional) Keep Flowpast Branding as a sticky note for documentation and reference.
Step 2: Connect Google Sheets
Pull the person records that will be used for LinkedIn lookups, then later update the same sheet.
- Open Retrieve Person Details and select your Google Sheets file.
- Set Document to
[YOUR_ID]and Sheet toSheet1(gid0). - Credential Required: Connect your googleSheetsOAuth2Api credentials.
- Open Update Sheet Record and confirm Operation is
update. - Set Document to
[YOUR_ID]and Sheet toSheet1(gid0). - Credential Required: Connect your googleSheetsOAuth2Api credentials.
⚠️ Common Pitfall: If your sheet uses a different tab name or gid, update both Retrieve Person Details and Update Sheet Record to match.
Step 3: Set Up the Airtop Lookup
This node runs a Google search and extracts the LinkedIn profile URL for each person.
- Open Lookup LinkedIn Result.
- Set Resource to
extractionand Operation toquery. - Set Session Mode to
new. - Set URL to
=https://www.google.com/search?q={{ encodeURI($json['Person Info']) }}. - Set Prompt to
=This is Google Search results. the first results should be the Linkedin Page of {{ $json['Person Info'] }} Return the Linkedin URL and nothing else. If you cannot find the Linkedin URL, return an empty string. A valid Linkedin profile URL starts with "https://www.linkedin.com/in/". - Credential Required: Connect your airtopApi credentials.
$json['Person Info'].Step 4: Configure the Processing and Update Steps
The code node merges the LinkedIn URL into the original row data, then writes it back to the sheet.
- Open Extract Search Output and set Mode to
runOnceForEachItem. - Paste the JavaScript Code exactly as provided:
const linkedInProfile = $json.data.modelResponse const rowData = $('Retrieve Person Details').item.json return { json: { ...rowData, 'LinkedIn URL': linkedInProfile }}; - Connect Lookup LinkedIn Result to Extract Search Output, then connect Extract Search Output to Update Sheet Record.
- In Update Sheet Record, confirm Columns are mapped and Matching Columns includes
row_number.
Step 5: Test and Activate Your Workflow
Run a manual test to verify LinkedIn URLs are returned and written to the sheet.
- Click Execute Workflow on the Manual Launch Trigger node.
- Verify that Lookup LinkedIn Result returns a LinkedIn URL or an empty string in its output.
- Confirm that Update Sheet Record writes the LinkedIn URL back to the same row using
row_number. - When everything looks correct, toggle the workflow to Active for production use.
Troubleshooting Tips
- Google Sheets credentials can expire or need specific permissions. If things break, check n8n’s Credentials list and your Google account access first.
- If you’re processing in batches, timing can still bite you when Airtop is waiting on external pages. Reduce your batch size (Split in Batches) if downstream steps fail or return empty fields.
- Airtop results are only as good as the input. If your sheet has nicknames, missing company names, or inconsistent domains, improve those fields first or you’ll be reviewing “almost correct” matches all day.
Quick Answers
About 10 minutes if your accounts are ready.
No. The workflow includes a code step, but you can use it as-is without writing anything.
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, which depends 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 it’s common. You can swap the Google Sheets read/write steps for Airtable or Notion, and keep the Airtop discovery step intact. Many teams also add extra output columns like “confidence,” “notes,” or “source query” by editing the fields right before the “Update Sheet Record” step. If you want it to trigger from another tool, replace the manual trigger with a webhook and pass the same person fields in.
Usually it’s an invalid or expired Airtop API key. Regenerate the key in Airtop, update the credential in n8n, and rerun a single test row. If you’re using LinkedIn validation, a logged-out Airtop profile can also cause failures because the workflow can’t confirm the page content. Finally, if you push big batches, slow responses can look like failures; try smaller batches first.
It depends on your plan and how you batch runs. n8n Cloud has monthly execution limits per plan, while self-hosting has no execution cap (your server is the limit). In practice, most teams run this in chunks of a few hundred rows, review edge cases, then continue. If you want “thousands weekly,” build in batching and leave enough time for Airtop to complete validations.
Often, yes, because this type of enrichment benefits from flexible logic and custom parsing. n8n makes it easier to control batching, handle “if this, then that” branches, and keep everything in one workflow without paying extra for every path. Zapier and Make can still work if your process is simple and you only enrich a handful of rows. The moment you care about validation, cleanup, and scale, n8n is usually the calmer option. Talk to an automation expert if you want help deciding.
Clean LinkedIn URLs change everything downstream: outreach, recruiting, routing, reporting. Set this up once, then let your sheet stay trustworthy for the next campaign.
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.
