Home · Business tools · A live shop sales board: Shopify Flow to Google Sheets to Looker Studio on the TV

Recipe 10 min

A live shop sales board: Shopify Flow to Google Sheets to Looker Studio on the TV

Watch the day's orders land. Shopify Flow adds each order to a Google Sheet and Looker Studio shows it on a screen, with no exports.

Updated 17 Oct 2026

Save

The prompt · ChatGPT

Open in ChatGPT Open in Claude

Design a live sales board for my Shopify shop.

What I want on the board: [e.g. orders today, sales today vs same day last week, top products, average order]
Products or collections to watch: [list]
Where it will show: [e.g. shop TV, office screen]

Ask me up to 3 short questions first if anything important is missing. Wait for my answers.

Then:
1. The columns Shopify Flow should add for each new order, each with the Flow variable it comes from.
2. A Google Sheet layout: a raw orders tab and a summary tab with formulas.
3. Looker Studio calculated fields and up to six tiles, readable from a distance.
4. A 'data as of' tile.

The board is only as fresh as the last export or refresh, so show the 'data as of' date and time on the board. Looker Studio's own report auto-refresh is documented for Looker Studio Pro, so on the free version the screen needs reloading to show new data. Use only what I've given you, leave blanks for any price or fact I haven't given, and don't invent anything. UK English.

Stay in this ChatGPT chat. Do not turn on apps or connectors, and do not use memory from another chat.

What you get (sample answer)

Flow row columns: order_id, created_at, total_price, product_title, quantity, customer_city.
Sheet: raw Orders tab + Summary with COUNT/SUM by day.
Looker tiles: Orders today | Sales today vs same weekday | Top 5 products | AOV | Data as of.
On free Looker Studio, reload the tab to refresh; Sheets data freshness default 15 minutes.

Install Shopify Flow from the Shopify App Store (free on Basic, Grow, Advanced and Plus). No Flow? Export orders from Shopify as a CSV and paste them into the raw orders tab; the board is then only as fresh as that…

Paste the prompt above into any assistant and get the column list.

In Flow, create a workflow: trigger Order created, action Add row to spreadsheet (Google Sheets), using the columns.

Place a test order and check the row arrives.

In Looker Studio (free with a Google account), connect the Sheet. Data freshness is 15 minutes by default and can be 1, 4 or 12 hours.

Build the tiles and open the report full screen on the TV.

Setting it up takes about 1 to 2 hours.

GkGrok ClClaude ChChatGPT GeGemini CoCopilot

What happens

You only see how the shop's doing when you open the admin, and the team never sees sales at all.

Tools

Follow the steps: pull from the business tool, run the prompt, use the output.

ChatGPT — required. Works with the business tool named on this recipe. You stay in control of what gets sent.

Full build sheet

The prompt and the outline are on this page. Setup, settings, and the rest of the build sheet need a free account.

Free during launch. There is no charge and no monthly limit.

Create a free account

Loading the outline…