DateLocationSales
04 MarOxford£1,240
11 MarCamden£1,680
18 MarOxford£1,510
Tabs: Sales · Stock · ProductsGive your AI tools the POS data
to answer your business questions.
Use ChatGPT, Claude or Gemini to explore your sales, stock and products. Flow makes your POS data available through Google Sheets and keeps it up to date, so you can ask questions using the AI tool you choose.
or
Google SheetsYour AI toolYour POS data. Your choice of AI.
Bring your business knowledge and your POS data into the AI tool you already use. Ask about sales trends, product performance or stock in plain language, then follow up on the answers.
Flow keeps your chosen POS data available through Google Sheets. You or your data team connect your AI tool, ask the questions and check the findings.
Understand changes in sales
Ask which products or locations contributed to a change between two trading periods.
Explore what is selling
Compare quantities and sales values to identify products worth a closer look.
Investigate stock patterns
Use stock and sales information to explore which products sell slowly or may need reordering.
Prepare a clearer team discussion
Ask for a summary, chart or follow-up questions, then check the findings before sharing them.
See how your POS data becomes a useful AI conversation.
Bring sales, stock and products into one spreadsheet. Then use your AI tool to explore the figures and check what they mean for your shops.
From retail data to better questionsCompare sales across your shops
See which locations changed
before you decide.
Bring sales, locations and categories into one place for a clearer comparison.
Which location grew most?Which category changed?What changed this period?
Flow keeps the POS data current. Your chosen AI tool helps you explore it.
01 / One spreadsheet
Give your AI tool the right context.
Keep related retail data in separate tabs within one Google Sheet.
Retail performance
SalesStockProducts
DateLocationProductSales
21 OctCentralCotton tee£24
SalesStockProducts
Sales history and product details stay together for your next question.
02 / Keep it current
New data arrives on a schedule.
Flow updates the tabs, so the next question starts with the latest available rows.
POSNew sale
FlowScheduled export
SheetsTabs updated
HourlyDailyWeekly
Choose the timing and reporting period that fit your business and plan.
03 / Ask in plain language
Compare the two periods.
Open your sheet in ChatGPT, Claude or Gemini, then ask.
Sales tabSales history · two periodsClothing · Central · £12k → £14.4k
→
Your questionCompare this periodwith the previous one
→
Your AI toolCentral · +20%
“Compare Clothing sales by location and show the biggest change.”
Flow supplies the rows. Your AI tool creates the analysis when you ask.
04 / Check the result
See which locations grew.
Check the figures against your sheet, then decide what to explore next.
AI answerSales by location
Central£14,400+20%
Riverside£10,800+8%
✓ Dates checked: 01–21 Oct vs previous period
Use the findings to guide your next stock or sales decision.
Your next question starts here
See the change.
Plan your next move.
Compare sales across your shops using the data Flow keeps ready.
POS→Flow→Google Sheets→Your AI tool
Turn your sales history into clearer questions and better-informed decisions.
Your POS → Flow → Google Sheets → Your AI tool01 / 06
0:00 / 0:54
The question. Animation paused.
Start with the question, then choose the data.
Use any template to send the POS data behind your questions to Google Sheets. Put sales, stock and product data in separate tabs within one spreadsheet, so your AI tool has one spreadsheet to work with.
Sales & items sold
Compare trading periods, products and locations, with the detail behind each sale.
Products & catalogue
Review your range, prices, categories and available product attributes.
Stock & inventory
Explore stock availability by product and location to support purchasing decisions.
Customers
Use customer information and their purchases in your reports, where available.
Staff, payment methods & more
Include information such as who made a sale or how it was paid for, where your POS provides it.
These are starting points, not a fixed list. Available data types, fields and relationships vary by platform.
Connect your data once. Keep asking questions.
1. Send your POS data to Google Sheets
Choose templates for the data you need. Send sales, stock or products to separate tabs within the same Google spreadsheet. Test the exports, then schedule Flow to keep them up to date.
2. Connect your AI tool
Give your AI tool access to that spreadsheet using its supported connection. For example, connect Google Drive in ChatGPT, use Claude in Google Sheets, or use Gemini in Sheets.
3. Ask questions as your data updates
Ask about sales, products or stock, and follow up on the answers. Flow keeps updating the data on schedule. Check the latest reporting dates and the figures your AI tool uses.
Flow keeps the data up to date on your chosen schedule, for example hourly or daily sales. Your AI tool handles the analysis. Connection options and access depend on the tool and your account.
What would you ask your data?
Ask your AI tool a business question and say which period to use. For example:
“Compare sales by location for the last two complete months. Show the change and the rows you used.”
“Which products account for the biggest change in units sold? Separate the numbers from possible explanations.”
“Summarise this stock and sales data for our next buying meeting. What should we investigate?”
Questions about this solution
Yes. Flow sends your Epos Now or Lightspeed data to Google Sheets. Use connected Google Drive in ChatGPT, Claude in Google Sheets, or Gemini in Sheets to work with that data. Features and access depend on your AI account. You choose the tool and check its answers.
Yes. Set each export to a different tab within the same Google spreadsheet, such as Sales, Stock and Products. Your AI tool can then work with one spreadsheet. Check that it can read the tabs needed for your question.
Schedule each Flow export to update its tab, for example hourly or daily sales. Choose the timing and reporting period for each export. When you ask your AI tool a question, check that it is using the latest data available in the spreadsheet.
Choose which sales, products or other information to include, and which columns appear in your report. The choices depend on your POS and the information you are working with. The guides below show what is available for Epos Now and Lightspeed.
Flow sends your selected Epos Now or Lightspeed Retail X-Series & R-Series data to Google Sheets. In ChatGPT, you connect Google Drive, choose the sheet and ask questions about the data available there.
No. Use any template for the data you need and set Google Sheets as its export destination. Your AI tool uses that spreadsheet through its supported connection.
You can ask about changes in sales, products or locations, compare quantities and sales values, or explore stock patterns. Choose the data and period needed for the question before asking your AI tool to analyse it.
Flow keeps your POS data available in Google Sheets. Your chosen AI tool analyses it when you ask questions. Check the results against your business records.
You need to connect Google Drive in ChatGPT using an account that can access the sheet, then choose your spreadsheet. Availability depends on your ChatGPT account and workspace settings.
Check the sheet’s latest dates and values before asking a question, state the period you want to compare and verify the result against the figures in your spreadsheet before sharing it with your team.
Ready to get started?
Choose the data your next report or analysis needs, then have it sent automatically.
Need a hand with setup?
Tell us what you want to achieve. We can help you choose the data and check your first run.