How to Connect Shopify to Google Sheets

How to connect Shopify to Google Sheets
Reading Time: 4 minutes

Connect Shopify to Google Sheets and track real-time store sales, payment status and gateway information, billing and shipment information, cancellation status and reason–in short, all sorts of data available in Shopify. You can leverage these data and reduce leakages and inefficiencies.

Integrating your Shopify store and Google Sheets is easy and simple. Install the Amigo Data extension in Google Sheets, set up a connection, and you’re good to go. You’ll then be able to import Shopify data to Google Sheets in mere seconds. And that’s not the end of it. Amigo can retrieve the data automatically and send them to your inbox or Slack channel. Using Amigo, you can achieve more by doing less.

So, let us learn how to connect Shopify to Google Sheets and also learn how to import data from Shopify to Google Sheets.

Sections of the article:

How to connect Shopify to Google Sheets

Install Amigo Add-on

But before you proceed, install the Amigo add-on; and the following steps will be a cakewalk.

Get it from the Google Workspace Marketplace by clicking the link provided below.

Amigo Data in Google Workspace Marketplace

Amigo installation link

Alternatively, you can get it from within Google Sheets itself.

  • Open a Google Sheets document
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo and install

Once the installation is complete, the Amigo add-on should appear in your Google Sheets Extensions list.

Connect Shopify to Amigo

Open Google Sheets and launch Amigo by clicking Extensions→Amigo: Data Exports and Reports→Connect.

Connecting to Amigo

Select Shopify from the list of sources

List of sources to connect

Amigo Shopify app

Click the Install app button to connect your store to Amigo.

Install Amigo to create a connection

Import Shopify data to Google Sheets

Go back to Google Sheets, relaunch Amigo Data and select the Shopify store you’ve just connected from the sources list in Amigo.

The connected store

From the dashboard, select the data set to import from the dropdown menu, eg, Orders.

Types of data available for import

Select the date range (if applicable). We’ll select Current-X and choose Months to get the order reports for the current month.

Specifying a date range

In the Fields section are found all the types of data that can be imported–information about orders and shipments. Click the drop-down menu and select all that you want to import. Or click the Select All checkbox to import all available data.

Fields values
Selected field values and filtering options

After the dataset has been selected and the fields added, click the PREVIEW button to verify if the data to import are what you desired.

Preview of the data

Then click the IMPORT button to import the data into Google Sheets. The data will be imported into Google Sheets in a few moments.

Snippet of the imported data

If you forgot to include some fields or want some removed, you can edit the report and make the changes you want instead of starting anew the process of importing the data.

Click the View Reports option. Then select the report that you want to modify and click the Edit button.

To have the data updated automatically and have them sent to your inbox or to Slack so that you can simply sit back and watch, set a refresh schedule and set up an alert in Amigo Data. Follow this link to learn how to set a refresh schedule.

There are several other data sources that you can connect to Google Sheets and automatically pull the data to Google Sheets with Amigo Data. Visit our blog to find out more.

Some recommended articles:

Import Data from Google Search Console to Google Sheets

Export Google Ads Data To Google Sheets

How to Connect Woocommerce to Google Sheets