Setup Guide
Connect a sheet, the easy way.
A Polar account with Shopify connected, a Google account with access to the sheet, and a sheet with a date column. That is all you need.
01 · What you need
A Polar account with Shopify
A Polar account with Shopify connected. Google Sheets plugs in right next to your stack.
Connect your data →A Google account with access
A Google account with access to the sheet you want to connect. One sign-in, no setup.
Open Google Sheets →A sheet with a date column
The single most important thing in the sheet. A date column is what lets Polar line your data up with everything else.
02 · Connect a sheet, the easy way
1
Pick a template ~2 min
Preformatted with the columns Polar expects.
Choose one of the prebuilt templates, Marketing Spend, Expenses, Cost of Goods, Exchange Rates, Targets and Budget, each preformatted with the columns Polar expects. Or start a custom report with your own columns.
Faster later: keep the named range stable and give it a clear name. Every future edit and re-map is quicker.
Connect your data in Polar 2
Connect and map from Ask Polar ~2-3 min
Tell the agent, it walks you through it.
1
In any Ask Polar chat, just say what you want:
connect a google sheet
set up my Google Sheet
map my spend sheet to Polar
set up my Google Sheet
map my spend sheet to Polar
2
The agent walks you through preview → mapping → confirm → sync. A new connection hands you a Google sign-in link.
3
For a custom report, tag each column as a
metric, a dimension, or a date, and the agent validates it before writing anything.3
See it in your reports the payoff
It behaves like any other source.
Once the sync runs, typically 10 minutes to a couple of hours on first load depending on volume, the data behaves like any other source and flows into your P&L, contribution margin, CAC, and any custom metric or target.
The Gap
The connector is only half of it.
Data doesn't just flow into Polar through Google Sheets, it flows back out. Once your sources are clean and attributed inside Polar, you can write those numbers straight into a sheet: the finance model, the board tab, the agency's client tracker. Connect once, move data in both directions.
Your spreadsheets
spend, COGS, targets
clean, attributed metrics