Learn how to set up and customize data exports from your Shopify store to Google Sheets with SyncRange.
After connecting your Shopify store, you can configure exports to send your e-commerce data to Google Sheets. This allows you to analyze sales trends, monitor inventory, track customer behavior, and create custom reports based on your store's data.
Before configuring Shopify exports, make sure you have:
Follow these steps to create a new Shopify export:
From your dashboard, go to "Export Builder" and click "Create New Export".
Choose "Shopify" from the list of available data sources.
If you have multiple Shopify stores connected, select the store you want to export data from.
Select the Google Sheet where you want to export your Shopify data.
Set up the export configuration as described in the sections below.
The Shopify export configuration screen
Click "Create Export" to save your configuration and create the export.
When configuring a Shopify export, you have several options to customize what data is exported and how it's organized:
Configure the fundamental settings for your export:
The date range applies to Orders, Line Items, Customers, and Sales Metrics only. Products, Store, Locations, Inventory, and Inventory Locations always export all current data (no date filter). Choose a range that matches your reporting needs—shorter ranges are faster to export, while longer ranges provide more historical context.
Shopify exports are organized by data types, with each type creating a separate tab in your Google Sheet. The interface uses a tab-based layout where you can configure each data type independently:
The tab interface for configuring different data types
Available data tabs include:
For each data tab, you can:
For each data tab, you can select which columns (fields) to include in your export:
The column selection interface for a data tab
Each data tab has its own set of available columns. Example columns include:
| Data Tab | Example Columns |
|---|---|
| Products | Product ID, Title, Variant ID, SKU, Barcode, Vendor, Product Type, Tags, Description, Status, Published, Handle, Image URL, Price, Compare at Price, Weight, Inventory Quantity, Options, Collections, Created/Updated Date |
| Orders | Order ID, Order Number, Date, Customer ID/Name/Email, Fulfillment Status, Financial Status, Subtotal, Total Price, Shipping, Tax, Total Discounts, Quantity Sold, Note, Source, Date Exported |
| Customers | Customer ID, First Name, Last Name, Email, Notes, Created At, Last Order Date, City, Country, Country Code |
| Inventory | Inventory Item ID, Variant ID, Product ID, Product Title, SKU, Quantity, Unit Cost, Inventory Value, Tracked, Country of Origin, HS Code |
You can use the "Select All" and "Deselect All" buttons to quickly manage your column selections.
When you configure the Orders tab, you can add up to three custom metafield columns. Each metafield you specify becomes its own column in your export: the column header is the metafield name (e.g. custom.internal_id), and each row shows that metafield’s value for that order. This works for both Google Sheets and BigQuery exports.
custom.internal_id, custom.warehouse_id, delivery.instructions).To get the exact metafield name from Shopify, use your Shopify admin (see the image below for where to find it). The name is always in the form namespace.key (for example, custom.po_number). Copy that value and paste it into the corresponding Metafield 1, 2, or 3 field in SyncRange.
The image below shows where to find or copy the order metafield name (namespace.key) in your Shopify dashboard—e.g. Settings → Custom data → Orders, or an order detail page where the metafield is shown.
In Shopify admin: go to Settings → Custom data → Orders (or the metafield definition you use). The metafield name is shown as Namespace and Key—combine them as namespace.key (e.g. custom.internal_id). You can also see it when editing an order and viewing its metafields. Use that exact value in SyncRange’s Metafield 1, 2, or 3 fields.
When you configure the Products tab, you can add up to 8 custom product metafield columns. Each metafield you specify becomes its own column in your export: the column header is the metafield name (e.g. custom.internal_id), and each row shows that metafield’s value for that product (or variant). This works for both Google Sheets and BigQuery exports.
custom.brand, custom.segment).When you configure the Collections tab, you can add up to 8 custom collection metafield columns. Each metafield you specify becomes its own column in your export: the column header is the metafield name (e.g. custom.internal_id), and each row shows that metafield’s value for that collection. This works for both Google Sheets and BigQuery exports.
custom.segment, custom.brand).namespace.key).For each data tab, you can choose how to handle the exported data:
The append option is particularly useful for building historical datasets over time. When enabled, new data will be added to existing rows rather than replacing them.
Use the append option for data you want to track over time (like orders or sales metrics), and use replace for data that represents current state (like inventory or product details).
If your export is missing expected data:
If your export fails with errors:
If your exports are running slowly or timing out: