Get Shopify Data onto Google Sheets

You can now get key sales, orders, and online store visitor data of your Shopify store right inside Google Sheets. This makes it easier to glance how your store is performing—across all of your sales channels, and for any date range.

Keeping track of of all your Shopify metrics can be tedious, as the data keeps changing dynamically. Creating a custom report in Google Sheets makes it easier to retain the data you need to make consistent analysis of your store across different dates and dimension.

Store managers can

  • check recent sales and compare them to a previous time period
  • check how well different sales channels are performing
  • track average order value, order count, etc over time
  • monitor the trends over time
  • more..

All these are possible without writing a single line of code in google sheets. Let me show you how.

If you want something quick, here is a video to help you through the entire setup process

Step 1 : Connect your Shopify store to Google Sheets

Install Two Minute Reports (TMR), if you have not done already and open the TMR addon in Google Sheets.

Navigate to the Data Sources section, click on the Add+ button at the top right corner to display the new Data Source form. Name your data source and select eCommerce -> Shopify from the dropdown.

We need to create a Private App in your Shopify Store and add the credentials inside TMR. Login to your shopify store, go to Aps on the left sidebar. Click on the small “Manage Private App” link at the bottom of the page in the right side.

Create a new App from there, and give it a friendly name.

More importantly open the “Admin API” section while creating the App and enable Read Access permission to these – Customers, Fulfillment services, Inventory, Orders and Products. This enables TMR to get data securely from you Shopify store to your Google Sheets.

On Clicking Save -> Create app, you will get the API Key and password of your private App.

Feed in these details along with the ID of your store in the Add Data Source section. Once saved you can now access your Shopify store data from any Google Sheets spreadsheet and monitor your store. Lets see how.

Step 2 : Fetch Data onto Google Sheets

Now that your data source has been connected, you can write your own Shopify queries and start fetching data onto the Google Sheets

  • Go to the Data Queries section and press Add
  • Select your newly added Data Source and select the fields that you need
  • Once a query runs successfully, you should see the data populate on your spreadsheet

You can then freely select the metrics and dimensions you need for your Shopify Store. If you think your required metrics or dimensions are missing, please don’t hesitate to contact our support. We will makes sure to add your field within a week.

Now you can use different Google Sheets features like Pivot Table, VLOOKUP(), charts to create and customize your custom report.

Once a report is created you can create a Schedule in Google Sheets to automatically update your sheets and keep your data up-to-date. This feature is handy to send emails, or just refresh your spreadsheets with live data and use it as a Dashboard.


Was this helpful?