Google Sheets Sync Documentation
Everything you need to connect Shopify to Google Sheets and keep your orders and products in sync.
Overview
Google Sheets Sync keeps your Shopify orders and products in sync with Google Sheets. It exports orders to a spreadsheet in real time, on a schedule or manually, and syncs products two ways so you can edit your catalog in Sheets and push changes back to Shopify.
Send orders to Sheets with 10+ customizable columns.
Export variants and import price, stock, status and SKU.
Multiple spreadsheets, tabs, directions and schedules.
A full history of every sync and the rows it changed.
Getting started
You can have your first sync running in a few minutes. Install the app, connect Google, choose a sheet and export.
-
1
Install the app
Add Google Sheets Sync from the Shopify App Store and open it from your Shopify admin.
-
2
Connect your Google account
Sign in with Google through OAuth and grant the drive.file permission.
-
3
Choose or create a sheet
Use the Google Picker to link an existing spreadsheet, or create a new blank one.
-
4
Run your first export
Map your columns, then export orders or products to confirm the rows appear in your sheet.
Connecting Google
Google Sheets Sync uses Google OAuth 2.0 to connect your account securely, with the minimum access it needs.
Click connect, choose your Google account and approve access in the standard Google consent screen.
The app requests only the drive.file scope, so it can access just the sheets you create or pick — not your entire Drive.
Revoke access from the app settings or from your Google account whenever you like.
If a sync fails with a permission error, reconnect your Google account to refresh the authorization.
Exporting orders
Send your Shopify orders to Google Sheets with the columns you choose, and keep them flowing automatically.
Order number, date, customer name, phone, address, city, products, item count, total, payment and fulfillment status, tags and notes.
Choose which fields to include and arrange them into the column layout you want.
New orders append automatically via the orders/create webhook the moment they are placed.
Add new orders newest-first or oldest-first to match how your team reads the sheet.
Orders are export-only — Shopify orders are immutable, so changes you make in the sheet are not written back to Shopify.
Syncing products
Products sync two ways. Export your catalog to a sheet, edit it, and push changes back to Shopify using a key column to match rows.
Send products and their variants — SKU, price, compare-at, barcode, inventory and options — to a sheet.
Edit price, inventory, status or SKU in the sheet and import the changes into Shopify.
Match rows to products by Handle, Variant SKU or Product ID so updates land on the right items.
Large catalogs (250+ products) sync through automatic bulk operations for speed and reliability.
Set the sync direction per profile: Shopify to Sheets, Sheets to Shopify, or two-way.
Sync profiles & schedules
Each sync profile defines what syncs, to which sheet and tab, in which direction and on which schedule. Create as many as you need.
Run several profiles at once — for example orders to one sheet and products to another.
Each profile writes to its own tab, and the app creates tabs automatically.
Pick Shopify to Sheets, Sheets to Shopify or two-way for each profile.
Choose real-time, manual, hourly or daily syncing per profile.
Sync history & run logs
Every sync is recorded so you can confirm your data is correct and diagnose anything that did not go as expected.
See whether each run was real-time, scheduled or manual, and whether it succeeded.
Track rows processed, created, updated, deleted and failed for every run.
Each entry is timestamped in your chosen timezone and date format.
See your monthly export and import usage against your plan's row limits.
Troubleshooting & FAQ
Quick answers to the most common setup questions.
Confirm the profile is set to real-time and that your Google account is still connected — reconnect if a permission error shows in the run logs.
Check that your key column (Handle, Variant SKU or Product ID) is filled in and unique for every row you import.
Your plan caps monthly exports and imports. Upgrade for a higher limit, or wait for the limit to reset.
Contact our support team from the link in the sidebar — we typically reply within minutes.
Put your Shopify data on autopilot
Everything you need to connect Shopify to Google Sheets and keep your orders and products in sync.
Add to Shopify