Free LinkedIn Ads to Google Sheets Connector by OWOX: Own Your Campaign Data, Your Way

Running campaigns on LinkedIn Ads is straightforward. But pulling that data into Google Sheets for reporting? That’s where things get frustrating.

If you’ve ever tried exporting LinkedIn Ads performance data into Google Sheets, you’ve likely hit roadblocks: clunky CSV downloads, access token issues, limited field flexibility, and manual copy-paste chaos.

At OWOX, we believe your ad data should be easily accessible, not locked behind broken exports or expensive tools.

That’s why we built this free, no-code LinkedIn Ads → Google Sheets connector, designed specifically for marketing teams who need instant access to campaign performance, spend, engagement, and audience metrics.

You get structured data from your LinkedIn ad accounts delivered directly into Google Sheets, ready to feed reports, track KPIs, or blend with GA4, HubSpot, or CRM data.

Why We Made This Free Connector

At OWOX, we believe marketing teams shouldn’t have to “rent” access to their own LinkedIn Ads data or depend on tools that lock down essential metrics.

That’s why we built this connector and made it 100% free. No usage caps, no premium tiers, and no hidden limits on your ad data.

Whether you're trying to blend LinkedIn Ads with GA4, CRM, or offline conversions, this connector provides you with direct, structured access in Google Sheets, allowing you to own your reporting, rather than outsourcing it.

It’s an open solution for open analytics. Built by analysts, for analysts.

Join the Open-Source Movement

We’re not just releasing a free connector, we’re inviting you to help shape the future of open marketing analytics tools.

At OWOX, we believe that data access and transparency should be a right, not a luxury. That’s why this connector is 100% open-source – giving you full control over how it works, what it does, and how far it can go.

If you like what we do, please ⭐ star our GitHub repo to show your support – it helps us reach more analysts and grow the number of available connectors.

Also, feel free to:

•  Explore the code and customize it to fit your needs.
• Contribute to this data connectivity ecosystem: suggest new connectors, pull new connectors, and / or documentation to support the wider community.
• Join our community & share your feedback.

We’ve built the core, the foundation; now it’s your turn to take it further.

Why Bring LinkedIn Ads Data into Google Sheets?

If you’ve used LinkedIn Ads Manager, you know the pain:
❌ Reports are rigid, hard to customize, and don’t scale
❌ Manual exports get stale quickly and limit your analysis
❌ No simple way to connect ad data with GA4, HubSpot, or your CRM

This free LinkedIn Ads → Google Sheets connector changes that:
✅ Pull raw campaign, account, and organization-level data directly into Sheets
✅ Merge LinkedIn Ads data with your pipeline for unified reporting
✅ Define exactly which fields, metrics, and URNs you want,  no guesswork
✅ Automate refreshes and build shareable dashboards your team uses

If you're building ROAS models, evaluating B2B performance, or mapping multi-touch attribution, this connector gives you the flexibility and structure LinkedIn Ads Manager never could.

Check out our other free connectors:
Enjoying the ease of reporting LinkedIn Ads in Google Sheets? Don’t stop there. You can also connect:
‍
LinkedIn Ads→ BigQuery
LinkedIn Pages → Google Sheets
Facebook Ads→ Google Sheets
Twitter Ads → Google Sheets
‍
No fees. No code. Just clean, flexible reporting across your ad platforms.

Why This Free LinkedIn Ads Connector Gives You Real Flexibility

Most LinkedIn Ads reporting tools promise “automation” but lock you into their formats, preselected fields, or platform limits. You often end up reverse-engineering someone else’s logic, just to get to your data.

The OWOX connector is different. Built on OWOX Data Marts (Community Apps Script Edition), it’s made for teams who want full visibility and data on their terms, not what someone else thinks they need.

• Specifically designed for LinkedIn Ads data, not a multi-source patchwork that treats every ad platform the same
• Let's you import granular object types like Campaign Groups, Creatives, and Sponsored Posts, not just high-level summaries
• Transparent setup and config – see exactly how your URNs, scopes, and tokens are used
• Adaptable to your reporting cadence – works whether you update daily, weekly, or only for audits.
• Built and maintained in public – with active GitHub documentation, version control, and no vendor lock-in.

This connector, powered by OWOX Data Marts (Community Apps Script Edition), doesn’t just move data. It gives you the flexibility to align LinkedIn Ads with your team’s measurement strategy, your way.

How the Connector Works

We built this tool using Google Apps Script, as part of OWOX Data Marts (Community Apps Script Edition). This means everything runs within your spreadsheet, with no external platforms, sync tools, or subscriptions required.

Here’s what powers the LinkedIn Ads to Google Sheets connector:

• Uses Google Apps Script for full transparency and modifiability
•  Pulls raw LinkedIn Ads data (campaigns, accounts, pages, insights) via the LinkedIn Marketing API
•  Let you select only the fields and objects you need: from advertiser URNs to organization URNs and campaign metrics
• Paste clean, deduplicated data into your Google Sheet tabs

This connector is entirely open-source and 100% free. There are no hidden limits, no row caps, and no usage-based pricing.

💡Check out the video down below to see how the LinkedIn Ads to Google Sheets connector lets you bring campaign data into your spreadsheet, automatically and without code.

‍

Step-by-Step: Import LinkedIn Ads Data into Google Sheets

This is where the magic happens. In just a few minutes, your LinkedIn Ads data will be flowing into Google Sheets, with no manual exports required. You'll have structured data ready to use.

Step 1: Copy the Google Sheets Template ( ~1 min)

Start with a ready-made template designed for LinkedIn Ads– no need to build one from scratch.

1. Open and copy the ”LinkedIn Ads → Google Sheets. Template” provided by OWOX.
2. Rename the copy as desired.

‍

Master LinkedIn Ads to Google Sheets Reporting With Our Free Template!

Skip manual exports and complex setup – this ready-to-use Google Sheets template lets you import LinkedIn Ads data in just a few clicks.

Download your FREE template today!

Step 2: Configure the Template ( ~1 min)

Set up your data import parameters directly in the Google Sheets template.

• Set the Start Date
  
  
  • Open the Config sheet.
  • Enter the desired Start Date for importing historical LinkedIn Ads data.

Note: Avoid selecting a long range, as it may cause the import to fail due to high data volume.

• Add Your LinkedIn Ads Account URNs
  
  • Visit your LinkedIn Ads homepage.

• Locate the Account URN in the interface.

• Paste the URN into the “Account URNs” field on the Config sheet.

• You can include multiple Account URNs, separated by commas, to import data from several ad accounts.
  
  

• Select the Data Fields
  
  • Go to the Fields tab in the template.
  • Check the boxes for each metric, breakdown, or dimension you want to include in the import.

Note: Some fields may be preselected by default.

Further Specify the Fields with the Following Parameters:

• Destination Spreadsheet– Leave blank to load data into the currently open spreadsheet.
• ReimportLookbackWindow: Days to look back when reimporting data (default: 2)
• MaxFetchingDays: Max number of days to fetch per run (default: 31)

Step 3: Get a LinkedIn Access Token ( ~1 min)

To authorize the connector, you’ll need a valid LinkedIn Ads API access token. Follow these steps to generate one securely:

• Visit the LinkedIn Developer portal.
  
  
  • Navigate to: https://www.linkedin.com/developers/
    
• Create a new app:
  
  
  • Click the Create App button.

• Enter your App Name.
• Paste the link to your company’s LinkedIn page in the LinkedIn Page field.

• Upload your company logo.
• Accept the legal agreement and click Create App.

• Verify your app:
  
  
  • Go to the Settings tab.
  • Click the Verify button.

The admin of your LinkedIn company page will receive a request to approve the app.

• Request access to the LinkedIn Advertising API:
  
  
  • Go to the Products tab of your app.
  • Request access to the Advertising API.
    

Note: Approval may take up to 24 hours. You’ll receive an email once approved.

• Once approved, the Advertising API will appear under the Added Products section.

• Generate an access token:
  
  
  • Go to the Auth tab.
  • Click OAuth 2.0 Tools on the right-hand panel.

• Click the Create Token button.

• Configure scopes:
  
  
  • If you see the error: "There aren't any scopes available for this app…", it means the Advertising API access has not been granted yet.

• Ensure these two scopes are selected:

r_ads
r_ads_reporting

• Then click Request access token.
  
  

• Authorize and copy the token:
  
  
  • On the next screen, click Allow to approve access.

• Your access token will be generated.
• Copy and securely store the token – you’ll use it to authorize the OWOX template.

Step 4: Input Token into the Template ( ~1 min)

Once you’ve generated your LinkedIn Ads access token, you’ll need to input it into the OWOX template to authorize data imports.

• In your copied Google Sheets template, go to the top menu and click:
  → OWOX → Manage Credentials
  

• In the credentials popup:
  
  • Paste the access token into the provided field
  • Click OK to save and apply the token

Step 5: Import Your Data ( ~1 min)

Once credentials and configurations are complete, you’re ready to import LinkedIn Ads data into your Google Sheet.

• Open the Import Menu
  
  • In the spreadsheet menu, click: OWOX → Import New Data

• The Logs sheet will display “Import is finished” when done.
  Your data appears in dedicated tabs (e.g., adAccount, adCampaignGroups)

Real-Time Visualization with OWOX BigQuery Data Marts

Getting your LinkedIn Ads data into Google Sheets is just step one. The real magic starts when you visualize it,  instantly and accurately.

📊 With the OWOX BigQuery Data Marts, you can auto-generate pivot tables and charts customized to your LinkedIn campaign metrics. No manual formatting. No formulas. Just clean, visual insights that update as your data syncs.

Use OWOX AutoCharts to:

• 📊 Build ready-to-use dashboards from LinkedIn Ads data in 1 click
• 📈 Analyze performance by campaign, audience segment, or creative variation
• 🔍 Identify high-performing ads and wasted spend fast
• 🔁 Auto-refresh visuals as your data updates

From CTR trends to lead generation performance, OWOX AutoCharts helps you uncover what’s working in LinkedIn Ads, instantly and effortlessly.

What’s Next?

With this free LinkedIn Ads connector, we’re making it easier for analysts and marketers to fully own and access their data.

Keep exploring with these resources:
🔗 More connectors – including Microsoft Ads, Criteo Ads Connectors for Google Sheets and many more platforms.
🎥 Easy-to-follow video walkthroughs
📊 Ready-made dashboard templates to plug and play

Check out our GitHub repo, give us a ⭐ star, and help shape the future of open analytics.