How to Integrate Google Sheets with WP Travel?

Track all bookings instantly in Google Sheets for effortless management. By integrating WP Travel with Google Sheets, you can automatically log bookings, monitor payments, and organize trip data efficiently.

Step 1: Create a Google Project #

• Login/Register to the Google Cloud Console
• At the top, click Select a Project.

• Click New Project.

• Enter a Project Name and click Create.

• After creation, select your project from the notification bar or dropdown.

• Open the Navigation Menu

• Navigate to APIs & Services → Enabled APIs & Services.

Step 2: Enable Google Sheets API #

• In the Google Cloud Console, search for Google Sheets API.

• Select the API

• Click Enable.

Step 3: Create Credentials #

• Navigate to APIs & Services → Credentials.

• Click Create Credentials → Service Account.

• Enter the required details and click Create and Continue.

• Click Done.

Step 4: Generate Service Account Key #

• Under Service Accounts, click Edit for the account you just created.

• Go to the Keys tab and click Add Key.

• Click Create New Key.

• Select JSON as the key type and click Create.

• Download the credentials file and save it securely.

Step 5: Connect Google Sheets with WP Travel #

• Open Google Sheets and create a new sheet for adding bookings.

• Copy the Sheet ID from the URL (the long code between /d/ and /edit).
  Example:
  
  https://docs.google.com/spreadsheets/d/1AbCdEfGhIJKlmnopQrStUvWxYz1234567890/edit
  Sheet ID: 1AbCdEfGhIJKlmnopQrStUvWxYz1234567890

• Use the Sheet ID and JSON credentials (from Step 4) in your WP Travel plugin settings.

• Copy the Client Email from the JSON file.

• Add this Client Email to your Google Sheet’s Share Settings with Editor access.

Once connected, all WP Travel bookings will automatically sync to Google Sheets, enabling centralized tracking of your trips and bookings.

Step 6: Connect Enquiry Data (Optional) #

• Open another Google Sheet for enquiries.

• Copy the Sheet ID from the URL (the long code between /d/ and /edit).
  Example:
  
  https://docs.google.com/spreadsheets/d/1ARrFt_2bCAoxIF-44JjwIoxMCScLOYSAbf8IvmjIEZk/edit?gid=0#gid=0
  Sheet ID: 1ARrFt_2bCAoxIF-44JjwIoxMCScLOYSAbf8IvmjIEZk

• Use this Sheet ID in the WP Travel plugin settings.

• Copy the Client Email from the JSON file.

• Add the same Client Email to your Google Sheet’s Share Settings with Editor access.

Notes:

• If the travel date is empty, check the booking details to verify whether the user booked multiple trips.
• If the payment method is empty, it indicates the booking was made as Booking Only.