Connector

Send LinkedIn Ads data to Google Sheets

Load LinkedIn Ads into your data warehouse first, link it to web analytics and deals with SQL keys, then send the answers to Google Sheets on a schedule. The sheet stays tied to your source of truth, not to an API that can break.

LinkedIn AdsConnectedAd AccountsAd AnalyticsAd Analytics by…Ad Analytics by…
Data MartPublishedone definition
Google SheetsDateCostClicksDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get Started Free

Hand this to your AI

The LinkedIn Ads sheet counts leads from the ad account, and sales keeps asking which of them turned into deals.

Paste this into your AI assistant. It loads LinkedIn Ads into your data warehouse, links it to web analytics and deals in a Data Mart, and sends the answers to your sheet on a schedule.

The prompt

send a weekly Google Sheets report of LinkedIn Ads cost, clicks and one-click leads by campaign, with a column for how many of those leads became CRM deals

Endpoints

S00 · Why

Why LinkedIn Ads does not go straight to Google Sheets

A direct link gives you a copy of the ad account in a sheet. It does not show which ad led to a deal that closed months later, because spend, website touch points and CRM deals live in different systems. A sheet is not built to join them reliably, at scale or business-ready, so the join happens in a data warehouse first.

  • LinkedIn Ads reports what an ad cost, not what it was worth
  • The data analyst links ad spend, web analytics and CRM deals by SQL keys and controls the result
  • Stakeholders keep the sheet they like, now tied to your source of truth
LinkedIn AdsAd spend
Google Sheets
No link to deals
Data warehouseJoined by id
Web analyticsClicks, form fills
CRMDeals

S01 · Step 1

Step 1: Load LinkedIn Ads into your data warehouse first

Create a Data Mart with LinkedIn Ads as the data source and choose where the data lands. It works with any popular data warehouse.

  • Five endpoints and 175 fields to choose from, each endpoint in its own table
  • Open the LinkedIn Ads connector for your data warehouse below
LinkedIn AdsData Mart
Your data warehouseGoogle BigQueryAWS AthenaSnowflakeAWS RedshiftDatabricks
linkedin_ads.ad_analytics

S03 · Step 3

Step 3: Send LinkedIn Ads data to Google Sheets

Connect a Google Sheets report to the Data Mart. Aliases and field descriptions arrive as notes in the column headers, so everyone reads the same definitions.

  • The sheet reads your data warehouse, not the LinkedIn Ads API
  • Hover a header to see what the field means
Google SheetsNotes in headersdateRangeStartcostInUsdclicks
costInUsdCost in USD based on the pivotand timeGranularity. For…
clicksThe count of chargeable clicks.Despite not charging for…

S04 · Step 4

Step 4: Refresh your LinkedIn Ads sheet on a schedule

Set a scheduled refresh once. Daily is the usual choice and hourly is possible when you need it.

  • Every refresh is logged in Run History
  • Stakeholders open a sheet that is already up to date
ScheduleRefresh on a scheduleHourlyDailyDaily 09:00
Google SheetsUpdated
Run HistoryReport refreshedReport refreshedReport refreshed

S05 · Step 5

Step 5: Reuse LinkedIn Ads inside OWOX MCP

The same Data Mart works in OWOX MCP, your AI assistant for data. Request any report, chat with your data, then get the report in Google Sheets or Excel in one click.

  • Ask in plain words; the answer comes from your data warehouse
  • Define the numbers once and every report reads them
OWOX MCPShow platform_roas and platform_cpa by channelplatform_roas
Google SheetsOpen
ExcelOpen

Recent updates

Why OWOX

Why OWOX for LinkedIn Ads in Google Sheets

Hand-built API scripts and add-ons that pull straight from an ad account get numbers into a sheet. OWOX also keeps the data yours, linked and ready to model.

  • You own the data. It lands in your own data warehouse, in tables you control.
  • Answers about the whole business. Ads, web analytics, CRM, deals and calls are linked, not copied from an ad account.
  • Sheets stay in sync. Notes in the headers, a schedule you set once, no API token to fix in the sheet.
  • Maintained for you. No scripts to fix when LinkedIn changes its API.
  • Free to self-host. The open-source OWOX Data Marts runs in your own infrastructure.

Book a callGet Started Free

Trust

The Data Partner You Can Trust

users

166K Source: Internal OWOX data as of 2026-11-15

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers