Skip to main content
Shopify → Google Sheets

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, then incremental for orders, products and customers. 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.

  • Full backfill on first run, then incremental for orders, products and customers
  • Scheduled batch sync — every minute, hour, or day (describe it in plain English)
  • Customer PII excluded from default GraphQL queries by design
  • Self-host in your own VPC — source-available under the rsync.ai Source-Available License
Start freeSee 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. 1

    Connect Shopify

    Provide your Shopify store subdomain and an Admin API access token. Token is sent as `X-Shopify-Access-Token` — stored encrypted in rsync.ai's control plane (or self-hosted in your own VPC).

    shop + access_token
  2. 2

    Connect Google Sheets

    Authorize Google Sheets via OAuth. rsync.ai requests Google's Sheets scope: it can read and write your spreadsheets but gets no access to the rest of your Drive.

    Sheets scope only · No wider Drive access
  3. 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. 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. 5

    Run on a schedule

    Every scheduled run reads from Shopify with saved cursors and appends rows to the sheet. Orders, products and customers are read incrementally, so a changed order is appended again as a new row; collections, inventory items and the shop record are re-read in full, so schedule those less often. 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 resourceSheet / tabNotes
OrderOrders tabEmbedded line items (first 10) — customer/email/address fields excluded by default
ProductProducts tabEmbedded variants (first 5)
CustomerCustomers tabPII-free by default: id, timestamps, order metrics, tags
CollectionCollections tabIncludes productsCount, ruleSet
InventoryItemInventory items tabEmbedded inventory_levels per location
ShopShop tabSingleton — 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.

Featurersync.aiyouZapierMakeFivetran
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 Cloud is live today with no per-task fees; you can also self-host rsync.ai (source-available under the rsync.ai Source-Available License) and 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 appends rows to 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, you can 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 only appends rows below the existing data in the tabs you chose; it doesn't rewrite cells it has already written, so edits you make to existing rows stay put. It also keeps a `_rsync_pipelines` tab for run metadata, so leave that tab in place. Keep formulas, pivots and computed views on separate tabs so appended rows don't collide with them.

Does rsync.ai backfill historical Shopify orders into Sheets?

Yes. The first run is a full backfill — cursor-paginated through Shopify's GraphQL API. After that, orders, products and customers are read incrementally by updated time; collections, inventory items and the shop record are re-read in full on every run.

What does Shopify → Google Sheets cost?

rsync.ai Cloud starts free: the first 10 GB of data moved is free, then usage is billed by GB moved, and pipelines pause at your cap. There are no per-row or per-MAR fees. You can also self-host rsync.ai, which is source-available under the rsync.ai Source-Available License and free for your company's own internal use, and pay only for the compute you run it on. Google's Sheets API quotas are free but rate-limited.

Run your first Shopify to Google Sheets pipeline free

The first 10 GB of data moved is free. Describe the sync in plain English and review the plan before anything runs.

Start free

Other Shopify destinations

Shopify → MySQLShopify → PostgreSQLAll Shopify integrations