Skip to main content

Import Bookings to Google Sheet

In this tutorial, you will learn how to import your Bookla bookings into a Google Sheet using the Bookla API.
You will learn how to create an API key, connect it to Google Sheets, and automatically retrieve booking data for your selected time period.

How to do it:​

Step 1. Create an API key in Bookla​

  1. Go to your Bookla platform account.
  2. Open the "Developers" section.
  3. Click the "+ Create API key" button.
  4. Enter an API key name.
  5. Assign the following permissions to the API key:
    • Company: view
    • Service: view
    • Resource: view
    • Client: view
    • Bookings: view
  6. Click "Create".

⚠️ Important: The API key will be shown only once after creation. Make sure to copy and save it securely. You will not be able to view it again later. If you lose the key, you will need to create a new one.

Step 2. Set up Google Sheets​

  1. Open a new Google Sheet.
  2. Go to Extensions → Apps Script.
  3. Paste the code from this link: https://gist.github.com/chili-ios/ff1105f725141a11a4da086a4a5346e8
  4. Save the script.
  1. In the first row, enter the following formula: =BOOKINGS_TABLE("COMPANY_ID", "2026-03-01","2026-03-31", "API_KEY")

Replace:

  • COMPANY_ID with your Bookla company ID
  • "2026-03-01","2026-03-31" with your desired period
  • API_KEY with the API key you created

Result​

Once everything is set up, your Google Sheet will automatically display your Bookla booking data for the selected date range.

That’s it, your integration is complete and everything is set up successfully.