Tour operators running WP Travel Engine often reconcile bookings and deposits in a spreadsheet. FlowMattic fills that sheet from your site: completed bookings with a receipt email, balance payments, failed payments, enquiries and reviews, plus a monthly booking report. A sheet of promo codes can also create the coupons on your site.
15 triggers42 actions7 example workflows2 ready-made templatesUnlimited runs
Try a pairing
When this happens in WP Travel Engine9 triggers
Do this in Google Sheets19 actions
1. TriggerBooking Completed
2. ActionAdd New Row
When WP Travel Engine fires Booking Completed, 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
WP Travel Engine and Google Sheets workflows you can build
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 template
Log completed bookings and email the receipt
Paid bookings land in the bookings sheet with trip, dates, travellers and amount, and the traveller gets a receipt by email from the same workflow.
Mark the balance as paid when the due payment arrives
Deposit-based trips get a second payment later. The workflow finds the booking's row and fills the balance-paid column, so finance sees who still owes.
Due Payment Completed→Lookup Row Data→Update Row
Keep a follow-up list of failed payments
Every failed attempt is written to a separate tab with the traveller and trip, so someone can contact them before the seat is given away.
Payment Failed→Add New Row
Collect trip enquiries in a sales sheet
Enquiries arrive with the trip, travel dates and group size, so sales can work through them by date and mark each one answered.
Enquiry Created→Add New Row
Create coupons from a promo codes sheet
Marketing adds a code, discount and expiry to a row, and the coupon is created on the site, so campaigns are set up without wp-admin access.
New Spreadsheet Row→Create Coupon
Gather new reviews for testimonials
Each review with its rating goes to a sheet the marketing team uses to pick quotes for brochures and trip pages.
Review Created→Filter→Add New Row
Set up: completed bookings as rows
Once finished, each completed booking adds a row to your bookings sheet and sends the traveller a receipt.
1
Prepare the sheet
Create a bookings sheet with columns such as Booking ID, Trip, Departure, Travellers, Customer, Email, Total and Paid.
2
Connect Google Sheets
Under Connects in FlowMattic, add a Google Sheets connection with an account that can edit the sheet. WP Travel Engine runs on the same site, so it needs no connection.
3
Start with Booking Completed
Create a workflow with the WP Travel Engine Booking Completed trigger and make a test booking so FlowMattic captures the booking fields.
4
Add the row and receipt
Add Google Sheets Add New Row and map the fields, then an Email step with the traveller's email and booking details. Test and switch it on.
Log completed bookings and email the receiptTemplate
1. Trigger in WP Travel Engine
Booking Completed
2. Action in Google Sheets
Add New Row
Fields mapped from the earlier steps (a typical setup)
From WP Travel Engine
To Google Sheets
Booking ID
Booking ID
Trip name
Trip
Trip date
Departure
Number of travellers
Travellers
Billing name
Customer
Billing email
Email
Total cost
Total
Paid amount
Paid
3. FlowMattic tool
Email (SMTP)
Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.
Triggers and actions in this pair
A trigger starts a workflow. An action is something FlowMattic does in the app as a step.
Good to know
Booking Created fires when the booking is made, before payment. Use Booking Completed for a ledger of paid bookings, or Booking Updated to follow status changes.
Keep the Booking ID in the sheet. Lookup Row Data needs it to find the right row when a due payment or status change arrives later.
A sheet row that creates a coupon runs once per new row. Fix a wrong code with Update Coupon in a separate workflow rather than adding the row again.
New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet
Actions (19)
Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library
Why run this pair with FlowMattic
WP Travel Engine and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.
Traveller data stays with you
Traveller names, contact details and payments move from your WordPress site to your sheet directly, without another automation service in the path.
Peak season costs the same
Runs are unlimited, so a summer with hundreds of bookings a week logs every one of them on the plan you already have.
The sheet can set up promotions
Because WP Travel Engine has actions here, the same spreadsheet that holds bookings can also create coupons and trip enquiries on your site.
Common questions
How do I export WP Travel Engine bookings to Google Sheets?
For new bookings, use the Booking Completed trigger with Google Sheets Add New Row. For bookings made before the workflow existed, run List All Bookings once, loop over the results with Iterator and add each as a row.
Can I log enquiries separately from bookings?
Yes. Build a second workflow with Enquiry Created that writes to an enquiries tab, so bookings and leads are not mixed in one list.
Can I track deposits and balances?
Yes. Log the paid amount with Booking Completed, then use Due Payment Completed to find the row by Booking ID and update the balance column.
Can the sheet update a booking's status?
Yes. An Update Specific Column Value trigger on a Status column can run Update Booking Status, so marking a row as confirmed updates the booking on your site.
Does traveller information come through?
Traveller Info Saved fires when a customer submits their traveller details at checkout, so you can write those to a passenger list tab for guides.
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. WP Travel Engine integration 1.0.0, Google Sheets integration 2.2.4.