Connectors / Shopify / Google Sheets
Shopify → Google Sheets
Orders, sales, discounts and returns — revenue truth next to ad spend for real ROAS. Managed tabs, append or replace modes, and cell-limit guardrails with clear errors — not silent truncation.
How the sync works
- Connect your Google account and pick (or create) a spreadsheet.
- Choose fields and breakdowns from the connector's catalog.
- Pick a schedule — hourly on every paid plan — and Yoker manages the tab from there.
What lands in Sheets
1 dimensions: date
7 metrics: orders, gross_sales, discounts, returns, net_sales, average_order_value, new_customers
Restatement-aware: every sync re-pulls the trailing 7 days, so revised conversions overwrite cleanly in Sheets — no duplicate rows, no stale numbers.
Why teams pick Yoker for this
- Hourly on every paid plan — most tools gate hourly refresh behind $99–199/mo tiers; here it starts at $29.
- Backfills are free and unlimited — pull years of Shopify history without it counting against anything.
- The guarantees: price-lock, one-click cancel, 30-day refunds, and a 99% sync SLA with automatic credit.
- Unified schema: blend Shopify with every other platform without renaming columns by hand.