Epos Now runs the till, the table bookings and the customer list for shops and hospitality venues. Google Sheets is where owners and managers often total the day or plan the next shift. FlowMattic copies each sale, booking, new customer and rating into a sheet from your own WordPress site, so the numbers are there without logging in to the back office.
11 triggers 19 actions 6 example workflows 2 ready-made templates Unlimited runs
When this happens in Epos Now5 triggers
Do this in Google Sheets19 actions
1. TriggerNew Transaction2. ActionAdd New RowWhen Epos Now fires New Transaction, FlowMattic runs Add New Row in Google Sheets with the data from that event.
You build this in the FlowMattic workflow builder on your own site. See the setup steps
Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.
Ready-made templateEvery sale becomes a row with its total, payment method and time, so the owner can check takings from a phone and the bookkeeper has a running record.
New TransactionAdd New Row
View the template Date/Time Formatter turns the transaction time into a day name or date, written in its own column, so a pivot table shows takings per day of the week.
New TransactionDate/Time FormatterAdd New Row
A Filter lets only low ratings through. They go onto a Follow-up tab and Email (SMTP) tells the manager, who can contact the customer while the visit is fresh.
New Customer RatingFilterAdd New RowEmail (SMTP)
Each new booking is written with a readable date, time and party size, so staff planning the floor work from a shared sheet instead of one till screen.
New BookingDate/Time FormatterAdd New Row
New customers added at the till are copied into a sheet with names tidied by Text Formatter, ready for a mail merge or a birthday offer.
New CustomerText FormatterAdd New Row
A product register in the sheet lists each item with its price and category on the day it was created, which helps when several people manage the menu or stock.
New ProductAdd New Row
At the end, each transaction rung through Epos Now is added as a row to your sales sheet.
Add headers such as Transaction ID, Date, Total, Payment method, Staff and Location.
Under Connects, add your Epos Now account and a Google account allowed to edit the sales sheet.
Create a workflow with the Epos Now New Transaction trigger and ring through a test sale so its fields are captured.
Add Google Sheets Add New Row, map the transaction fields to the headers, test it and switch the workflow on.
1. Trigger in Epos Now
New Transaction
2. Action in Google Sheets
Add New Row
Fields mapped from the earlier steps (a typical setup)
| From Epos Now | To Google Sheets |
|---|---|
| Transaction ID | Transaction ID |
| Date and time | Date |
| Total | Total |
| Tender type | Payment method |
| Staff member | Staff |
| Device or location | Location |
A trigger starts a workflow. An action is something FlowMattic does in the app as a step.
Epos Now and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.
Owners and area managers can check a shared sheet on any device without a back-office login for each person.
Runs are unlimited, so a venue that rings through hundreds of sales a day pays the same as a quiet one.
Transactions and customer details pass through your own WordPress site into your own sheet, not an outside automation service.
Yes. Each New Transaction adds a row, and a formatted date column lets a SUMIF or pivot table total each day. The sheet stays current as sales are rung through.
Yes. Add a Router after New Transaction that sends each sale to the tab for its location or device, or keep one tab with a location column.
Start a workflow on New Customer Rating, add a Filter for low scores, log them on a Follow-up tab and email the manager with Email (SMTP).
That depends on how they are rung through. Check a test refund: if it arrives as a New Transaction with a negative total, it is logged like any other sale.
Write the booking date in its own column and use a sheet filter or a FILTER formula on a second tab to show today's bookings for the floor team.
Did not find your answer? You can browse the help center or ask us directly.
Google Sheets and Slack149 shared templates
Google Sheets and AI Agents26 shared templates
Google Sheets and Fluent Forms23 shared templates
Google Sheets and WooCommerce20 shared templates
Google Sheets and FluentCRM19 shared templates
Google Sheets and WPForms12 shared templates
Google Sheets and ActiveCampaign11 shared templates
Google Sheets and Gmail11 shared templatesInstall FlowMattic, connect both accounts and import a template. Every run stays on your own server.
30-day money-back guarantee Unlimited workflows and runs Self-hosted
Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Epos Now integration 1.0.0, Google Sheets integration 2.2.4.
