1. Navigate to Configure Spreadsheet
From the home page, click New Spreadsheet in the top right to start from scratch, or click the configure button (pencil icon) on any template to open the configurator with that template pre-selected.
2. Choose sync direction
Click New Spreadsheet or the edit icon on a template to open the spreadsheet configurator. In the first step, select One-Way Sync; this means data flows from Shopify into Google Sheets only.
3. Choose a template
Pick the Shopify dataset you want to export. There are over 25 templates covering Orders, Products, Customers, Inventory, and more. You can search by name or browse by category.
4. Format your data
In the Format Data step you can see a live preview of your columns and data. Use Manage Columns to add or remove fields from the export.
The Bulk Edit modal lets you toggle individual fields on or off. Fields are grouped by resource; Order, Customer, Line Item, and more; so you can quickly find what you need.
Drag any column header left or right to reorder how fields appear in your spreadsheet.
Click the pencil icon on any column header to rename it; the new name will be used as the header row in your Google Sheet.
Use filters at the bottom of the step to narrow down which records get exported. You can filter by any field; for example, only export orders with a specific status or delivery method.
5. Set the Google Sheets destination
Choose where eCommix should write your data. You can let eCommix create a new spreadsheet automatically in your Google Drive; just select the Google account and give the file a display name. You also need to set a Sheet Name (the tab name inside the spreadsheet) where the data will be written. If the tab doesn't exist yet, eCommix will create it automatically on the first sync.
Alternatively, select Use existing spreadsheet to write into a sheet you already have. You can use Google Drive; which lets you pick any spreadsheet under your connected Google Account; or Public Link, where you paste the full URL of any publicly shared spreadsheet. In both cases you also need to specify the Sheet Name (tab name) to write into.
For the Public Link option, the spreadsheet must be shared with Anyone with the link and have Editor permissions; otherwise eCommix won't be able to write data into it.
6. Choose a style
Choose No Style if you want full control over how your spreadsheet looks. eCommix will only write the data; your formatting will never be overwritten on refresh, so you can apply any colors, fonts, or styles you like and they will be preserved.
Choose Styled to have eCommix apply a fixed look; green header row and alternating grey rows; automatically after every sync. Keep in mind that any custom formatting you apply manually will be removed on the next refresh, since the style is reapplied each time. Adjacent data outside the export range is not affected.
7. Set a refresh schedule
Set a schedule to keep your sheet up to date automatically. Choose Hourly, Daily, or Weekly; eCommix will run the export on that cadence and you can see the upcoming run times before saving.
8. Save your spreadsheet
Once you have configured all the steps, click Save in the top bar to save your spreadsheet. eCommix will run the first export automatically and write your Shopify data into the Google Sheet.
After saving, your Shopify data will appear in the Google Sheet; one row per record, with the columns you selected as headers.
9. Export again
To re-export your data at any time, go to the main page and click the Sync button next to your spreadsheet.
In the modal that opens, click Export to fetch the latest data from Shopify and update your Google Sheet. You can also see the history of previous executions here.
