tr Skip to content
Black Friday FlowMattic for life, 12 payments of $33.25 Or $399 once. Nothing added for splitting Ends in --Days --Hrs --Min --Sec See the deal

Connect WP Travel Engine and Google Sheets

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 triggers 42 actions 7 example workflows 2 ready-made templates Unlimited 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.

WP Travel Engine app icon Google Sheets app icon 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.

Booking CompletedAdd New RowEmail (SMTP)

View the template
WP Travel Engine app icon Google Sheets app icon Ready-made template

Build a monthly booking report

Once a month a Schedule lists the bookings and adds one row per booking to a new report tab, ready for revenue totals per trip.

ScheduleList All BookingsIteratorAdd New Row

View the template
WP Travel Engine app icon Google Sheets app icon

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 CompletedLookup Row DataUpdate Row

WP Travel Engine app icon Google Sheets app icon

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 FailedAdd New Row

WP Travel Engine app icon Google Sheets app icon

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 CreatedAdd New Row

WP Travel Engine app icon Google Sheets app icon

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 RowCreate Coupon

WP Travel Engine app icon Google Sheets app icon

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

Import the ready-made template Intermediate, about 5 min to set up
Log completed bookings and email the receipt Template
  1. WP Travel Engine app icon 1. Trigger in WP Travel Engine Booking Completed
  2. Google Sheets app icon 2. Action in Google Sheets Add New Row

    Fields mapped from the earlier steps (a typical setup)

    From WP Travel EngineTo Google Sheets
    Booking IDBooking ID
    Trip nameTrip
    Trip dateDeparture
    Number of travellersTravellers
    Billing nameCustomer
    Billing emailEmail
    Total costTotal
    Paid amountPaid
  3. 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.
WP Travel Engine app icon

WP Travel Engine

Integration page

Triggers (9)

  • Booking CreatedTriggers when a new booking is created
  • Booking CompletedTriggers when a booking process is fully completed including payment
  • Booking UpdatedTriggers when an existing booking is updated or its status changes
  • Payment CompletedTriggers when a payment is marked as completed
  • Due Payment CompletedTriggers when a remaining or due payment is processed for a booking
  • Enquiry CreatedTriggers when a new trip enquiry is submitted
  • Review CreatedTriggers when a new trip review or rating is submitted
  • Payment FailedTriggers when a payment attempt fails for a booking
  • Traveller Info SavedTriggers when a customer submits their traveller information during checkout

Actions (23)

  • List All TripsRetrieve a list of published trips with optional filters
  • Retrieve a TripRetrieve a single trip by its ID with full details
  • Retrieve Trip PackagesRetrieve all packages for a specific trip including pricing
  • Retrieve Trip DatesRetrieve available departure dates for a specific trip
  • Create TripCreate a new trip post
  • Update TripUpdate an existing trip\'s details or settings
  • List All BookingsRetrieve a list of bookings with optional status filter
  • Retrieve a BookingRetrieve a single booking by its ID with full details
  • Update Booking StatusUpdate the status of a booking record
  • List All CustomersRetrieve a list of customers
  • Retrieve a CustomerRetrieve a single customer by their ID
  • List All PaymentsRetrieve a list of payments with optional status filter
  • Retrieve a PaymentRetrieve a single payment by its ID
  • Update Payment StatusUpdate the status of a payment record
  • Create EnquirySubmit a new trip enquiry
  • List All EnquiriesRetrieve a list of enquiries
  • Retrieve an EnquiryRetrieve a single enquiry by its ID
  • Delete EnquiryMove an enquiry to trash
  • List All CouponsRetrieve a list of all coupon codes
  • Retrieve a CouponRetrieve a single coupon by ID or code
  • Create CouponCreate a new coupon/discount code
  • Update CouponUpdate an existing coupon's settings
  • Delete CouponMove a coupon to trash
Google Sheets app icon

Google Sheets

Integration page

Triggers (6)

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

Did not find your answer? You can browse the help center or ask us directly.

Start automating WP Travel Engine and Google Sheets

Install 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. WP Travel Engine integration 1.0.0, Google Sheets integration 2.2.4.