Automatically Export Your Data From Shopify to Google Sheets With EZ Exporter

A direct Google Sheets integrations is one of our most requested features for EZ Exporter and we're happy to announce that it's finally here!

We've had a Google Drive integration for a long time now where our users can automatically export a CSV or Excel file to a Google Drive folder.  However, we have customers who use Google Sheets heavily and prefer to have all the data they need in the same spreadsheet.

With this update, you can now do the following:

  • Add a new sheet/tab to the spreadsheet. You can use date and time variables to the sheet name as well (e.g. {{ month }}/{{ day }} Orders).
  • Add a new sheet or overwrite if the sheet already exists.
  • Append new rows to an existing sheet.
  • Overwrite an existing sheet with new data (this will clear the current data in the sheet and new data wlll be inserted).

Using this integration is pretty straightforward. 

Step 1: Connect a Google account (you can link multiple accounts)

Step 2: Update the Export Profile settings

Set Destination > Type to "Google Sheets". Then select the Google account to use, paste the spreadsheet URL, and specify the action to take and the name of the sheet/tab to create or update.

Shopify to Google Sheets Integration

You can then schedule automated data exports to update your Google Sheets spreadsheet. For example, you can have a separate sheet in Google Sheets that shows you all unfulfilled orders that gets updated every 15 minutes. You can even leave Google Sheets open and see the updates come in as they occur.

Below are some potential use cases for this integration.

1. Automatically update your dashboard.

Setting up a custom dashboard in Google Sheets is a good way for business owners to see how their business is doing. With this integration, you can have EZ Exporter periodically push out the latest data from your Shopify store to specific sheets in your spreadsheet that are used as inputs to your dashboard.

For example, you might have a sheet where you keep a list of the current day's orders, another sheet for your inventory data, and another one for customers which are then used as the data sources to power your dashboard.

2. Sharing specific Shopify data with others.

Instead of giving access to your store to certain team members or third-parties so they can view data from your store, it may be easier and safer to just simply share a Google Sheets spreadsheet with them that contains only the data they need.

In EZ Exporter, you can select just the fields you'd like to push to Google Sheets. 

For example, you may have a separate spreadsheet that you'd like to share just to your warehouse team that only includes the necessary information for fulfillment.

Another example is sharing a custom product feed with your suppliers or other platforms.  You can actually even generate a "direct download" URL with Google Sheets.

3. Create a "database" that can be used as a data source for other spreadsheets, apps, or platforms.

You might want to dump detailed Shopify data to a spreadsheet that has multiple sheets containing different types of data.  You can basically treat the spreadsheet itself as a "database" and individual sheets/tabs as "tables" in that database.

The data from this spreadsheet can then be imported by another spreadsheet. Also, since Google Sheets is quite popular, there are already many apps/platforms out there that have integrations with Google Sheets.

In a way, it's basically acting as a "bridge" that connects your Shopify data with other platforms.

4. Use Google Sheets formulas in Custom Fields.

You can enter Google Sheets formulas directly in Custom Fields and Google Sheets will automatically evaluate them when the data is sent.

For example, you can enter a Custom Field like this to have Google Sheets automatically load product images inside the cells:

=IMAGE("{{ image.src }}")

And when you export to Google Sheets, it will look like this:

Shopify to Google Sheets Integration - EZ Exporter Shopify App

Another good use case is using VLOOKUP

For example, you may already have a lookup table in a sheet/tab called "Costs" where you keep track of COGS by SKU. You can enter a formula like this to automatically pull the value for the COGS based on the SKU:

=VLOOKUP("{{ variants.sku }}", Costs!A2:D, 2, FALSE)

Here's a screenshot of where you would enter these in EZ Exporter:

Using Google Sheets formulas in EZ Exporter Custom Fields

As you can see, this opens up additional ways to display/manipulate your data as you can utilize existing Google Sheets functionalities. And the best part is, you just configure this once in EZ Exporter and it's automated after that!

We use Google Sheets quite heavily ourselves here at Highview Apps and we find it sufficient to run our business. We haven't found a need to use more complex software solutions yet and we feel this is probably the case for many small business owners as well. We really hope this integration can provide a lot of value to Shopify merchants and help make running their businesses easier!

Tags: ez exporter, shopify data export, google sheets