Shopify Reporting
Shopify → Google Sheets Integration
Your Shopify orders as a live Google Sheet — online store and POS together, every variant and discount code — with no automations to build and maintain, whichever plan you are on.
Shopify Reporting
Your Shopify orders as a live Google Sheet — online store and POS together, every variant and discount code — with no automations to build and maintain, whichever plan you are on.
Shopify’s reports answer Shopify’s questions. As soon as you want the numbers in your own shape — a monthly VAT tab, product-level margins, a sheet your accountant or warehouse can read — you are exporting CSVs, or wiring up automations that quietly break the first time an order does not fit the mould.
This integration keeps one Google Sheet in step with your store. Orders from every sales channel arrive on their own — your online store, Shopify POS and anywhere else Shopify records a sale — with variants, discount codes, shipping, tax and refunds carried across.
We create an app used only by your store and send you an install link. It is not listed in the Shopify App Store and is never shared with another store.
It asks to read your orders — not to edit products, change prices or touch your theme. You see exactly what it requests before you approve it.
Remove it from Settings → Apps and the connection ends immediately. The sheet, and everything in it, stays yours.
£6.99 per month after a free first month. That covers the integration, ongoing updates and support — no per-order fees, and no need to move to a bigger Shopify plan.
Shopify gives apps the last 60 days of orders by default. Full order history needs an extra permission from Shopify, which we request at setup. If it is approved, we import as far back as you want; if not, the sheet starts 60 days back and captures every order from then on.
Yes. In-person sales through Shopify POS are orders like any other, so they arrive in the same sheet with the sales channel recorded — handy for comparing shop takings with online.
Yes. It reads orders through Shopify’s standard Admin API, which every plan has, so it does not depend on which reports your plan includes.
The defaults cover what most stores need:
Tell us at setup if you want something different and we will shape the sheet around it.
Each order records the currency your customer actually paid in, alongside your store currency where the two differ, so international sales stay honest. Nothing is silently converted.
A refunded order is reflected in the sheet rather than left showing as full revenue. Partial refunds show the amount actually refunded, so your totals match what you kept.
Read access to your orders, approved by the store owner when installing your private app — and edit access to the single Google Sheet you nominate, nothing else in your Drive. No staff account, no password. Uninstalling the app ends the connection instantly.
Yes. We only ever write to the columns we own, so your own columns, extra tabs, charts and pivot tables keep working as new orders arrive.
Nothing breaks. Orders are tracked by their Shopify order ID rather than by row position, so sorting, filtering or deleting rows never causes an order to be written twice. If you delete one you wanted, ask and we will re-add it.
You can cancel any time with 30 days' notice. The sync carries on during the notice period and then stops. The sheet stays yours, with everything already in it.
A UK-based development company — Receptive Ltd — with offices in Cardiff and Cheltenham. We build Shopify integrations and connect Shopify stores to Claude, among other things.
Several stores, Shopify Plus, or a feed for your warehouse — tell us what you need and we’ll quote it.
Contact Us
