LinkedIn to Google Sheets: how to get your leads in automatically
- Written by
- Jorrit van Ginkel, founder of Ziplined
- Published
- Last updated
On LinkedIn
In your Google Sheet
Leads who fitLinkedIn has no Google Sheets export, except a one-off file of your own connections. To get the people who engage with your team and your competitors into a sheet, you copy them by hand, or Ziplined adds each new one as a row.
Short answer: by hand, you copy people from LinkedIn into a sheet, or import LinkedIn's connections file once. Automatically, Ziplined adds a row to a Google Sheet for each new Lead (a person who fits your ideal client), on Team from $99 a month.
Can you export LinkedIn data to Google Sheets?
LinkedIn exports only your 1st-degree connections, as a file you import into Google Sheets yourself. LinkedIn has no export of the people who like or comment on posts, view your profile or follow you.
| What you want in the sheet | Export from LinkedIn |
|---|---|
| Your 1st-degree connections | Yes, a one-off file from "Get a copy of your data" |
| Likers and commenters of posts | None |
| Your profile viewers | None |
| Your new followers | None |
| A sheet that fills itself | None |
LinkedIn facts: LinkedIn Help on exporting connections and on downloading your data, checked 12 November 2026.
How to get LinkedIn leads into Google Sheets by hand
Without a tool, there are four ways to get LinkedIn leads into Google Sheets. Each one is a snapshot: the sheet is right on the day you made it.
1. Copy and paste LinkedIn leads into a sheet
Open the post, your Profile viewers or your followers.
For a post, click the reactions count and read the comments.
Open each person you want.
LinkedIn's lists show a name and a headline, not always the company.
Type them into your sheet.
Name, job title, company and what they did, one row at a time.
Do it again next week.
And for every rep and every competitor you follow.
Your sheet
Typed by hand. The gaps are what you had no time to look up.
Time: a few minutes per post, longer per rep. Limit: what you skip stays a gap in the sheet.
2. Screenshot LinkedIn and turn it into a table with AI
Screenshot each screen of names.
The reactions of a post, your Profile viewers or your followers.
Upload them to ChatGPT or Claude.
Add the prompt below.
Check every row.
Then paste the table into Google Sheets.
Turn these screenshots into a table with name, job title, company and what they did (liked, commented, viewed, followed). Leave out LinkedIn Member.Limit: only what was on your screen. An AI assistant can misread a name or a company, so check the table.
3. Import your LinkedIn connections export into Google Sheets
Ask LinkedIn for your connections.
Me, Settings & Privacy, Data privacy, Get a copy of your data. Pick Connections.
Download the file from the email.
The link works for 72 hours.
In Google Sheets, click File, then Import.
Upload the connections file.
Choose where it goes.
Insert new sheets for a fresh tab, or Append rows to current sheet.
Connections (CSV)
- Grace MensahNorthwind[email protected]
- Ruben SmitBrightwave StudioEmpty
- Lotte VermeerKestrel LabsEmpty
- Tom VerbeekEmpty
Also URL, position and connected on. Email only if they allow it.
Limit: only your 1st-degree connections, with an email only when they allow it. Nobody who liked, commented, viewed or followed is in it.
Google facts: Google Docs Editors Help on importing data into Sheets, checked 12 November 2026.
4. A one-off script in the browser
Open the list on LinkedIn.
Scroll until every person is loaded.
Run a small script in the browser console.
It reads the names on the page. No script is shared here.
Paste the output into Google Sheets.
Check it, as with the other ways.
Limit: the script breaks when LinkedIn changes the page. Tools that click, send or crawl inside your LinkedIn account can get it restricted, so it is not for every week.
Free or automatic: which way to get LinkedIn leads into Google Sheets fits you?
The free ways are copy and paste, screenshots with an AI assistant, and the connections file. They fit a one-off list, but a sheet your team works from every week costs time every time.
| Time each week | What lands | Fills itself | Risk | |
|---|---|---|---|---|
| Copy and paste | Minutes per post, per rep | What you typed | No | Gaps |
| Screenshots and AI | Minutes, plus checking | What was on screen | No | Misread names |
| Connections file | Minutes, once | Connections only | No | None |
| One-off script | Fixes when LinkedIn changes the page | What the page loaded | No | Your account restricted |
| Ziplined | None after setup | Each new Lead, 17 columns by default | Yes | Paid per item collected (posts, likes, comments), fit or not |
What is Ziplined and how does it send LinkedIn leads to Google Sheets automatically?
Ziplined is a LinkedIn Lead Radar. It finds people who engage with your team, your competitors and your market, keeps the ones who fit your ideal client, and sends them to your tools while you sleep.
Add your team's and your competitors' profiles as sources.
A source is a LinkedIn profile or company page you ask Ziplined to watch. Every night Ziplined collects their new posts and who liked and commented on them.
Optional: install the extension once in Chrome.
It is optional, and from then on it runs in the background. Up to twice a day it reads your profile viewers, new followers and new connections.
Send a saved list to a Google Sheet.
A saved list keeps your filters. Pick a spreadsheet, and Ziplined adds a tab named after the list, with a row for each new person who fits.
Google Sheets is on Team, from $99 a month with 10,000 credits. One credit is one thing Ziplined collects, such as a post or a like on it, including people who do not fit.
The extension is optional. Ziplined itself takes no action on LinkedIn, and the extension only reads your profile viewers, new followers and new connections; it never likes, comments, connects or sends.
One kind of lead? See how to export LinkedIn post engagers, your profile viewers, your new followers, your connections or the people who engage with competitors.
Which LinkedIn data lands in your Google Sheet?
Ziplined writes 17 columns to Google Sheets by default: who the person is, their company, and why they are in the sheet now. You pick the columns when you connect the sheet.
Leads who fitOne row per new person. Scroll the sheet for every column.
| Group | Default columns | You can add |
|---|---|---|
| Person | First name, Last name, Job title, Location, LinkedIn URL | Full name, Headline, Seniority, Country |
| Company | Company, Company website, Company size, Industry | |
| Why now | Signal, Comment or post text, Post text, Post topic, Post link, Signal date | |
| Ziplined | Added on, Open in Ziplined | View (the saved list's name), Warmth score, Lead, Ziplined ID |
The Signal column says what they did, such as "Visited Anna's profile" (Anna is a rep on your team) or "Commented on Acme's post about pricing". Signal date is when they did it on LinkedIn, Added on is when Ziplined found them; work email and phone are coming soon.
Comment or post text is what the person wrote. Post text is the post they liked or commented on.
Does Ziplined add new rows or update old ones in Google Sheets?
Ziplined adds new rows to Google Sheets: each person is added once per tab. Ziplined never changes or deletes a row already in your sheet.
You can sort the tab and add your own columns to the right of Ziplined's. If you rename or move Ziplined's columns, sending pauses until you put them back.
How often does Ziplined update the Google Sheet?
Ziplined adds a new person to your Google Sheet within about 10 minutes of finding them. New people come in every night from 02:05 UTC, and the optional extension adds profile viewers, new followers and new connections up to twice a day.
When you add a profile, Ziplined reads its last 7 days right away, so the first names are in Ziplined within minutes. When you connect the sheet, you can add everyone already in the saved list at once, up to 10,000; after that only new people are added.
Sending people to your sheet costs no credits.
How to send only the LinkedIn leads who fit your ideal client to Google Sheets
Ziplined sends only the people who fit your ideal client to Google Sheets: you write the ideal client as one sentence. Ziplined suggests the sentence from your website.
Students, recruiters and your own colleagues rarely get through; to be sure, exclude job titles such as recruiter.
A saved list narrows the Leads further: on job title, company, company size, country, industry, seniority or warmth. The sheet gets only what the list holds.
Can each rep get their own Google Sheet?
Yes: every saved list in Ziplined goes to its own Google Sheets tab. Make one list per rep, per competitor or per kind of signal.
Point each list at the same spreadsheet for one tab per rep, or at a different spreadsheet per rep. The same list can also alert Slack or email, or send to Clay or HeyReach, at the same time.
Can you download LinkedIn leads as a CSV for Google Sheets instead?
Yes: Ziplined downloads any list as a CSV on every plan, from Solo at $49 a month. Import the file in Google Sheets with File, then Import.
A CSV is a snapshot of the day you download it. On Team, Ziplined keeps the sheet filling by itself.
What to do with LinkedIn leads in Google Sheets
A sheet is where the team decides who to contact and who does it. Four plays to start with:
Review the new rows every week
Sort the tab on Added on and go through last week's rows in your sales meeting.
Give every rep their own tab
One saved list per rep, such as Anna and Ben, each in its own tab of the team's spreadsheet.
Start with the warmest Leads
Add the Warmth score column, how much someone engaged in the last 90 days, and sort on it.
Hand the sheet to an assistant or to Clay
Share the tab with an assistant, or send the same list to Clay, a tool that adds company and contact data.
The LinkedIn Lead Radar
- Watch your market for buying signals
- Analyze your own audience
- Takes no action on LinkedIn
- Claude
- ChatGPT
- Grok Bot
- Cursor
- Slack
- HeyReach
- Google Sheets
- Clay
FAQ
Can you export LinkedIn data to Google Sheets?
Only your 1st-degree connections, as a file from "Get a copy of your data" that you import with File, then Import. LinkedIn has no export of post likers, commenters, profile viewers or followers.
How do I get LinkedIn leads into Google Sheets automatically?
Connect a Google Sheet to a saved list in Ziplined. Ziplined adds a tab named after the list and a row for each new person who fits your ideal client. Google Sheets is on Team, from $99 a month.
Which columns does Ziplined write to Google Sheets?
Seventeen by default: First name, Last name, Job title, Location, LinkedIn URL, Company, Company website, Company size, Industry, Signal, Comment or post text, Post text, Post topic, Post link, Signal date, Added on and Open in Ziplined. You can add Full name, Headline, Seniority, Country, View (the saved list's name), Warmth score, Lead and Ziplined ID.
Is there a free way to get LinkedIn data into Google Sheets?
Yes, by hand: copy and paste, screenshots turned into a table by an AI assistant, or LinkedIn's connections file imported with File, then Import. Each one is a one-off snapshot. Ziplined fills the sheet by itself on Team, from $99 a month, with 7 days to try it.
Can a Chrome extension or Zapier send LinkedIn leads to Google Sheets?
Extensions that save LinkedIn profiles to a sheet add a Save button to a profile, and save only the profile you click. Zapier's LinkedIn app has no LinkedIn triggers, only actions that post to LinkedIn (Zapier, checked 13 November 2026). Neither finds the people who like, comment, view or follow.
Does Ziplined update rows in my sheet?
No. It adds new rows and never changes or deletes a row already there. Each person is added to a tab once.
How often does the Google Sheet update?
Ziplined adds a new person to the sheet within about 10 minutes of finding them. New people arrive after the nightly collection of posts, from 02:05 UTC, and from the optional extension, up to twice a day.
Can I add my own columns to the sheet?
Yes, to the right of Ziplined's columns, and you can sort the tab. If you rename or move Ziplined's columns, sending pauses until you put them back.
Is there a Google Sheets template for a LinkedIn engagement tracker?
You do not need one. When you connect a sheet, Ziplined makes the tab and its header row with the columns you picked. By hand, a tracker needs at least name, job title, company, what they did and the date.
Does Ziplined get access to all my Google Drive files?
No. It asks Google only for access to the spreadsheets you choose or that Ziplined makes, not your other files.
Can I export LinkedIn leads to Google Sheets on Solo?
As a CSV, yes: download any list and import it in Google Sheets, on every plan from $49 a month. The connection that fills the sheet by itself is on Team, from $99 a month.
Does sending people to Google Sheets cost credits?
No. One credit is one thing Ziplined collects: a post, a like or comment on it, a profile view or a new follower, also for people who do not fit. Solo has 3,000 credits a month, for example 30 posts with 99 reactions each, and Team from 10,000. Sending people to your sheet costs no credits.
Can I send LinkedIn leads to Google Sheets and HubSpot?
Yes. A saved list can go to a Google Sheet and, on Team, to a webhook for HubSpot through Zapier or Make at the same time. A native HubSpot connection is coming soon.
