How to get Shopify data in Google Sheets?

With Two Minute Reports’ Shopify Connector, you can extract your Shopify store data 10x faster and optimize performance. However, as a store admin, you’ll need to create a custom app in your Shopify store and input the app’s credentials into TMR to connect your Shopify store.

This article will teach you how to create a custom app from the Shopify Admin portal, streamline Connections, and run actionable queries directly in Google Sheets.

Step 1: Install and Launch Two Minute Reports

Here’s a step-by-step tutorial on how to install TMR in Google Sheets: How to install TMR in Google Sheets?

Once done, you can connect your Shopify store account with Two Minute Reports.

Step 2: Create a new Connection to streamline your Shopify store accounts

Click Menu at the top left of the sidebar to navigate to the Connections section. Next, click Add to create a new Connection.

The “Adding new connection” dialog box appears. Here, you can perform three key steps to access your Shopify store accounts: 

• Selecting the Shopify connector
• Authentication 
• Enabling respective accounts with the Shopify connector

Select Shopify from the list of options to connect your Shopify store to Google Sheets. Follow the below steps to generate the API credentials from your Shopify Admin portal.

Step 2.1: Creating the app from the Shopify Admin portal

Step 1: Go to the Shopify Admin portal.

Step 2: Click the Apps section in the sidebar.

Once you click Apps, the previously installed apps will be listed. Below the app names, click ‘App and sales channel settings.’

Step 3: On the next page, select the ‘Develop apps’ option.

Then, click the ‘Create an app’ option to create a new admin app. Once you click that option, a pop-up will appear. Enter the relevant details (app name and developer) and click the ‘Create app’ button.

Step 4: Once the app has been created, click ‘Configure Admin API scopes’ to access API credentials.

Step 5: Select the following scopes: 

• read_analytics
• read_customers
• read_draft_orders
• read_fulfillments
• read_inventory
• read_marketing_events
• read_orders
• read_products
• read_reports
• read_locations

Step 6: After selecting the required scopes, click Save. Now, click the ‘Install app’ button.

Step 7: Once installed, you will be given an Admin API access token. Copy that token.

Note: If you click ‘Reveal token once,’ you can view the hidden API token only once. So, ensure that you copy and store the API token in a secure location.

And that’s it. You’ve configured the credentials in the Shopify Admin portal. Next, you must copy and paste those credentials into the TMR sidebar. [Navigate to Step 2 in the Adding new connection window]

Enter your Connection name and choose the app type as Shopify Admin Custom App. Paste the API admin access token in the Access token field. Lastly, specify your shop name. 

Note: Your shop name is the subtext in your Shopify URL. For example, in the following URL, “https://thisismyshop.myshopify.com,” the shop name is “thisismyshop.”

Once done, click Test and Save.

Your Shopify store will now be authenticated. As shown below, you can proceed with selecting the respective store accounts to analyze performance data.

Enable the accounts for which you want to run queries. Once enabled, Speedboost will be automatically activated, performing two critical functions:

1. Warm up – Prepares your account for faster data retrieval by caching your historical data. 
2. Periodic sync – Ensures your data stays updated automatically at regular intervals.

Please note that you can extract data from relevant store accounts only after the warm up (approx. 2 to 24 hours) process is completed. Additionally, you cannot run queries for disabled accounts.

Once you’ve enabled the associated accounts, you can hit “Refresh Connections” to ensure the connected accounts are reflected in the TMR sidebar.

And that’s it. You can now extract Shopify store KPIs in Google Sheets to gain actionable insights.

Step 3: Fetching Shopify store data to Google Sheets

To pull Shopify store data to Google Sheets, you must create a new query by navigating to the Data Queries section.

Click Add and choose the respective Shopify store accounts to analyze your performance. You can manage multiple store accounts in one place. Simply select one or more accounts to extract and gather insights.

Alternatively, navigate to the Clients section. Add your client and map their corresponding Shopify store account. 

Click on “Manage Clients” and map the necessary account details. Once done, click “Save & Close” to save your client’s details for future reference.

Next, add the Shopify metrics and dimensions you want to analyze. Once done, select the date range for which you want to track performance insights.

Next, you have to configure your data reporting by choosing how to customize it.

It would be best to customize your data reporting by selecting the relevant fields and choosing whether to sort them in ascending or descending order. You can also apply custom filters to display only the necessary information.

Once you finish the above steps, click Run Query to visualize the output.

Now, you can use different Google Sheet features, such as pivot tables and VLOOKUP(), to extract critical insights and build charts to visualize your Shopify store performance.

Pro TMR Tip: Run all your queries directly from the Extensions menu on your Google Sheets. Go to Extensions > Two Minute Reports > choose your desired quick action.

Step 4: (Optional) Get automatic data updates via Schedule Refresh

Once you create a report in Google Sheets, you can schedule automatic updates to get updated data. This feature is convenient for sending emails or refreshing your spreadsheets with live data and using them as a dashboard.

Under the email section, you can enter the recipient’s email ID and save the new schedule.

You can also choose to specify the reporting format. You can insert the sheet content in the email body, attach the selected sheet as a PDF or Excel, or attach the spreadsheet as an Excel file.

Two Minute Reports’ Schedule Refresh feature has further capabilities. Continue reading about this feature: How to Refresh Data Automatically in Google Sheets?

We hope you found this guide helpful. If you have any questions, please contact our support team via support@twominutereports.com.