How to Send LinkedIn Lead Gen Forms to Google Sheets (Step-by-Step)
Send LinkedIn leads to Google Sheets automatically. Connect your Page, connect your sheet, map fields and test it with LeadsNotify in about 5 minutes.
By Akash Mehra
6 min read
Table of contents
Google Sheets is the spreadsheet most teams already share. It is a simple place to keep every lead, sort them, add notes and share them with colleagues or clients. If you run LinkedIn Lead Gen Forms, sending every new lead to Google Sheets automatically saves you downloading files from Campaign Manager and importing them by hand.
This guide shows you how to send LinkedIn Lead Gen Forms to Google Sheets with LeadsNotify: connect your LinkedIn Page, connect Google Sheets, choose where leads go, and test it. It takes about five minutes.
Why Send LinkedIn Leads to Google Sheets?
A shared sheet that fills itself means nobody downloads CSV files from the ad platform again, and everyone looks at the same list.
LinkedIn leads are often your most valuable leads: decision makers, with company and job title already filled in from their profile. They are also the easiest to lose, because they wait in Campaign Manager until someone remembers to download them.
How to Send LinkedIn Lead Gen Forms to Google Sheets (About 5 Minutes)
Before you start, you need: a LeadsNotify account on any plan, free included, admin access to the LinkedIn Page that runs your lead gen forms, and your Google Sheets login.
Step 1: Connect Your LinkedIn Page
Log in to LeadsNotify. Open Connectors in the top menu and choose Linkedin. Click Connect To Linkedin, sign in, tick the Pages you run lead gen form campaigns from, and approve the permissions LinkedIn asks for.
Every Page you ticked shows as CONNECTED. Adding another Page later? Click Connect To Linkedin again and tick the new Page, leaving the connected Pages ticked. Already connected? Skip to step 2.
Step 2: Create a Google Sheets Notifier
Go back to the dashboard. Under Create a new notifier, make sure the LinkedIn tab is selected, type “google” in the search box, find Send leads to Google Sheets and click Create notifier.
Step 3: Pick Your Page and Lead Gen Forms
The Create Notifier screen has two sides. The Trigger on the left is where leads come from. The Action on the right is where they go.
In the Trigger panel, choose your LinkedIn Page under Select Page, then pick one or more lead gen forms under Select Form. LeadsNotify then lists the fields on those forms, such as first name, last name, email, company name and job title.
Only active forms are shown. If a form is missing, check that the form and its campaign are active in Campaign Manager.
Step 4: Connect Google Sheets
In the Action panel, connect your Google Sheets account. There is no key to copy: you sign in to Google Sheets and allow access.
- In the Action panel, click Connect Google Drive.
- Google asks you to choose an account and allow access. Pick the Google account that owns the spreadsheet.
- You return to LeadsNotify, where you choose the spreadsheet and sheet that should receive the leads.
Step 5: Choose Where Leads Go, Then Submit
Match each lead form field to a column in the sheet, for example First Name, Last Name, Email, Phone and Company. Add a header row to the sheet first so the columns are easy to match.
Tick Email me when a lead fails so you hear about it if a lead can’t be delivered, then click Submit. Your notifier appears under My Notifier, and the green switch means it’s live.
Step 6: Send a Test Lead and Check Lead Delivery
After you submit the notifier, LeadsNotify offers to send a test lead through it. You can also do this later: open My Notifier, click Edit on the notifier, then click TEST NOTIFIER.
Open the spreadsheet and look for a new row with the test lead. If the test lead is there with the right details, the notifier is working.
Want to test with a submission from LinkedIn itself? In Campaign Manager, open your ad account, go to Content & Assets > Lead generation forms, click More next to the form and choose Send Test Lead. Use a real email address you own.
Then open Lead Delivery in LeadsNotify. Every attempt is listed with the Page, the form, the destination and a status of Delivered or Failed, and the Response column shows the exact reply from Google Sheets. Our guide to the lead delivery status dashboard walks through every column.
Tips for Getting More From LinkedIn Leads in Google Sheets
- Keep a header row in row 1 and do not insert columns in the middle later; add new columns at the end.
- Use one tab per form or campaign if you run several.
- Share the sheet view-only with clients so they can see their leads live.
Troubleshooting the LinkedIn Lead Gen Forms to Google Sheets Integration
Start with the Response column in Lead Delivery. It shows the exact reason Google Sheets gave for a failed lead.
| What you see | Likely cause | Fix |
|---|---|---|
| No leads arriving at all | The LinkedIn Page shows DISCONNECTED, often after an admin role changes | Connectors > Linkedin > Connect To Linkedin, and tick the Page again |
| Your form isn’t in Select Form | Only active forms are shown | Check the form and campaign status in Campaign Manager, then reopen the notifier |
| Leads stopped after you edited the campaign | The campaign now uses a different lead gen form | Edit the notifier and select the new form |
| Rows stop appearing | The spreadsheet was moved, deleted or its sharing changed | Edit the notifier and pick the spreadsheet again |
| A delivery shows Failed | Google Sheets refused the lead | Open Lead Delivery and read the Response column for the reason |
Frequently Asked Questions
How do I connect LinkedIn Lead Gen Forms to Google Sheets?
Use LeadsNotify. Connect your LinkedIn Page, create a Google Sheets notifier, pick your lead gen forms, connect Google Drive and pick a spreadsheet, then submit and send a test lead.
Can LinkedIn leads go to Google Sheets automatically?
Yes. Once the notifier is switched on, every new lead from the forms you picked is sent to Google Sheets within seconds, with no CSV downloads.
Do I need to write any code?
No. Everything is set up in the LeadsNotify screens. You only need access to your LinkedIn Page and to your Google Sheets account.
Can I send the same lead to Google Sheets and another tool?
Yes. Create a second notifier on the same form, for example email alerts or Slack. See every LinkedIn Lead Gen Forms to Google Sheets option on our integrations page.
What happens if a lead can’t be delivered?
Tick Email me when a lead fails on the notifier and LeadsNotify emails you when Google Sheets refuses a lead. The Response column in Lead Delivery shows the reason. Here’s more on lead failure email alerts.
Which LeadsNotify plans include it?
Every plan, the free plan included. The free plan covers 150 leads a month and 2 notifiers. Compare the plans.
Start Sending LinkedIn Leads to Google Sheets
Connect your LinkedIn Page, connect Google Sheets, pick your forms and click Submit. Your next lead lands in Google Sheets seconds after the form is sent, instead of waiting for a download. Create your free LeadsNotify account and set up your Google Sheets notifier today.
Running Facebook lead ads too? Here’s how to send Facebook leads to Google Sheets.
Last Updated on September 25, 2026 by Akash Mehra
Set up a free notification in a few minutes.