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.
Lightspeed
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.
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 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.