Shopify → Google Sheets · Live

Sync Shopify to Google Sheets
— in plain English.

Push Shopify orders, products, customers, and more into Google Sheets on any schedule. Full backfill on the first run, incremental after. No Zapier task quotas, no Apps Script, no per-row fees.

TL;DR

rsync.ai connects to Shopify's Admin GraphQL API, extracts 6 resources (orders, products, customers, collections, inventory items, shop), and appends them into Google Sheets on the cadence you set — every minute, every hour, or daily. Customer email, phone, and addresses are omitted from default queries. Per-pipeline namespace isolation means multiple Shopify stores land on separate tabs without collision.

Live connector — full backfill on first run, cursor-resumed incremental after
Scheduled batch sync — every minute, hour, or day (describe it in plain English)
Customer PII excluded from default GraphQL queries by design
Source-available under Elastic License 2.0 — self-hosted, no per-task fees

See other destinations

How it works

How to sync Shopify to Google Sheets — 5 steps

From chat prompt to a populated Shopify sheet — a few minutes for a small store.

1
Connect Shopify
Provide your Shopify store subdomain and an Admin API access token. Token is sent as `X-Shopify-Access-Token` — never stored outside your self-hosted control plane.
shop + access_token
2
Connect Google Sheets
Authorize Google Sheets via OAuth. rsync.ai requests scoped access to the sheets you choose, not your full Drive.
Scoped OAuth · No Drive-wide access
3
Describe the sync in plain English
Type: 'Sync Shopify orders and products into Google Sheets every 30 minutes.' rsync.ai discovers Shopify's 6 resources and proposes one tab per resource.
Per-resource tabs by default
4
Pick the tabs and approve
rsync.ai shows the discovered Shopify resources. Tick which ones to sync. Tab headers come from the GraphQL schema; you can rename before going live.
5
Run on a schedule
Every scheduled run pulls new/changed Shopify rows (cursor-resumed) and upserts into the sheet. Live row counts and run history in the rsync.ai UI. No Zapier task quota, no per-row fee.
Sheets cap: 10M cells per spreadsheet

Shopify → Google Sheets layout

Each Shopify resource maps to its own sheet/tab by default. Rename, merge, or split via plain English.

Shopify resource	Sheet / tab	Notes
Order	Orders tab	Embedded line items (first 10) — customer/email/address fields excluded by default
Product	Products tab	Embedded variants (first 5)
Customer	Customers tab	PII-free by default: id, timestamps, order metrics, tags
Collection	Collections tab	Includes productsCount, ruleSet
InventoryItem	Inventory items tab	Embedded inventory_levels per location
Shop	Shop tab	Singleton — 57 columns (plan, currency, timezone, …)

rsync.ai vs. Zapier, Make, Fivetran for Shopify → Sheets

The honest comparison if you've tried Zapier/Make and hit task quotas.

Feature

rsync.aiyou

Zapier

Make

Fivetran

Plain-English sync setup

Scheduled Shopify → Sheets sync

Historical Shopify backfill

Source-available / self-hosted

Shopify customer PII excluded by default

Multi-store consolidation

No per-task / per-row pricing

Shopify to Google Sheets — frequently asked

How is rsync.ai different from Zapier or Make for Shopify → Google Sheets?

Zapier and Make charge per task / per operation — every Shopify event consumes quota. rsync.ai is source-available and self-hosted: you pay only for the compute. It also handles full backfill of Shopify history (Zapier's free tier doesn't pull historical orders), auto-discovers the Shopify schema, and excludes customer PII (email/phone/addresses) from default queries.

How fast does the Google Sheet update when Shopify changes?

It updates on the schedule you set — every minute, every hour, daily, or cron. The connector polls Shopify's Admin GraphQL API and upserts into Sheets via the Sheets API on each run. Real-time webhook-based sync is on the roadmap but not shipped yet.

What's the maximum number of Shopify rows I can sync to one Google Sheet?

Google Sheets caps at 10 million cells per spreadsheet. For a typical orders tab with ~30 columns, that's roughly 330,000 rows. If you approach the cap, split by date range across multiple tabs or use a relational destination (Postgres / MySQL).

Can I sync multiple Shopify stores into one Google Sheet?

Yes. Each store is a separate connection; rsync.ai's per-pipeline namespacing means you can land each store's data on its own tabs in the same sheet, or merge with a `store` column.

Does Shopify customer PII reach Google Sheets?

By default, no. The Shopify connector's GraphQL queries omit customer email, phone, billing address, and shipping address — the fields are never fetched, so they can't be written to the sheet. If you need them, customize the GraphQL query in your self-hosted deployment.

What happens if I edit the Google Sheet manually — does rsync.ai overwrite my work?

rsync.ai writes to its own tabs / columns based on the schema you approved. Columns and tabs you add by hand are not touched. We recommend keeping computed views in separate tabs from the synced source-of-truth tabs.

Does rsync.ai backfill historical Shopify orders into Sheets?

Yes. The first run is a full backfill — cursor-paginated through Shopify's GraphQL API. Subsequent runs are incremental (resumed from the saved cursor), so they only pull new and updated rows.

What does Shopify → Google Sheets cost?

Source-available under Elastic License 2.0 — no per-row, per-cell, or per-task fees from rsync.ai. You pay only for the compute you run it on and Google's standard Sheets API quotas (which are generous and free).

Other Shopify destinations

Shopify → MySQL Shopify → PostgreSQL All Shopify integrations