🛍️ BFCM Sale is live! Save up to 21% on annual plans Ends in 15d:10h:30m:36s Grab the Deal →

Shopify reports in Google Sheets, kept up to date

Ready-made reports, custom ShopifyQL, auto refresh

Run Shopify's built-in analytics reports and send the results straight to Google Sheets. Use the report library, customize any report or write your own ShopifyQL, and keep every report tab refreshed.

  • ★★★★★ 4.9/5 on Shopify App Store
  • Built for Shopify
  • Free plan up to 500 SKUs
  • GDPR compliant
ReportsSales, inventory, profit, behavior and more
CustomizeEdit any report or write ShopifyQL
RefreshHourly, daily or weekly on paid plans

How do you export Shopify reports to Google Sheets?

In your Shopify admin, open FlexSync → Analytics, pick a report from the library, choose a date range and click Run now. FlexSync writes the results to their own tab in your Google Sheet. On paid plans, turn on automatic refresh to update report tabs hourly, daily or weekly.

Is this you?

Made for merchants who report from spreadsheets

Whether you

  • Download Shopify sales or inventory reports and paste them into a spreadsheet
  • Build weekly reports for your team, investors or accountant by hand
  • Need a report Shopify's dashboard doesn't show the way you want
  • Want report numbers next to your own formulas and charts

FlexSync lets you

  • Run ready-made Shopify reports straight into Google Sheets
  • Give every report its own tab in one Sheet
  • Customize any report or write your own ShopifyQL query
  • Refresh report tabs hourly, daily or weekly on paid plans
Report library

Run a Shopify report in a few clicks

Browse ready-made Shopify reports by category, search by name, pick a date range and click Run now. When it finishes, FlexSync tells you which tab it wrote to.

  • Sales, inventory, profit and behavior reports
  • Compare with an earlier period
  • Written straight to your Google Sheet
FlexSync › Analytics
Search reportsAll categories
Total sales breakdownSales
Inventory reportsInventory
Profit reportsProfit
Behavior reportsBehavior
Run now · Last 365 days
One tab per report

Every report lands in its own Google Sheets tab

Each report is written to a tab named after it, next to your products and orders. Build charts, pivot tables and formulas on top of the numbers you already trust.

  • Report tabs sit next to your other FlexSync data
  • Use Sheets charts and formulas on the results
  • Share one Sheet with your team or accountant
Total sales breakdown · FlexSync Written
MonthOrdersGross salesDiscountsReturnsNet sales
22026-08412$38,920-$2,140-$1,310$35,470
32026-09455$42,615-$2,480-$1,190$38,945
42026-10498$47,280-$3,020-$1,560$42,700
52026-11521$49,930-$3,410-$1,480$45,040
ProductsOrdersTotal sales breakdownMy sales by product
Custom reports

Write your own report with ShopifyQL

Every Shopify report can be edited. Saving creates your own copy and leaves the original untouched. Click New report to write a ShopifyQL query from scratch, then turn on auto refresh to keep it current.

  • Save as new to keep your version
  • Write ShopifyQL from scratch with New report
  • Refresh hourly, daily or weekly on paid plans
-- Save as new to keep your own copy FROM sales SHOW net_sales, orders GROUP BY product_title SINCE -90d UNTIL today ORDER BY net_sales DESC LIMIT 25
Refresh my report tabs automatically
Auto refresh
Total sales breakdownHourlyDailyWeekly
My sales by productHourlyDailyWeekly
TimezoneStore timezone

Names and figures in the examples are illustrative.

How it works

Export your first report in six steps

From the report library to a Google Sheets tab that keeps itself up to date.

1

Open Analytics

In your Shopify admin, open FlexSync → Analytics to see the report library.

2

Find a report

Search reports, or narrow the list with Created by and All categories.

3

Choose a date range

Open a report, such as Total sales breakdown, pick a range and optionally compare with an earlier period.

4

Run it

Click Run now. FlexSync writes the results to a tab named after the report.

5

Customize or write your own

Edit any report and click Save as new, or click New report to write ShopifyQL.

6

Keep it updated

On paid plans, turn on Refresh my report tabs automatically and choose hourly, daily or weekly.

Real merchants · Real results

What merchants are saying

Rated 4.9 out of 5 on the Shopify App Store.

★★★★★
This is an excellent app doing exactly as expected. The support is very helpful and new feature requests were added with just a few weeks. I absolutely recommend this app to any stores who want to work in parallel in a Google Sheet like I do.
PPureTimeDenmark · Shopify App Store
★★★★★
Thanks for the support provided. Amazing app and great support team.
BBeauty WellnessUnited States · Shopify App Store
★★★★★
Great app to have a vision of all my inventory at once. Great support, I use it everyday and highly recommend.
TTOKAY UltimateFrance · Shopify App Store
Core Features

Who It’s For

Whether you report weekly, track stock or need numbers Shopify's dashboard doesn't show, Analytics fits the way you actually report.

#1

Weekly Sales Reporting

Best for:Sales reportsWeekly reviewGoogle Sheets

Run Total sales breakdown or any sales report and get the results in its own Google Sheets tab, ready for your weekly review.

Build My Sales Report
#2

Inventory Tracking

Best for:Inventory reportsStock levelsAuto refresh

Pull inventory reports from the report library into Google Sheets and keep them refreshed, so stock numbers are never a week old.

Track My Inventory
#3

Period-over-Period Comparison

Best for:Date rangesCompare periodsGrowth

Pick a date range and compare it with an earlier period before you run the report, so growth and drops are easy to spot.

Compare My Periods
#4

Custom ShopifyQL Reports

Best for:ShopifyQLCustom reportsSave as new

Edit any existing report or write a new ShopifyQL query from scratch, then save it as your own so the original stays untouched.

Write My Report
#5

Hands-Off Reporting

Best for:Auto refreshScheduled tabsPaid plans

Turn on automatic refresh and choose which report tabs update hourly, daily or weekly, so nobody has to re-run reports by hand.

Automate My Reports
#6

Teams Who Share Numbers

Best for:TeamPartnersAccountant

Keep every report in one Google Sheet you can share with your team, partners or accountant, next to your own charts and formulas.

Share My Reports
Questions

Frequently asked questions

Still have questions? Our support team is available 24/7 at support@flexsync.app.
How do I export Shopify reports to Google Sheets?

Open FlexSync → Analytics in your Shopify admin, choose a report, set a date range and click Run now. FlexSync writes the results to their own tab in your connected Google Sheet.

Which Shopify reports can I export?

FlexSync shows a library of ready-made Shopify reports grouped by category, including sales, inventory, profit and behavior. You can also edit any report or write your own with ShopifyQL.

Can I write custom reports with ShopifyQL?

Yes. Edit an existing report and click Save as new to keep your own copy, or click New report to write a ShopifyQL query from scratch.

Do report tabs update automatically?

On paid plans, yes. Turn on Refresh my report tabs automatically and choose which tabs refresh and how often: hourly, daily or weekly. Shopify doesn't notify apps when analytics change, so without refresh a tab keeps the data from its last run.

Is Analytics available on the Free plan?

Yes, with limits. On the Free plan a report writes up to 2 rows and you can keep 1 report tab, and automatic refresh needs a paid plan. Paid plans start at $9 a month.

Which timezone are report dates in?

Dates are read in your Shopify store's timezone.

Can I compare two periods?

Yes. When you choose a date range for a report, you can also compare it with an earlier period before you run it.

Bring your Shopify reports into one live spreadsheet

Save time and drive more sales with our Shopify to Google Sheets sync app