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 determines which orders and data will be included in your export. 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. Some common columns include:
| Data Tab | Example Columns |
|---|---|
| Products | ID, Title, Description, Vendor, Product Type, Tags, Published, Created At, Updated At, Variants |
| Orders | ID, Name, Email, Financial Status, Fulfillment Status, Total Price, Subtotal, Taxes, Shipping, Discount, Created At |
| Customers | ID, First Name, Last Name, Email, Phone, Orders Count, Total Spent, Tags, Created At |
| Inventory | Product ID, Variant ID, SKU, Available, On Hand, Committed, Incoming |
You can use the "Select All" and "Deselect All" buttons to quickly manage your column selections.
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:
