Integration with Google Sheets

Connect Shopify and Google Sheets to keep data synced across your spreadsheets.

How does Shopify Sheets Connector work?

The Mipler Shopify Data Connector adds a new =MQL(...) function to Google Sheets, allowing you to add any data to your tables.
And what's very important - all data is automatically updated.

shopify google sheet integration shopify google sheet integration

Ready-to-use Google Sheets templates for Shopify

Sales Dashboard

The simple template illustrates how to add basic metrics to sheets and use on-the-fly filters.

Sales Dashboard
Recent Order List

The template contains a list of recent orders (updates automatically) for the last 30 days. By default, we have included only common columns, but it can easily be extended with any column that you need, additional filters, sorters, and so on.

Recent Order List
YOY Comparison + YTD stats

Effortlessly track year-over-year comparisons and year-to-date statistics with precision using our YOY Comparison + YTD Stats feature. Gain valuable insights and make informed decisions based on comprehensive data analysis at your fingertips.

YOY Comparison + YTD stats
Inventory Planner

Optimize your Shopify store's inventory management with our meticulously crafted Google Sheets template designed for efficient and strategic inventory planning.

Inventory Planner

A simple formula yields immediate results

Here's an example of how you can load data into your Shopify store with a single formula.

=MQL(...)
DESCRIPTION: MQL functions provide access to Shopify data through Advanced Query Language (QL) Syntax.
SYNTAX:
=MQL(Expression, [arg1], [arg2], ...)
EXAMPLES:
=MQL("orders.count")

Return the overall number of orders.

=MQL("calculate(orders.count, is_in_range(orders.processed_at, LAST30DAYS))")

Return the number of orders placed within the last 30 days.

=MQL("summarize_columns([orders.processed_at, orders.name, orders.amount])")

Return a simple list of orders with 3 columns.

Ready to get started?

Join Mipler now and benefit from meaningful reports today