Integrate Bookinglayer Data In Google Sheets With Custom Apps Script Connector

Bookinglayer is an advanced booking engine for travel-, hospitality-, and activity bookings. This connector enables you to sync data from Bookinglayer to Google Sheets with a few clicks. That means you can now use the features and integrations of Google Sheets to perform analysis and coordinate further downstream integrations like Looker Studio, CDPs, or CRMs.

How it works

The connector is built on the Bookinglayer REST API. It uses Google Apps Script to query the API, parses and flattens the response, and pastes the data in a Google Sheet. The configuration and data fetch trigger are handled right within the Sheet.

Instructions

• Make a copy of the Google Sheets file
• Insert your API token in cell B3 of the Config tab
• Click Get Bookinglayer Data in the Sheets menu and wait for the import to finish

You will need to grant the script the right level of authorization. Note that this first version of the connector will always fetch all people and all bookings. Depending on the amount of people and bookings, allow some time for the script to run.

This first iteration of the connector is very basic and triggered manually. There is tons of potential for customizations and additional features. Please get in touch if you have feedback or if you’d like to see specific additions — such as scheduled automated executions, additional API endpoints, filter options, other parameters etc.

The Apps Script code is available on Github as well.

— If you have questions, feedback, or want so say hi: Feel free to reach out —