Send your POS data into
Google Sheets automatically.
Flow sends your sales, stock, product or customer information to Google Sheets and keeps it up to date on your chosen schedule. Use it for everyday reports, connect a dashboard, or explore the numbers with AI.
or
Google SheetsBuild the reports your business needs.
Your next report does not have to stop at the reports built into your POS. Bring your sales, stock or customer information into a spreadsheet you can use to answer your own business questions.
Flow handles the repeated POS export. You or your data team use the Google Sheet to build reports, connect other tools and answer business questions.
Create your own spreadsheet reports
Use pivot tables, formulas and charts in Google Sheets to compare sales, review stock or answer the questions that matter to your business.
Explore your data with AI
Use ChatGPT, Claude or Gemini to ask questions about your numbers, explore changes and find areas to investigate.
Build dashboards your team can use
Use Power BI, Tableau or Looker Studio to turn the data in your sheet into dashboards for tracking sales, products and locations.
Your POS data, ready for the tools you use.
Flow keeps your Google Sheet up to date. Use that data in your spreadsheets, dashboards and AI analysis.
or
LightspeedSelect, combine& filterOn your schedule
Google Sheets
Flow updates the sheet on your chosen schedule. You or your data team set up the reporting and AI tools; availability and refresh settings depend on the tool and your account.
Building reports for your business or a client?
Let Flow handle the recurring export from Epos Now or Lightspeed. Choose the information and columns your client needs, then build their reports, dashboards or AI analysis around the Google Sheet.
See your data become a useful report.
Export your sales history, then let Flow add new rows on a schedule. Use Google Sheets, reporting tools or AI to compare periods and explore performance.
From POS data to better decisionsOne business. Multiple locations.
See what’s working.
Across your business.
Your locations. Your team. Your best-performing categories.
CentralClothing & footwear
Sale£24.00
RiversideClothing & footwear
Sale£65.00
Old TownClothing & footwear
Sale£48.00
Your sales history. Ready to explore in Google Sheets.
01 / Start with what you already have
The detail is in your POS.
Start with historical sales, then keep the data coming.
01
Sales
19 Oct · Sale #1042
£24.0002
Items sold
Sale #1042 · Product #218
1 item03
Products
#218 · Cotton tee
Clothing04
Locations & staff
Central · Alex
Your teamSales, products, stock, customers and more — depending on your POS.
02 / Bring the details together
One sale. The whole picture.
Flow connects each sale to the related details you choose.
Sale #1042 £24.00
Product Cotton teeCategory ClothingLocation CentralStaff Alex
Date19 OctLocationCentralStaffAlexCategoryClothingProductCotton teeSales£24.00
Product names, locations and staff, ready to read in the same row.
03 / Choose what Flow sends
Choose your sales data.
Select the history, locations and columns you want to send.
✓ From your chosen start date✓ Three locations✓ Product, staff & category
DateLocationStaffCategorySales
Before startCentralAlexClothing£32.00
19 OctCentralAlexClothing£24.00
19 OctRiversideSamFootwear£65.00
19 OctOther sitePatFootwear£75.00
Keep the report focused on the stores, dates and details you need.
04 / Watch it happen
From a till sale to a spreadsheet row.
Flow combines the details, keeps what you need and sends the rows to Sheets.
Fetch the sales and related records.Bring the product, category, location and staff together.Exclude rows before your chosen start date.Send the prepared row to Google Sheets.
05 / Let Flow handle the repeat work
History first. New sales next.
Export past sales once. Then append new rows on a schedule.
Run:HourlyDaily · shownWeeklyMonthly
POS sales historyHistorical rows stay in the sheet. Daily runs on 20 and 21 October add new sales below them.
| Date | Location | Staff | Category | Product | Sales |
|---|---|---|---|---|---|
| 19 Oct | Central | Alex | Clothing | Cotton tee | £24.00 |
| 19 Oct | Riverside | Sam | Footwear | Trainers | £65.00 |
| 20 Oct | Old Town | Jo | Clothing | Denim shirt | £48.00 |
| 21 Oct | Central | Alex | Footwear | Ankle boots | £85.00 |
POS data · Append modeMy reports
Existing rows stay in place. Each run adds its exported sales.
Choose a schedule that suits your Flow plan.
06 / Turn your data into answers
You can ask AI to help.
Ask your AI tool to analyse the sales history in your Google Sheet.
Use your preferred toolChatGPT · Claude · Gemini
You ask
“Using this sheet, compare sales by location, staff and category with the previous period. Create a chart and a pivot table.”
✓ Comparison chart✓ Pivot table✓ Changes to explore
Connect your sheet to your AI tool, explore the numbers and check the findings.
07 / Your analysis tools take over
Compare in Google Sheets.
Or use your reporting or AI tool to analyse the sales history.
Sales by location
£ thousandsPrevious periodThis period
Compare the detail
Pivot table| Category | Previous | Now | Change |
|---|---|---|---|
| Clothing | £18,000 | £20,700 | +15.0% |
| Footwear | £12,000 | £13,300 | +10.8% |
| Staff sales | Previous | Now | Change |
|---|---|---|---|
| Alex | £11,000 | £12,800 | +16.4% |
| Sam | £10,000 | £11,400 | +14.0% |
| Jo | £9,000 | £9,800 | +8.9% |
See which shops grew and which categories contributed to the change.
Your next report starts here
Less exporting.
More understanding.
Your sales history, kept up to date.
Ready for Sheets, reports and AI.
Your POS→→
→Build the reports that help you run your business.
POS data → Flow → Google Sheets → Your reports01 / 09
0:00 / 1:25
The question. Animation paused.
Bring the POS data you need into Google Sheets.
Start with any template for the data you need, such as sales, stock, products or customers. Choose which information to include, then set Google Sheets as the destination.
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.
Set it up once. Let Flow handle the repeat work.
1. Choose your POS data
Connect Epos Now or Lightspeed and choose a template for the data you need. Customise the information to include, such as sales or stock levels, and narrow it to the dates, locations or products you need where available.
2. Choose Google Sheets
Connect your Google account and choose the spreadsheet to update. Check where the information should appear in the sheet.
3. Test, then schedule
Run a sample export and check the rows in your sheet. Set a schedule that suits your report and Flow plan.
Choose a schedule and export settings that suit your report. The information available depends on whether you use Epos Now or Lightspeed.
Questions about this solution
Yes. Once Flow has sent the information to Google Sheets, you or your data team can connect the sheet to these reporting tools. Power BI and Looker Studio have Google Sheets connections; Tableau uses Google Drive. Set up the connection and refresh settings in the reporting tool.
Yes, using the route supported by your chosen tool: connected Google Drive in ChatGPT, Claude in Google Sheets, or Gemini in Google Sheets. Availability depends on your account and permissions. Flow supplies the spreadsheet; you choose the information to share, ask the questions and check the answers.
Yes. Your data team can choose the POS information, columns and schedule in Flow, then use the Google Sheet for your reports, dashboards or analysis. Flow handles the recurring POS export; your data team builds and maintains your reports.
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.
Yes. Flow can deliver data from Epos Now or Lightspeed Retail X-Series & R-Series to Google Sheets on a schedule. The information available depends on your POS and what it provides to Flow.
You can send sales and the items sold, product lists, stock levels or customer information. Choose the columns your report needs from the information available for your POS.
No. You can start with any template and set Google Sheets as the destination for its export. Choose the information you want to include, then select Google Sheets in the delivery settings.
In Flow, open Connections, choose Manage Google Sheets and select Connect Google. Sign in to Google and approve access. Then open your flow’s delivery settings, choose CSV and Upload to Google Sheets, and select your Google connection and spreadsheet. Run a sample to check the results before setting a schedule.
Yes. You can narrow the information in the report, for example to selected dates, locations or products where available. Check a sample in your spreadsheet before setting it to update automatically.
Flow sends the information you select to your spreadsheet. You or your data team build the formulas, charts and views in Google Sheets around the business question you need to answer.
Yes. Choose a Flow schedule that suits your report and plan. Test the first export in Google Sheets, then use the updated spreadsheet for your formulas, charts or reports.
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.