Weekly Sales Reporting
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 ReportRun 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.
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.
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.
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.
| Month | Orders | Gross sales | Discounts | Returns | Net sales | |
|---|---|---|---|---|---|---|
| 2 | 2026-08 | 412 | $38,920 | -$2,140 | -$1,310 | $35,470 |
| 3 | 2026-09 | 455 | $42,615 | -$2,480 | -$1,190 | $38,945 |
| 4 | 2026-10 | 498 | $47,280 | -$3,020 | -$1,560 | $42,700 |
| 5 | 2026-11 | 521 | $49,930 | -$3,410 | -$1,480 | $45,040 |
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 own copy
FROM sales
SHOW net_sales, orders
GROUP BY product_title
SINCE -90d UNTIL today
ORDER BY net_sales DESC
LIMIT 25Names and figures in the examples are illustrative.
From the report library to a Google Sheets tab that keeps itself up to date.
In your Shopify admin, open FlexSync → Analytics to see the report library.
Search reports, or narrow the list with Created by and All categories.
Open a report, such as Total sales breakdown, pick a range and optionally compare with an earlier period.
Click Run now. FlexSync writes the results to a tab named after the report.
Edit any report and click Save as new, or click New report to write ShopifyQL.
On paid plans, turn on Refresh my report tabs automatically and choose hourly, daily or weekly.
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.
Thanks for the support provided. Amazing app and great support team.
Great app to have a vision of all my inventory at once. Great support, I use it everyday and highly recommend.
Whether you report weekly, track stock or need numbers Shopify's dashboard doesn't show, Analytics fits the way you actually report.
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 ReportPull inventory reports from the report library into Google Sheets and keep them refreshed, so stock numbers are never a week old.
Track My InventoryPick 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 PeriodsEdit any existing report or write a new ShopifyQL query from scratch, then save it as your own so the original stays untouched.
Write My ReportTurn on automatic refresh and choose which report tabs update hourly, daily or weekly, so nobody has to re-run reports by hand.
Automate My ReportsKeep every report in one Google Sheet you can share with your team, partners or accountant, next to your own charts and formulas.
Share My ReportsOpen 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.
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.
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.
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.
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.
Dates are read in your Shopify store's timezone.
Yes. When you choose a date range for a report, you can also compare it with an earlier period before you run it.