What Google Sheets is
Google Sheets is where a surprising amount of commerce reporting actually lives, whatever the data stack diagram says.
A spreadsheet assembled by hand from four dashboards is stale the moment it is finished.
- Home
- Integrations
- Google Sheets
Google Sheets integration: a resolved event stream you can query yourself
Push resolved orders and events into Google Sheets for the reporting that lives in a spreadsheet rather than in a warehouse.
- Role
- Destination
- Category
- Data warehouse
- Plans
- All plans
About Google Sheets
Upstack pushes resolved orders and events directly into a sheet, so the numbers have a known source and a known freshness.
The reporting that was going to happen in a spreadsheet anyway happens against the same resolved data as everything else.
How Google Sheets works
Sheets holds whatever is pasted or pushed into it and recalculates on change. The problem it creates is not capability but provenance: nobody can say which dashboard a given column came from, or when.
What you can do with it
Three jobs this connector does inside Google Sheets.
01
Send complete conversions
Conversions reach Google Sheets through its server-side API with restored click IDs and hashed identifiers attached, so more of what you send is matched on arrival, and the conversions you never saw stop being invisible.
02
Optimize on the customer you want
Map any order attribute to the conversion Google Sheets receives (profit rather than revenue, new customers rather than repeat buyers, high-value orders rather than every checkout), so the platform learns from the buyers worth acquiring.
03
Reporting with a known source
Rows are pushed from the same resolved dataset the platforms receive, so a spreadsheet stops being a hand-assembled copy of four dashboards.
Documentation
Set-up reference.
Set-up, event schema and field mapping for Google Sheets as a destination.
FAQ
Google Sheets integration questions.
What does Upstack send to Google Sheets?
Push resolved orders and events into Google Sheets for the reporting that lives in a spreadsheet rather than in a warehouse.
Which plans include the Google Sheets integration?
All plans. Upstack has three plans that scale with your order volume, and the same integrations are on every plan.
Will Upstack slow down my store?
Upstack’s own pixel loads asynchronously and fails silently, so it doesn’t hold up your pages. What each destination adds depends on its Tracking Method. The default, Browser + Server, loads that platform’s own tag on your store, in place of the copy you would otherwise install yourself, and also sends the same events from Upstack’s servers. Choose Server for any destination that offers it and its tag never loads, while its events still arrive from Upstack’s servers.
Similar integrations
Other destinations to send to.
- Your warehouse BigQuery, Snowflake or Redshift.
-
BigQuery Resolved events in your own warehouse. -
Meta Conversions API Conversions API with higher Event Match Quality. -
Google Ads Conversions Enhanced Conversions that actually match. -
TikTok Events API Events API with a resolved customer attached. -
Pinterest Conversions API, deduplicated server-side. -
Snapchat Conversions API with restored identifiers. -
Reddit Conversions API for a community-led audience. -
Microsoft Ads UET conversions with restored identifiers. -
X Conversions API, deduplicated server-side. -
AppLovin Browser delivery through the Axon Pixel. -
Outbrain Native conversions with the click restored.
Get Google Sheets tracking right.
A 15-minute walkthrough tailored to your stack and channels.