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.
For Since last export, the first run falls back to today up to now (UTC), then future runs only fetch new rows for supported tabs.
Tip: 'Since last export' is especially well suited to Orders in Append mode, so each run adds only new rows to your Google Sheets and BigQuery tables.
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, Currency, Subtotal, Total Price, Shipping, Tax, Total Discounts, Quantity Sold, Discount Codes Applied, Discount Code ID(s), Note, Note Attributes, Source, Date Exported |
| Line Items | Line Item ID, Order ID, Order Number, Order Date, Line Item Name, Line Item Type (Product, Shipping, Refund), Quantity, Unit Price, Currency, Total Price, Discount Amount, Discount Codes Applied, Discount Code ID(s), Discounted Price, Tax fields, SKU, Variant/Product fields, Fulfillment fields, Date Exported |
| Discounts | Discount ID, Discount Type, Title, Summary, Status, Discount Code, Total Used Count, Code Used Count, Limit Total Times, Limit One Use Per Customer, Starts At, Ends At, Created At, Updated At, Value Type, Value, Value Currency, Minimum Purchase Type, Minimum Value, Eligibility Type, Eligibility Values, Eligibility Customer Segment IDs, Eligibility Customer Segment Names, Eligibility Customer Segment IDs (JSON), Eligibility Customer Segment Names (JSON), Discount URL |
| Customers | Customer ID, First Name, Last Name, Email, Notes, Created At, Last Order Date, City, Country, Country Code, Customer Segment IDs, Customer Segment Names, Customer Segment IDs (JSON), Customer Segment Names (JSON) |
| 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.
Segment fields are available as separate columns for easier reporting: Customer Segment IDs/Customer Segment Names in the Customers tab and Eligibility Customer Segment IDs/Eligibility Customer Segment Names in the Discounts tab. JSON variants are also available for BigQuery-friendly filtering and joins.
When you enable Note Attributes in the Orders tab, SyncRange exports Shopify order additional details as a single JSON array string column. This works in both Google Sheets and BigQuery exports.
[{"key":"delivery_window","value":"Afternoon"},{"key":"order_priority","value":"Urgent"}]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, each export adds new rows to the destination and leaves existing rows. When disabled, the destination is fully refreshed and existing data is removed.
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: