Back to Blog

How to Export Shopify to Google Sheets Without Coding

Most of you know a native way to export Shopify data (products, orders, reports, etc.). It is the Export button, which lets you download a CSV file with your data. After that, you can open this CSV in a spreadsheet tool, such as Google Sheets or Excel, to manipulate your data. Manual data export is fine if you don’t need to do this recurrently. Otherwise, you’d better automate the process. We’ll explain how you can do this easily without a single line of code!

How to export products from Shopify manually

A quick reminder of how most users export data, for example, products, from Shopify. They usually: 

  • Go to the Products page and click “Export“. 
  • Then they select which products to export, as well as the CSV file format, and click “Export products“.

As a result they get the CSV file either downloaded to their device (for less than 50 records) or emailed to them (for more than 50 records). Then they need to manually import this CSV to Google Sheets. What a pain! 

Let’s simply integrate Shopify and Google Sheets to avoid all this.

Connect Shopify to Google Sheets for automatic data exports

You can’t automate data export from Shopify to Google Sheets using the native functionality. But you can do this with Coupler.io, a solution for importing data on a schedule to Google Sheets, Excel or BigQuery from different sources, such as Shopify, Pipedrive, Jira, Xero, and many more.

Coupler.io allows you to pull the following information from your Shopify store to Google Sheets:

  • Customers
  • Products 
  • Orders  
  • Orders with line items

Besides those, you can set up a custom export of other data from Shopify, such as transactions, payouts, etc. via the Shopify REST API. Jump to the respective section if this is what you want.

In any case, to connect Shopify to Google Sheets, you’ll need to take two high-level steps:

  1. Get Shopify API credentials
  2. Set up the Shopify importer

How to get Shopify API credentials

To access the Shopify API and export data from your store, you’ll need to create a Shopify custom app.

  • Go to the Apps menu of your Shopify store.
  • Click Manage private apps.
  • Click Enable private app development and provide your consent to the specified terms. This is required to let you create your private apps or make changes to them.
  • Once private app development is enabled, you can create your new private app by clicking the respective button.
  • Specify the App details: Private app name and Emergency developer email. Neither field can be blank.
  • Scroll down to the section “Active Permissions For This App” with the Products permission set to Read access. You’ll need to activate permissions for:
  • Products
  • Customers
  • Inventory
  • Orders

To do this, click Show inactive Admin API permissions.

  • Change access status for Products, Customers, Inventory, and Orders to Read access.
  • Click Save and then Create app to obtain API credentials.

You’ll find your Shopify API credentials in the Admin API block.

To connect Shopify to Google Sheets, we’ll need the following values:

  • API key 
  • Password
  • Example URL (required for exporting data via Shopify API)

Set up the Shopify integration to automatically export Shopify into Google Sheets

Coupler.io is available as a web app and a Google Sheets add-on. We’ll check out the setup flow for the web app. The flow for the add-on is the same, but you’ll need to install the add-on from the Google Workspace Marketplace.

Sign in to Coupler.io, click “Add importer” and name it as you want. After that, complete three steps:

  • Set up Source (connect to Shopify and choose the data for export)
  • Set up Destination (choose the spreadsheet to export data to)
  • Set up Schedule (customize the frequency for your data exports) 

Set up Source (Shopify)

  • Source application: choose Shopify. Click “Continue“. 
  • Shop name: Enter the hostname of your Shopify store in the following format:
{shop_name}.myshopify.com

{shop_name} – replace with the name of your Shopify store

  • API key: Enter the API key of your Shopify store.
  • API password: Enter the API password of your Shopify store.
  • Data entity: Select the data entity you want to import from Shopify: Customers, Products, Orders or Orders with line items.

Click “Proceed to Destination Settings” or “Continue” if you want to configure the additional filter parameters:

  • Filter after ID
  • Created before date
  • Created after date
  • Changed before date
  • Changed after date
  • Order status
  • Order financial status
  • Product status
  • Fields

Read the Coupler.io knowledge base to discover how you can use these filter parameters.

Set up Destination (Google Sheets)

  • Select Google Sheets as the destination. Click “Continue“. 
  • Connect your Google account: click “Connect“, and log in to your account. Click “Continue“.
  • Choose the spreadsheet, as well as the sheet to export data to. Click “Continue“.
  • In the next steps you can specify the first cell to import your data range to, as well as the import mode (replace or append). Click “Continue“.

Set up Schedule

To automate data export from Shopify on a schedule, toggle on Automatic data refresh and specify the Frequency.

Your Shopify to Google Sheets integration is almost ready. Click “Save & Run” to save the parameters and run the initial data import right away.

Let’s explore the Shopify to Google Sheets integration in practice.

Use case: Shopify export products data including inventory details to Google Sheets 

We need to export the products inventory from our Shopify store to Google Sheets. The data should be transferred automatically every hour, so we can track the inventory and share the report with the stakeholders. Besides, we don’t need all the available columns, but only a few ones. 

Export all Shopify products with product IDs, tags, and other details

First, let’s export the Shopify products as described above. In our case, we’ve got 79 columns of data, which is huge! 

To track the inventory efficiently, the following columns would be enough:

  • product_id (column A)
  • product_title (column B)
  • product_body_html (column C)
  • product_product_type (column E)
  • price (column R)
  • sku (column S)
  • inventory_quantity (column AK)

To only return these columns, list them in the Fields parameter of the Advanced Settings as follows:

Now we can update our Shopify to Google Sheets integration to export the columns we need on a schedule.

Configuration to export specific columns about Shopify products on a schedule

Here is what the parameters for our integration between Shopify and Google Sheets will look like:

Source
ApplicationShopify
Basic settings
Shop namesf-sandwiches.myshopify.com
API key**********************
API password**********************
Data entityProducts
Advanced settings
Fieldsproduct_id, product_title, product_body_html, product_product_type, price, sku, inventory_quantity
Destination
ApplicationGoogle Sheets
Accountexample@gmail.com
SpreadsheetShopify to Google Sheets
SheetShopify products
Cell addressA1
Import modeReplace
Schedule
IntervalEvery hour
Days of weekMon, Tue, Wed, Thu, Fri
Time preferences18:00 – 19:00
Schedule time zone(GMT-07:00) PDT – America/Vancouver

What you can do with this Shopify – Google Sheets integration

Can I export products and images from Shopify in this way?

Yes you can! The product data you get will also contain different information about their images, such as width, height, id, URL, etc. 

Can I only export visible Shopify products?

Sure you can! By default, you get a list of all products of your store including active and archived ones, as well as drafts. If you need to only export the active products on your Shopify store, choose the respective value in the Product status of the Advanced Settings.

Can I export sold out Shopify products in this way?

Another yes 🙂 The data you can export from Shopify to Google Sheets using Coupler.io will contain the inventory information of your products.

Can I export the product page URL for Shopify products?

When you export Shopify to Google Sheets, you don’t get product page URLs for your Shopify products, just product handles. But you can use the power of Google Sheets to automate the creation of URLs using the you export.

For example, we added a column to the left of the data exported from Shopify. In this case, we edited the Cell address of the Destination setup of our Shopify integration. Now it is B1 instead of A1.

Then we applied the formula, which will concatenate the URL of our Shopify store with the product handle. For this, we nested CONCAT and ARRAYFORMULA functions like this:

={"URL";arrayformula(if(len(H2:H)=0,,concat("https://sf-sandwiches.myshopify.com/products/",H2:H)))}
  • sf-sandwiches.myshopify.com – replace with the name of your Shopify store
  • H2:H – the column with the product handle

As a result, we’ve got a column that will generate the product URLs once the product data is exported from Shopify.

Can I export Shopify products with metafields?

You can, and we’ve already blogged about this in How to Export Shopify Data. Check it out!


This Shopify to Google Sheets integration will work well for exporting products, as well as orders and customers if you choose them as a data entity. To export other data entities, you can connect to the Shopify API using Coupler.io.

How to export other data from Shopify to Google Sheets via API

Let’s say you need to export various implicit data from Shopify, for example, collections, transactions, metafields, etc. You can do this with Coupler.io as well, but the setup flow will be slightly different. You’ll need to select the JSON Client as a source and configure it to connect to the Shopify API .

With the JSON Client, you can get data using REST APIs from different apps. For example, Etsy allows its users to download two types of data in CSV, but with the JSON Client importer, you can import much more. Check out how it works in our Etsy to CSV blog post.

Let’s explore one use case to have some practice. 

Set up the Shopify integration with Google Sheets using the JSON Client importer

First, make sure to add Read access permission to this data entity in your Shopify app. Check out the How to get Shopify API credentials section, if you need more details.

Also, copy the Example URL that you obtained with credentials.

Now, you can go to Coupler.io, add a new importer, and set up the source. 

Shopify export products with collections

  • Select JSON Client as a source. Click “Continue“.
  • JSON URL – insert the Example URL and replace the resource “orders.json” with the following string:
collections/{collection-id}/products.json

You can find the collection ID in the URL bar of your browser when you select the collection.

So, your JSON URL should look as follows:

https://b104dw48dg97bp9ukke89uvzp7a41d:shppa_b57ecxb6p84k0t3epwdqoq7b716a0@sf-sandwiches.myshopify.com/admin/api/2021-04/collections/269278904474/products.json

Click “Continue“.

  • Path – Enter the “products” string to select nested objects from the JSON response.

Now you can proceed to setting up the destination and schedule – the steps are the same as during the Shopify importer setup. When you’re ready, click “Save and Run” and welcome your Shopify data in Google Sheets. Here is how it looks in our example:

What data you can export from Shopify to Google Sheets using the JSON Client importer

For more information on other data entities available for export from Shopify, read the Shopify API documentation. Below, we introduced just a few examples.

Data entityJSON URLPath
List of products.../products.jsonproducts
List of customers.../customers.jsoncustomers
List of orders.../orders.json?status=anyorders
Orders by customer.../customers/{customer-ID}/orders.jsonorders
Reports
(available to Shopify Advanced and Shopify Plus merchants only)
.../reports.jsonreports
Application charges.../application_charges.json
Application credits.../application_credits.json
List of locations.../locations.jsonlocations
List of blogs.../blogs.jsonblogs
Current balance*.../shopify_payments/balance.json
List of disputes* (initiated at the specified date).../shopify_payments/disputes.json?initiated_at={yyyy-mm-dd}
List of all payouts*.../shopify_payments/payouts.json
List of all balance transactions paid out in the specified payout*.../shopify_payments/balance/transactions.json?payout_id={payout-id}

*If you get an error with the Shopify Payments endpoints, it’s most likely that the Shopify Payments module is not available in your region. 

Should I export Shopify orders and other data to Google Sheets on a schedule? 

If you have to export some data from your Shopify store once per quarter (or rarely), then you may prefer a manual approach. However, it’s very convenient to have your recurring tasks automated, isn’t it? The integration we’ve built with Coupler.io allows you to customize the schedule of data exports from Shopify to Google Sheets. So, why would you need to do this by hand? Anyway, it’s up to you.

We hope that this integration built either with the Shopify importer or JSON Client importer did the job for you. If you want to have another  data source to import data from, tell us about it by filling out this form. The Coupler.io team is working on new integrations and your opinion is valuable to us. Good luck with your data!

Back to Blog

Comments are closed.

Access your data
in a simple format for free!

Start Free