When booking completed in WP Travel Engine, create invoice in Google Sheets and send receipt via Email SMTP
When a WP Travel Engine booking is fully completed and paid, this workflow adds an invoice row to Google Sheets and then emails the traveller a receipt that you write, through WordPress mail or your SMTP server.
WP Travel Engine
Google Sheets
Email3 steps Setup ~5 min Used on 2.3k sites Free to import
What this workflow does
Tour operators running WP Travel Engine need two things after each paid booking: a record for the books and a receipt for the traveller. Doing both by hand for every trip takes time in busy seasons. This workflow handles both from the same booking.
The WP Travel Engine trigger fires when a booking process is fully completed, including payment. FlowMattic sends the booking details to Google Sheets, where the Add New Row step writes an invoice line with the values you map, such as trip, traveller and amount. The run then goes to the Email step, which sends the traveller a receipt using the WordPress mail function or a custom SMTP server.
The invoice here is a spreadsheet row, not a PDF or formatted document, and the receipt is the email text you write with booking values mapped in. Book a test trip after import and check both the sheet and the inbox before you rely on it.
Small tour company bookkeeping
Every paid booking adds an invoice line to a sheet your accountant reviews each month, while the traveller gets a receipt email.
Seasonal trip operators
During peak season, receipts go out for each completed booking without staff writing them, and the sheet keeps a running total.
Travel agents with several tours
Each booking row records which tour was sold, giving you a quick view of which trips sell best.
How this workflow runs
What happens at each step once the workflow is on, and what you need before you import it.
WP Travel Engine Booking CompletedFires when a WP Travel Engine booking is fully completed, including payment. The booking and traveller details are passed to the next two steps.
- Google Sheets Add New Row
Writes an invoice line for the booking to your Google Sheets spreadsheet. Connect your Google account and map booking values to columns such as trip, date and total.
Email Send EmailEmails a receipt to the traveller. Map the traveller's email as the recipient and build the message from booking details, sent through WordPress mail or custom SMTP.
What you need
- FlowMatticCore
- WP Travel Engine PluginPlugin
- Google Sheets AccountAccount
After importing, map your own data. To keep the template universal, not every step is pre-filled. Open each step in the builder and connect your accounts and fields (channels, lists, sheets, recipients) before you switch the workflow on.
Make it yours
Changes worth making after you import it.
- Add an invoice number column and fill it from the booking ID, if the trigger includes one, so each row and receipt can be matched.
- Send the receipts through a custom SMTP server on your business domain instead of the WordPress mail function.
- For tours sold in several currencies, add a Router between the WP Travel Engine trigger and the Google Sheets step, one route per currency, each with its own Sheets step. End the routes in a Join and keep the Email step after it, so each traveller gets one receipt.
Questions about this workflow
Does this workflow create a PDF invoice for WP Travel Engine bookings?
No. The invoice is a row in Google Sheets with the values you map. The receipt is an email whose text you write in the Email step.
Does a WP Travel Engine booking without payment start the workflow?
No. The Booking Completed trigger fires when the booking process is fully completed, including payment.
How does the receipt reach the right traveller?
Through the recipient you map. The Email step ships unmapped, so after a test booking you map the traveller's email from the WP Travel Engine data into it. Task History shows the booking values FlowMattic received, so you can pick the right one.
Do I need an SMTP service for the WP Travel Engine receipts?
No. The Email step can use the WordPress mail function. A custom SMTP server is optional if you want mail sent through your own provider.
More E-Commerce workflows
Other ready-to-import templates from the same category.
Import this workflow into your WordPress site
Download the JSON, import it from the Workflows screen and connect your accounts. Every run stays on your server, with no per-task fees.
30-day money-back guarantee Unlimited workflows and runs Self-hosted