Connect Google Sheets and WP Travel Engine

Use Google Sheets and WP Travel Engine in the same FlowMattic workflow. Below are the triggers and actions both integrations offer; pick one of each to see how the two connect.

Try FlowMattic free See triggers and actions

15 triggers 42 actions 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Google Sheets6 triggers

Do this in WP Travel Engine23 actions

1. TriggerNew Spreadsheet Row

2. ActionList All Trips

When Google Sheets fires New Spreadsheet Row, FlowMattic runs List All Trips in WP Travel Engine with the data from that event.

You build this in the FlowMattic workflow builder on your own site.

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

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

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