Keep a Google Sheet that always matches your FlowMattic Bookings calendar. New bookings become rows, reschedules, cancellations and no-shows update the row they belong to, and a status column in the sheet can cancel or add bookings. Useful for teams that report, invoice or plan staff from a spreadsheet.
17 triggers 37 actions 7 example workflows 2 ready-made templates Unlimited runs
When this happens in Bookings11 triggers
Do this in Google Sheets19 actions
1. TriggerNew Booking2. ActionAdd New RowWhen Bookings fires New Booking, 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 templateThe sheet becomes the running record of who booked which calendar and when, ready for weekly reports or a shared view for staff who never open wp-admin.
New BookingAdd New Row
View the template Look the booking up by its ID and write the new time into the same row, so the sheet never shows two entries for one appointment.
Booking RescheduledLookup Row DataUpdate Row
Setting the status column to cancelled keeps the history. You can still count cancellations per calendar each month and see which slots opened up.
Booking CancelledLookup Row DataUpdate Row
Clinics and consultants who charge for missed sessions get one tab of no-shows with name, email and date, which is the list they work from when following up.
Booking Marked No-ShowAdd New Row
Office staff plan sessions in a sheet they already use. Each new row creates the booking on the chosen calendar, and the booking ID is written back to the row.
New Spreadsheet RowAdd BookingUpdate Row
When someone types cancel in the status column, a Filter checks the value and the workflow cancels the booking with the ID stored in that row.
Update Specific Column ValueFilterCancel Booking
A Schedule finds the coming week's bookings, an Iterator walks the list and each one is added to a new sheet, so the rota for next week is ready before Monday.
ScheduleFind BookingsCreate New SheetIteratorAdd New Row
At the end, each booking made on the calendar you choose is written to your sheet as one row.
Create a sheet with a header row such as Booking ID, Name, Email, Calendar, Start and Status, so every field has a column to map to.
Under Connects, add a Google Sheets connection with an account that can edit that spreadsheet.
Create a workflow with the Bookings New Booking trigger, pick the calendar and make a test booking so FlowMattic captures its fields.
Add Google Sheets Add New Row, choose the spreadsheet and sheet, map the booking fields to the columns, test the step and switch the workflow on.
1. Trigger in Bookings
New Booking
2. Action in Google Sheets
Add New Row
Fields mapped from the earlier steps (a typical setup)
| From Bookings | To Google Sheets |
|---|---|
| Booking ID | Booking ID |
| Attendee name | Name |
| Attendee email | |
| Calendar name | Calendar |
| Start time | Start |
| Booking status | Status |
A trigger starts a workflow. An action is something FlowMattic does in the app as a step.
Bookings and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.
Reschedules and cancellations update the original row, so the sheet can be trusted for staff planning and monthly counts.
Bookings live in your WordPress database and FlowMattic runs there too, so attendee details only leave your server for the Google sheet you chose.
Runs are unlimited on every plan, so a calendar with hundreds of sessions a week needs no bigger plan than one with five.
Start a workflow with the New Booking trigger, pick your calendar and add a Google Sheets Add New Row step. Map the attendee, calendar and time fields to columns, test with one booking and switch it on.
Yes. Point each calendar's workflow at the same spreadsheet and write the calendar name in its own column. If you would rather keep them apart, a Router can send each calendar's bookings to its own tab.
Not if you use Booking Rescheduled with Lookup Row Data and Update Row. The lookup finds the row by booking ID and the update writes the new time into it.
Yes. Use New Spreadsheet Row as the trigger and the Bookings Add Booking action. Each row needs the calendar, the attendee's name and email, and a start time the calendar can accept.
Yes. Run a workflow once with Find Bookings for the date range you want, loop over the results with Iterator and add each booking as a row.
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. Bookings integration 1.0, Google Sheets integration 2.2.4.
