blog post

Import your Shopify ecommerce data to Google Sheets : How-to, metrics and more

Florian Cabirol
September 11, 2024
Import your Shopify ecommerce data to Google Sheets : How-to, metrics and more

Quick steps to create a Shopify report with Google Sheets:

You can easiliy create a Shopify report following this step :

  1. Get informations from the data integration from our Shopify connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Shopify data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a Shopify report with Looker Studio:

You can easiliy create a Shopify report following this step :

  1. Get informations from the data integration from our Shopify connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Shopify at the end of the page.

The tutorial

Quick steps to create a Shopify report with PowerBI:

You can easiliy create a Shopify report following this step :

  1. Get informations from the data integration from our Shopify connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Shopify at the end of the page.

The tutorial

As digital marketing specialists and data analysts, mastering the art of data visualization and manipulation is key to drawing actionable insights. This tutorial is designed to guide you through the process of seamlessly connecting your Shopify account to Google Sheets using Catchr. By the end, you'll be adept at fetching and analyzing your Shopify data directly in Google Sheets for better marketing decisions.

How to connect your Shopify account to Google Sheets

Add a source on Catchr

To get started, navigate to the Catchr homepage. On the left menu, select Source, then click on Add a Source at the top right corner of the page. From here, choose Shopify as your platform and follow the on-screen prompts for identification to establish a connection between Catchr and Shopify.

Adding Shopify as a source in Catchr

Create a New Query

Next step involves creating a new query to start fetching data. Open Google Sheets and from the menu, select Catchr. Therein, choose New Query to initiate a fresh data extraction process tailored for Shopify.

Select Your Data Source

Within the New Query interface, specify Shopify as your data source. Should Shopify not appear in the preliminary list, you can easily integrate it by clicking on the "+" icon.

Selecting Shopify as the data source

Select Your Account(s)

Under the "Select account(s)" section, pinpoint the specific Shopify account(s) you wish to pull data from.

Selecting specific Shopify accounts

Choose Metrics and Dimensions

Proceed to the "Metrics" and "Dimensions" tabs to cherry-pick the data points you intend to analyze.

Metrics:

  • Product Price: Reflects the price of a product.
  • Product Title: Names the product.
  • Inventory Product Quantity: Indicates the stock quantity.
Choosing metrics for Shopify data

Dimensions:

  • Product Type: Categorization used for searching and filtering.
  • Product Vendor: Name of the vendor.
  • Product Tags: Comma-separated tags for further filtration.

Remember to select metrics and dimensions that align with your analytical goals.

Choosing dimensions for Shopify data

Set Date Range

Select your preferred date range for data extraction under the "Date Range" tab. Opt for presets like "Last month" or define a custom range as per your need.

Setting the date range

Apply Filters

To refine your data, utilize the "Filters" tab to apply precise filters.

  • Field: Product Type
  • Operator: Equals
  • Value: Electronics

Such a setup will exclusively fetch data for products classified under electronics.

Applying filters to the query

Schedule & Customize Data Refreshness

Last but not least, under "Options", personalize your query's data refresh frequency and opt for additional settings like "Append rows" for dynamic datasets.

Setting data refresh options

This concludes the setup phase. You've successfully created a query that fetches Shopify data into Google Sheets, paving the way for sophisticated data analysis.

Example of Google Sheets you can create to use with the Shopify source.

Integrating Shopify data with Google Sheets opens a realm of possibilities for analyzing and visualizing your eCommerce performance. Here are a few examples of Google Sheets you can create:

Product Performance Dashboard: Utilize metrics such as Product Price, Inventory Quantity, and sales performance indicators to craft a dynamic product performance dashboard. This visual tool can help you identify top-selling items, stock levels, and adjust your inventory and pricing strategies accordingly.

Customer Insights Report: Gathering data on Customer Total Spend and Order Count alongside personal details enables you to segment your customer base for targeted marketing campaigns. Create a report that identifies your most valuable customers, their preferences, and buying patterns.

Sales Trends Analysis: By pulling historical sales data, including Total Sales, Discounts, and Gross Sales, you can analyze trends over time. This analysis can inform seasonal stock planning, promotional strategies, and identify periods of high customer engagement.

Embracing the power of Shopify and Google Sheets integration through Catchr not only streamlines your workflow but also provides deep insights that can drive your business growth. The flexibility of data manipulation and visualization in Google Sheets makes it an invaluable tool for any eCommerce business looking to thrive in the digital age.

Empower your Marketing data analysis
Discover +50 connectors to import your Marketing data into your favorite dashboard tool! Unlock instant data integration with Catchr's no-code feature – no IT team required!
Start your free trial!

All your marketing data on Google Sheets

Build Google Sheets dashboard with your different marketing data and track all the essential KPIs.

Start your free trial!
Keep an eye on your data

Connect your Shopify data to Google Sheets thanks to Catchr's no code connector!

Start your free trial!
Need a clearer view of your marketing data?
Unlock your free Looker Studio dashboard template for from a collection of +50 stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?
Unlock your free Power BI dashboard template from a collection of stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?
No items found.
No items found.
Need a clearer view of your marketing data?

Unlock your free Template Shopify Overview dashboard template for Looker Studio from a collection of +50 stunning designs. Elevate your data visualization!

Get it for free

Bonus : Your free Template Shopify Overview Template

In this Shopify template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this Shopify template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Shopify