How to export Pinterest Ads data to Google Sheets (and a simpler way)

Admaxxer is a marketing analytics and attribution platform for DTC brands and SaaS companies. This guide answers a common request from ecommerce teams running Pinterest Ads: how do I export my Pinterest Ads data into Google Sheets? Usually the real goal is a shared, always-current spreadsheet the whole team can read — spend, conversions, and ideally the orders and revenue those ads actually drove.

We'll walk through every legitimate route honestly — the native export, Pinterest's reporting API, and generic third-party connectors — citing Pinterest's and Google's official documentation. Then we'll show you the path most teams really want: skip the spreadsheet plumbing and get attribution plus live dashboards, with no export to refresh.

This is an ECOM/DTC guide (orders, AOV, ROAS, Shopify). If you run a SaaS product, the same export steps apply — you'll join Pinterest spend against subscriptions, MRR, and trial-to-paid rather than orders. SaaS deltas are flagged inline.

The three honest routes to Pinterest data in a spreadsheet

A spreadsheet of Pinterest Ads data can be filled three ways: export it by hand, pull it through Pinterest's reporting API and write it into Sheets, or pay a third-party connector to keep a sheet refreshed for you. There's no official one-click "Pinterest → Google Sheets" button maintained by Pinterest, so it's always one of these.

Route 1: Native export from Pinterest Ads Manager (CSV)

In Pinterest Ads Manager, the reporting view lets you choose columns (spend, impressions, saves, outbound clicks, conversions, conversion value) and a breakdown (campaign, ad group, ad, date), then export the table. You download a CSV and import it into Google Sheets with File → Import.

When this is the right call: a one-off pull, a monthly snapshot, or a quick check. No code, no setup.

The catch: it's manual and static. Every refresh is another hand export-and-import, and the moment you've imported it the numbers are already aging. For a living team dashboard this falls apart fast.

Route 2: Pinterest's reporting API + your own automation

For an automatically refreshing sheet, Pinterest exposes ad performance through its API. Pinterest documents several reporting methods and is explicit that you should pick the one that fits your use-case — see the Pinterest Ads reporting overview. The synchronous ad account analytics endpoint returns metrics directly, while the async report endpoint is built for larger pulls (you request a report, then fetch it when it's ready).

The work looks like this:

1. Create a Pinterest developer app and complete the authorization flow to get an access token for the ad account, per the Pinterest developer documentation.
2. Call the analytics endpoint (sync for small pulls, async for large ones) for your metrics and date range.
3. Write the rows into Google Sheets — for example with Apps Script on a time-based trigger, or a small script using the Sheets API.
4. Handle tokens, pagination, and rate limits so the refresh keeps running unattended.
5. Monitor it — when a token expires or Pinterest changes a field, something has to alert you before the sheet silently goes stale.

When this is the right call: you have someone comfortable with scripting, you want a self-refreshing sheet, and you're happy owning the small pipeline that keeps it current.

The catch: it's a mini data pipeline. Apps Script has runtime and quota limits, tokens expire, and an unattended script that fails quietly leaves you trusting a stale sheet.

SaaS note: the API calls are the same; you simply join the resulting spend to subscriptions and MRR downstream instead of orders.

Route 3: A generic third-party connector

Several spreadsheet connector add-ons (described generically — evaluate each on its current features and pricing) will pull Pinterest Ads metrics on a schedule straight into Google Sheets, so you skip the scripting. Some also load into a warehouse.

When this is the right call: you want a refreshing sheet without writing Apps Script and you're fine adding a paid add-on.

The catch: a connector drops raw Pinterest metrics into cells. It doesn't join them to your orders, deduplicate conversions, or tell you the true revenue Pinterest drove. You — or whoever owns the sheet — still has to build the formulas, the attribution logic, and the cross-channel comparison by hand, and spreadsheet attribution gets fragile fast.

What a spreadsheet of Pinterest data does — and doesn't — give you

It's worth being precise about what you end up with after any of the three routes above, because it explains why so many teams export the data, look at it, and feel like they still can't answer their real question.

A sheet of Pinterest Ads metrics gives you the platform's view of itself: how much you spent, how many impressions and saves and outbound clicks you got, and how many conversions Pinterest believes it drove using its own attribution window and its own click-and-view rules. That's genuinely useful for pacing spend and spotting which campaigns are scaling.

What it does not give you, on its own, is three things you almost always need next:

1. Reconciliation to your real orders. Pinterest's conversion count and your store's order count are measured differently and will not agree. Without joining the two, you don't know which number to trust.
2. A blended, cross-channel picture. A Pinterest-only sheet can't tell you whether a dollar is better spent on Pinterest or on Meta, because the other channels aren't in it on the same basis. Stitching multiple single-source sheets together by hand is exactly where spreadsheet reporting breaks down.
3. A view that's current without effort. The instant you export, the numbers start aging. Keeping a sheet live means keeping a refresh job alive — and someone noticing when it dies.

If your goal genuinely is raw rows for an analyst to model, a sheet is fine. If your goal is a decision — should I spend more on Pinterest this week? — a raw sheet is the start of the work, not the end of it.

Or skip the spreadsheet entirely

Be honest about the actual goal. The spreadsheet was never the point — the point was to see what Pinterest spend returned in real orders and revenue, keep it current, and compare it fairly against your other channels. A sheet is just one (brittle) way to get there.

Admaxxer gets you there with no spreadsheet to maintain. Connect Pinterest once on the Pinterest Ads integration page and your store on the Shopify integration page, and Pinterest spend lines up against your real orders and revenue automatically.

What you get instead of cells to maintain:

• Attribution, not raw metrics. Pinterest spend joined to real orders, so you see ROAS and blended MER directly — no formulas to wire.
• A live dashboard that refreshes itself, instead of a sheet someone has to re-import.
• Fair cross-channel comparison — Pinterest beside Meta, Google, TikTok, and Amazon on one screen, which a single-source export can't give you.
• Honest reconciliation. Pinterest skews toward consideration and view-through purchases, so its in-platform conversions and your true order count diverge by design — Admaxxer reconciles the two so you trust the number. (See why platform-reported numbers differ from your orders.)

If raw Pinterest rows in a sheet genuinely serve a separate need, keep one of the routes above for it — but to measure and steer spend, connecting once beats maintaining a spreadsheet. See pricing for what's included, or browse the documentation. If you're comparing analytics tools, our Triple Whale alternative page lays out where Admaxxer fits.

Choosing your route

• Need a quick one-off? Native CSV export → File → Import (Route 1).
• Want a self-refreshing raw sheet and don't mind owning it? Pinterest's reporting API via Apps Script (Route 2) or a connector add-on (Route 3).
• Want to actually see what Pinterest returned in revenue, live, without maintaining anything? Connect it to Admaxxer and skip the spreadsheet.

Pick the route that matches the goal you actually have. For most DTC teams, that goal is revenue truth — and revenue truth doesn't live in a spreadsheet you have to keep alive by hand.

FAQs