Connect Shopify to Google Sheets: Tutorial and Free Templates (2026)

Struggling to import your Shopify store data to Google Sheets? If yes, you’ve landed in the right place.

This guide will teach you how to integrate your Shopify store with Google Sheets using Two Minute Reports. By the end, you can create data-driven Shopify reports that help streamline your online store’s analytics and reporting.

Let’s get started.

How to connect Shopify to Google Sheets?

You can import your Shopify store data to Google Sheets via two methods:

Method 1: Connecting Shopify to Google Sheets using the Two Minute Reports Hub.

Method 2: Connecting Shopify to Google Sheets using the pre-built templates.

Let’s get started with the first method.

Method 1: Connect Shopify to Google Sheets using the Two Minute Reports Hub

The Two Minute Reports Hub is your centralized workspace for managing all your Shopify stores. Here’s how to get started.

Step 1: Creating a Connection

1. Go to hub.twominutereports.com and click Connections → Create Connection.

2. Inside the dialog box, complete these three steps:

• Select the Shopify connector from the list of options.

• Next authorize your connection by selecting the app type: You could either choose Shopify Public App and enter your store URL, or choose Shopify Admin Custom App and enter the access token. Checkout our article on creating the app from your Shopify store.

• Next, enable the Shopify accounts you want to track performance. Please note that you cannot query disabled accounts.

Note: With Speedboost, you can handle high-volume Shopify store datasets and create lightning-fast reports without any delays. This is an exclusive technology of Two Minute Reports built for scalable client reporting.

3. Once done, go back to the Hub Homepage and click Google Sheets → New Google Sheets report.

4. Click Use Template and follow the on-screen instructions to launch the Two Minute Reports add-on in your spreadsheet.

Step 2: Configure and Run Your Query

1. Once you’ve installed the add-on, navigate to Menu → Data Queries and click Add.

2. Select the Shopify accounts that you want to include from the sidebar.

3. If you’re managing multiple clients, go to Clients → Manage Clients, map your Shopify accounts to the relevant clients and click Save & Close. 

4. Once you’ve set up the accounts, choose relevant Shopify metrics and select your date range.

5. Consider that we need to build a Shopify sales report in Google Sheets. Here are the metrics and dimensions you can choose:

Key Metrics and Dimensions to include in a Shopify Sales Report

Type	Field	Why do we use it?
Metric	Net Sales Amount	Shows the total sales generated after returns and refunds. This is the primary revenue metric.
Metric	Orders	Shows how many orders were placed, helping us understand sales volume.
Metric	Average Order Value	Shows how much customers spend on average per order.
Metric	Net Quantity	Shows the number of products sold after accounting for returns.
Dimension	Date	Lets us track sales and order activity over time and identify trends or changes.
Dimension	Product Title	Helps identify which products are generating the most sales and units sold.
Dimension	Customer Type	Lets us compare sales from new and returning customers.

Once you’ve chosen the fields, click Run Query to pull the data into your chosen sheet and cell.

Now our Shopify Sales Report is ready to view in Google Sheets. 

The next step is to automate your query. In this way, you can receive the latest store performance insights on the schedule you’ve set.

You can either click Save & Automate or navigate to Menu → Schedule Refresh. Either way, the steps remain the same. 

For now, let’s click Save & Automate. Then follow the steps below.

• First, enter your schedule name. Let’s enter as Shopify store performance summary.
• Next, select the queries to include in this schedule. You can choose multiple queries if you want them to refresh on the same schedule.
• Then, choose how often you want to refresh – hourly, daily, weekly and monthly.
• Specify the exact timezone for the refreshes to occur.

Once you are done with the above steps, you can set up your Shopify reports to be delivered via email. Here’s how you can:

• To enable email delivery, move the toggle to ‘Email’.
• Next, select the Sheet to report. This sheet will be sent to your email.
• Enter the email addresses of your recipients – your clients, team members or stakeholders.
• Select whether you need to attach the report as a PDF, Excel/CSV or both.
• Write a customized email subject and body message to include with each report.

And that’s it. Your schedule is now saved. From here on, you can receive real-time Shopify data in Google Sheets delivered to your inbox.

Let us next move on to the second step, which is using pre-built templates.

Set up your data pipeline

Take my data from

Shopify

Save my data to

Google Sheets

PROCEED

Method 2: Using Shopify Google Sheets Template

With Two Minute Reports’ pre-built Shopify templates for Google Sheets, you can create custom store reports within minutes. Here’s how you can:

1. In the template gallery, select the Shopify Traffic Dashboard Template.

2. Next, click ‘Get Template for Free’ to open the Google Sheets template.

3. Then, click Use Template. You’ll land on the Google Sheets dashboard.

4. Click Use to launch the Two Minute Report sidebar in your Google Sheets.

5. Finish importing your template by selecting the required Shopify store accounts from the dropdown. Once done, click Submit to create your report.

6. Click Run Query to fill this template with the necessary data.

7. And that’s it. Your Shopify store’s data is populated across relevant sections, helping you give a detailed overview of what’s happening and what needs to be improved.

Shopify Dashboard with Traffic and Sales report

View Template

Once your Shopify data is in Google Sheets, you can track key metrics such as average order value, order volume, items per order, discount rate and return rate over time. Shopify benchmarks vary significantly across industries, with median AOV ranging from $38.29 to $153.54, median orders per store ranging from 626 to 8978, and return rates by order count ranging from 0.54% to 4.23%.

To see how your store compares with other businesses in your industry, explore our Shopify benchmarks.

Why connect Shopify data to Google Sheets?

In the dynamic realm of ecommerce, staying abreast of your store’s data is essential. The Shopify Google Sheets integration saves you from the tedium of manual data entry and ensures your business data is neatly organized in your Google Sheets, giving clients a clear view of what is happening and the revenue generated.

Streamline your workflow with Google Sheets and Shopify integration

With Shopify to Google Sheets integration, you can receive automated, real-time updates on new Shopify orders and purchases, saving you time and eliminating manual data entry. You can deliver up-to-date ROI insights to clients by specifying what has worked, improvement areas, and data-driven steps to allocate optimum budget.

Enhanced data accuracy and reporting

While Shopify's built-in data capabilities are robust, connecting Shopify to Google Sheets exponentially enhances your ability to analyze, customize, and report on sales and customer information. This integration turns your Google Sheets into a powerful data destination, offering detailed reports that can be easily tailored to your client’s needs, enabling deeper insights and faster decision-making.

Optimize your customer behavior 

Understanding your Shopify customers is crucial for growth. Connecting Shopify to Google Sheets lets you gain deeper insights into customer behavior and sales trends. You can import your store customers’ data and customize it in your spreadsheet. This lets you identify buying patterns and purchasing trends, allowing you to devise strategies that boost retention and revenue.

Simplify inventory management

Connecting Shopify to Google Sheets streamlines inventory management by providing real-time stock updates. Using a dedicated Shopify reporting tool makes it easier to track key metrics such as inventory quantity, inventory value, etc, so you can make informed decisions in improving overall profitability by aligning inventory with demand.

Facilitate collaboration and accessibility 

Sharing business insights with your team is as simple as sharing a link to a Spreadsheet. This encourages collaboration, ensuring your team can access critical insights quickly and contribute to the latest data on Shopify orders, customer details, etc, to streamline ecommerce processes in Google Sheets. 

Tips for managing Shopify data via Google Sheets integration

Follow these five proven tips to effectively manage your Shopify store data when integrating with 

Google Sheets. 

1. Automate data syncing

Updating your latest sales performance data in Google Sheets can be time-consuming and prone to errors, negatively impacting measurable outcomes. Instead, you can automate the process to sync data at defined intervals, ensuring you can access real-time insights at your fingertips anytime.

How to automate? By leveraging Two Minute Reports’ Schedule Refresh, you can set up automatic data updates – daily, hourly, weekly, or monthly - so your Google Sheets have the latest store insights.

2. Use filters and data validation

You might feel overwhelmed as your Shopify store generates vast amounts of daily data (orders, inventory, sales, customers). With filters and validation, you keep your data organized and ensure only the necessary information is displayed, allowing you to act quickly on critical insights.

How to use filters and data validation?

Filters: You can apply filters to focus on specific subsets, such as viewing orders from a particular date range or customer demographics in a specific location.

Validation: For example, you can set data validation to allow only email addresses in the customer email column or only valid currency entries in the payment column, eliminating manual struggles and complexities in managing data.

3. Use data aggregation for larger datasets

Importing large datasets from Shopify can slow your spreadsheets' speed, accuracy, and overall performance. During critical times, this might cause chaos and lead to client dissatisfaction.

Solution: With Two Minute Reports’ exclusive Speedboost technology, you can instantly retrieve complex Shopify datasets in under seconds and visualize actionable ROI insights without the wait.

4. Ensure accurate data mapping

While importing your Shopify data, you must ensure that every piece is mapped with the corresponding columns in Google Sheets. If not, this might lead to data inconsistencies, impacting critical performance outcomes.

Solution: With Two Minute Reports, you can sync your store accounts and automatically map the data fields, enabling seamless data accuracy. This saves time and ensures you work with real-time, consistent data, which lets you analyze data-driven opportunities effectively.

Track Shopify metrics to streamline your ROI

Let’s explore the crucial Shopify metrics that provide valuable insights into your store’s performance.

Order 

Analyze total sales, gross sales, discounts, and tax amounts in Shopify reports to identify areas for improvement in operations. Use insights from this data to adjust pricing strategies, discount offerings, and tax calculations for more profitable sales.

Sales

Examine total sales, gross sales, discounts, and tax amounts in Shopify reports to pinpoint operational improvement areas. Utilize insights to refine pricing strategies, discount offerings, and tax calculations, enhancing sales profitability.

Product

Assess product title, SKU, sales and inventory quantity, product ID, variant title, product type, price, inventory value, and cost of goods sold on Shopify to optimize operations.

Store

Identify store names and IDs to segment sales and customer behavior across stores. Compare performance across locations, determine best sellers, and assess promotional tactics to enhance operations. Utilize this information to pinpoint profitable stores and streamline inventory quantity.

Traffic source

Examine customer behavior and refine marketing strategies by utilizing Shopify's first and last visit sources, dates, and types. Enhance operations by generating targeted reports based on these insights to elevate conversion rates and increase revenue.

Customer Insights

Evaluate customer behavior using email, names, unique IDs, customer types, and tags. Create detailed customer profiles, personalize outreach, optimize websites, update inventory, and enhance customer experience for improved marketing and data-driven decisions.

Title	Description
Customer first name	The first name of the customer.
Customer email	The email of the customer.
Customer type	Whether the customer is a Returing customer (Customers whose order history includes two or more orders) or a First-time customer.
Account created date	The date the customer was added to the online store.

Generate data-driven Shopify reports in Google Sheets

By connecting Shopify to Google Sheets, you can transform data into actionable insights, automate routine tasks, and focus on growing your business. Bid adieu to lengthy spreadsheets and streamline valuable insights with this easy-to-use Shopify Google Sheets integration via Two Minute Reports. In addition to Shopify, you can connect other ecommerce platforms, such as Amazon Seller and WooCommerce, with Google Sheets and streamline your sales, inventory tracking, and customer behaviour seamlessly. No need to juggle platforms. No need to struggle with broken reports or cluttered dashboards.

Set up your data pipeline

Take my data from

Shopify

Save my data to

Google Sheets

PROCEED