Export your Shopify store data to Google Sheets

Table of Contents

How eCommix exports works?

eCommix – Google Sheets Sync is a powerful tool that automatically exports your Shopify store data to Google Sheets:

Prerequisites

Before you get started, ensure you have connected Shopify and Google Sheets.

Create your Export

Once you have installed eCommix in your store and configured your Google Account connection, you can start exporting your data. Navigate to “Sheets” and click on “New”. You will be prompted with two options: “Import” and “Export”:

Click on “Export”. Choose from a variety of datasets to export, including products, variants, orders, line items, transactions, customers, addresses, and more. In this example, we’ll use “Orders”:

Select the preset you want, like Orders Paid, From Yesterday, etc. You can customize your sheet to include specific fields from the dataset and filter the results based on your criteria.

Click on “Edit” to choose the Sheet Columns you want to include in your spreadsheet:

For custom fields (referred to as metafields in Shopify), you can choose them at the bottom.

If you don’t want to extract all your data, you can apply filters. For example, you can filter to extract only orders with an ‘on-sale’ tag and created during 2024:

Click on “Create” when you are ready. The export process may take a few seconds to a few minutes, depending on the number of rows being extracted and inserted.

Once completed, click on the created export to view its details. You will see the number of rows inserted into Google Sheets and the time taken for the execution:

In this case, the number of rows was limited to 5000, thus the Warning. If you want to export more, review our available plans and limits.

Click on ‘Open Sheet’ to see the results:

Schedule automatic refresh

To keep your data automatically updated in Google Sheets, set up the automatic refresh. You can schedule it to export your data hourly, daily, or weekly:

With this simple yet powerful setup, you’ve unlocked a seamless flow of data from your Shopify store to Google Sheets, enabling you to manage and analyze your e-commerce information more effectively.

By automating the data import process, you save valuable time and gain real-time insights into your business’s performance.

Whether you’re looking to improve customer retention, streamline your shipping process, or share up-to-date sales reports, this integration between Shopify and Google Sheets through eCommix is your gateway to making more informed decisions and driving your business forward. Embrace this integration and watch as it transforms your approach to e-commerce data management, propelling your store to new heights.

Frequently Asked Questions

The ‘Data’ sheet cannot be renamed or removed

The automation needs this sheet name to be present to export the data.

I can’t find a field or is not formatted as I want

If you’re unable to find a field or it’s not formatted as you expect, check the Custom Attributes and Metafields sections. If the information you’re seeking comes from a third-party app, there’s a good chance it’s stored in one of these fields.

If not, please reach out to us at contact@ecommix.io. We listen to what our users need and add features based on their feedback. If the request is feasible, we usually implement it within a day or two.

Will any content I add next to the extracted records be removed?

Yes, all rows in the “Data” sheet (the first sheet) are cleared during each refresh. However, you can still work around this by referencing that data elsewhere using this formula:

IMPORTRANGE("https://docs.google.com/spreadsheets/d/your-spreadsheet-id", "Data!A:Z")

Just replace the URL with the one from your eCommix sheet.

This allows you to safely extend or work with the data, as it won’t be affected by the refresh. Pus, any references you will update automatically at the same time as the “Data” sheet refreshes.

If you’re pulling data in a different file, a pop-up will appear asking you to authorize access. Click “Allow access” to enable the connection between the two spreadsheets.

⚠️ WARNING: Avoid hiding the ‘Data’ sheet. Google Sheet power users have reported unpredictable behavior where adjacent or unrelated cells in the destination sheet may be cleared, even if they fall outside the IMPORTRANGE formula’s output range.

Can I export custom options from third-party apps like Infinite Options, Globo, and similar?

Yes, if you’ve configured custom options using third-party apps, you can extract those values from your Order datasets. They will appear as Custom Attributes (Line Item) and Custom Attributes (Order) in the exported data, with each custom property listed in that column of your spreadsheet.

Is the data exported in real time?

No, data is exported on an hourly, daily, or weekly schedule, based on your configuration. We are working on adding this feature.

Can I edit an export?

No, once an export is created, its fields and filters can’t be modified. We are working on adding this feature.

Can I change column headers?

You can’t customize headers directly in the export, but you can easily work around this by referencing the exported data in another sheet or file, as explained above in “Will any content I add next to the extracted records be removed?”

Simply add your custom headers in the first row of your new sheet, and in cell A2, use a reference formula like ARRAYFORMULA or IMPORTRANGE to pull in the data.

This way, your data stays synced, and you can label the columns however you like.

Can I create the spreadsheet in a different location in my Google Drive?

The file is initially created at the root level of your Drive. After it’s created, you’re free to move it to any folder—automatic refreshes will continue to work as long as you still have access permissions.

At the moment, you can’t choose a specific file or sheet for the export while setting it up. We are working on adding this feature.

I’m only able to see orders from the last 30 days

If you’re using the Free Plan, you’ll only be able to pull orders from the last 30 days, and you can filter those orders within that timeframe, but not earlier. To access orders from any time in the past, you’ll need to upgrade to the next plan.

How to Export Refunded Items

Order Line Items have both Quantity (Line Item) and Current Quantity (Line Item).

Quantity includes all units ordered, even if refunded or removed.
Current Quantity excludes refunded or removed units.

To get refunded units, use this formula: Refunded Quantity (Line Item) = Quantity (Line Item) – Current Quantity (Line Item).

Add it to a new column by following these steps. This ensures that any update from eCommix won’t override your logic.

Ready to sync your Shopify store to Google Sheets? Export your data now.