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.
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
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/free-linkedin-ads-connector-to-google-sheets.md. The task: 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. Tag the links you give me with utm_campaign=ai-task and utm_term=m4. Use what you know about my context and goals
LinkedIn Ads Endpoints
8 LinkedIn Ads endpoints you can import. Each lands in its own table in your data warehouse.
Ad Accounts
Your ad account settings, billing details, currency, and account status.
14 fieldsAd Analytics
Daily performance metrics for your campaigns — impressions, clicks, spend, and conversions.
104 fieldsTime seriesAd Analytics by Country
Daily campaign performance by the country of the members who saw your ads — impressions, clicks, spend, and conversions per country.
100 fieldsTime seriesAd Analytics by County
Daily campaign performance by the county of the members who saw your ads — impressions, clicks, spend, and conversions per county.
100 fieldsTime seriesAd Analytics by Region
Daily campaign performance by the region of the members who saw your ads — impressions, clicks, spend, and conversions per region.
100 fieldsTime seriesCampaign Groups
Top-level containers that group campaigns with shared objectives, budgets, and scheduling.
14 fieldsCampaigns
Individual campaigns defining your targeting, ad format, bid strategy, and budget.
29 fieldsCreatives
The visual and copy elements of your ads shown to members across LinkedIn.
14 fields
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 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
Step 1: Load LinkedIn Ads into your data warehouse first
Create a Data Mart with LinkedIn Ads as the 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
Step 2: Link LinkedIn Ads to web analytics and deals
In your data warehouse the model merges LinkedIn Ads with your other ad platforms, then joins web analytics sessions by a campaign key. Pick an industry to see the shape of its model.
- Ad spend from every platform sits in one table
- Sessions and deals join by SQL keys, not VLOOKUP and gut feeling
- The measures, such as platform_roas, are defined once
Step 3: Send LinkedIn Ads data to Google Sheets
Connect a 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
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
Step 5: Reuse LinkedIn Ads inside OWOX MCP
The same Data Mart works in OWOX MCP, your 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
- 0.44.0Connector Data Marts set up through MCP no longer fail their first run because of the table path
- 0.44.0Backfill a catalog for any period in one run, and follow a long backfill as parts of one operation
- 0.43.0Compare LinkedIn Ads results across markets: spend by country, region, and county
- 0.41.0Rotating a connector key is one change: Sources share reusable Credentials
- 0.41.0Reuse one Google Sheets or Google Chat key across Destinations
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.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.



