Integromat.com

From Booking Automation Wiki
Jump to: navigation, search
Integromat
This page is about the menu SETTINGS->APPS & INTEGRATIONS->INTEGROMAT and explains how to connect and what you can do with the connection.

To use this service you will need an account with Integromat.

For BookingAutomation the normal channel manger fees apply.

Capabilities

Within Integromat you can connect Booking Automation to third party Apps and services. Booking Automation will then send booking data to Integromat which will be passed on to the services you connected to.

Limitations

Set Up

Booking Automation

  • Set up an Auto Action (SETTINGS-GUEST MANAGEMENT-AUTO ACTIONS) which selects the bookings which will be sent to Integromat. Set "Trigger Action" = automatic.
  • Select the Auto Action which you want to use for Integromat. The Auto Action must be created by the Account which owns the property, actions linked from other accounts cannot be used.
  • Tick the rooms for which you want to send bookings. Only bookings from rooms enabled for Integromat and which meet the trigger conditions in the Auto Action will be sent.
  • Create an apiKey of 16 or more characters and save it.
  • Choose your send strategy, bookings can be sent repeatedly, once only or after each modification.
  • A default set of booking information is sent to Integromat, this can be customized by specifying the fields you want to send, one per line at the setting "Data fields". See below for a set of all fields.

Integromat

  • Create an Integromat account at Integromat.
  • Connect the Booking Automation App to your scenario and enter the apiKey you created and the Booking Automation Property Id.
  • Select the trigger "BA property bookings" and map the data into your scenario as you require.

Send template variables to Integromat

The advanced section of the Integromat connection form has eight template fields where you can enter BookingAutomation Template Variables.

The matching "template" data field must be specified in BookingAutomation as one of the Integromat data fields to enable the field (template1 etc.).

The Template Variable will be calculated and it's value sent to Integromat with the booking.

{{#fas:lightbulb}} Integromat provides list of developers who can help with integrations.

How it works

In Integromat you create a scenario which automates tasks for you. A scenario is comprised of a series of modules that indicate how data should be transferred and transformed between BookingAutomation and other apps/services.

Bookings are sent from BookingAutomation to Integromat when the room is enabled and the booking meets the trigger condition in the selected auto action.

If you have multiple properties enabled for Integromat and the auto action applies to their bookings, those bookings will also be sent. Bookings which were sent will appear in Integromat via the "watch bookings" trigger.

These bookings will then be automatically transferred from Integromat to the apps/services in your Integromat scenarios.

Data Fields

If the data fields setting is left empty, a default set of information will be sent about each booking.

If the data fields setting is used, only the booking number and the fields specified are sent to Integromat. Data field values must be specified one per line.

Possible values are:

groupId

roomId

roomName

unitId

unitName

status

checkIn

checkOut

lastNight

numAdult

numChild

guestTitle

guestFirstName

guestLastName

guestComments

guestArrivalTime

guestEmail

guestPhone

guestMobile

guestCompany

guestAddress

guestCity

guestState

guestPostCode

guestCountry

guestCountry2

lang

originalBooking

originalOTA

originalReferer

referer

notes

reference

custom1

custom2

custom3

custom4

custom5

custom6

custom7

custom8

custom9

custom10

offerId

voucher

flagColor

flagText

bookingTime

invoice

invoiceCharges

invoicePayments

totalCharges

totalPayments

totalBalance

price

tax

deposit

commission

rateDescription

template1

template2

template3

template4

template5

template6

template7

template8

Common Problems

Disconnect

Untick "Bookings" to stop sending bookings.

Examples

Create a Subaccount from a Google Form

1. Create the Google form(https://docs.google.com/forms/u/0/), you will need to at least “request” on the form

a)Username

b)Email

c)Password


2. Go to Integromat and create a scenario, start with a Google Forms, and set it to “Watch Responses”

Integromat subaccount1.png view large


3. Set the connection ( you will need to Allow Integromat to access your Google account).

a) Choose the “File” this is the same name you gave your “Form” in Google forms.

b) Worksheet, Google forms should create a worksheet in your Google drive, you need to select this here.

c) Maximum number of returned rows, Here, set the maximum number of results that Integromat will work with during one cycle, You can set this to one, we will make this scenario constantly checking for new responses.

Integromat subaccount2.png view large


4. After this, it will ask you to “Select the first row” this means the row you want Integromat to start checking the worksheet, it should normal be set to number”2” because the first row is used for the column names.


5. Now we will need to add another module, add the “Json” module and set it to “Create Json”


6. You will need to add a “Data Structure.

a) Click on “Add”

b) “Name the data structure” and click on “Generator”

c) Leave the “Content Type = Json

d) On the Sample Data insert

{
   "authentication": {
       "apiKey": "apiKeyAsSetInAccountSettings"
   },
   "createAccount": [
       {
           "username": "username",
           "password": "password",
           "apiKey": "YourKeyToUseForTheNewAccount",
           "email": "mail@email.com",
           "role": "0",
           "systemEmails": "0",
           "bookingEmails": "0",
           "bookingReplyto": "0"
       }
   ]
}

Integromat subaccount3.png view large

  • Click on “Save”, you should now see the original “window” with your data structure and it should have a “Authentication” box where you need to insert the API key,

Integromat subaccount4.png view large

  • You need to set the API key you have set under Settings -> Account - > Account Access
  • Click on “Add Items” under Create Account in Integromat, here you will need to add the variables into the correct fields.


After you have done this, click on “Add” and than click on “Ok”.

Now we are going to create another module.

  • Set the module HTTP, and set this to “Make a Request”

Integromat subaccount5.png view large


Click on “OK” and you are ready to test this scenario,

Open you Google form and insert some information, “username / Email and password” this will be added to row 2 on your worksheet, go to Integromat and click on “Run Once” it will insert this user as a sub account into your BookingAutomation account.

Sending Push Notifications for Bookings to your Google Chrome/Account

1. After you setup your BookingAutomation module in Integromat ( showing in this video https://www.bookingautomation.com/wiki/index.php/Integromat.com#Integromat) set the Google Chrome module.

Push1.png view large

2. Click on “Add This Chrome” and install the Integromat google chrome plugin.

Push2.png view large

3. Click on “Add to Chrome” to install the plugin

Push3.png view large

4. Copy the Registration Code

Push8.png view large


5. Paste the Registration code on the Chrome module in Integromat

Push4.png view large

6. Create the message you want to send, you can use the BookingAutomation Template variables that show in Integromat

Push5.png view large

7. Once a new booking is created, Integromat send a notification to your Google Chrome/Account

Push6.png view large

Push7.jpg view large

How to collect additional guest details and add to the booking

If you want to collect additional guest information and add this to the booking, you can do this using a Google Form and Integromat. Setup a google form with the information/questions you want to collect from a guest, and using Integromat we will get the response from the form and insert into the correct booking.

In this example we will show you how to collect additional guests information like “First name, Last Name, Id number and birth date. And insert this into the “Info” field of the booking

1. Setup a new google form and name this “Guests Information”

Guestinfo1.png view large


2. Create the questions

a. Booking ID

b. First Name

c. Last Name

d. Id Number

e. Birth date

Guestinfo2.png view large

3. Click on “Responses”, and than click on the “Excel Icon”

Guestinfo3.png view large


4. Select “Create a new Spreadsheet” and click on “create”

Guestinfo4.png view large


5. Log into Integromat, and start a new Scenario, the first module we are going to need is Google Forms and set this to “Watch Responces”.

6. Set the connection (you will need to Allow Integromat to access your Google account).

a. Choose the “File” this is the same name you gave your “Form” in Google forms.

b. Worksheet, Google forms should create a worksheet in your Google drive, you need to select this here.

c. Maximum number of returned rows, Here, set the maximum number of results that Integromat will work with during one cycle, You can set this to one, we will make this scenario constantly checking for new responses

Guestinfo5.png view large


7. After this, it will ask you to “Select the first row” this means the row you want Integromat to start checking the worksheet, it should normal be set to number ”2” because the first row is used for the column names.

8. Now we will need to add another module, add the “Json” module and set it to “Create Json”

9. You will need to add a “Data Structure. a. Click on “Add” b. “Name the data structure” and click on “Generator” c. Leave the “Content Type = Json d. On the Sample Data insert

{

   "authentication": {
       "apiKey": "apiKeyAsSetInAccountSettings",
       "propKey": "propKeyAsSetForTheProperty"
   },
   "bookId": "12345678",
   "firstNight": "2014-09-30",
   "numAdult": "3",
   "invoice": [
       {
           "invoiceId": "123456789",
           "description": "deposit payment",
           "status": "",
           "qty": "-1",
           "price": "23.45",
           "vatRate": "10",
           "type": "200"
       }
   ],
   "infoItems": [
       {
           "code": "PAYMENT",
           "text": "Paid $200"
       }
   ]

}

10. Click on “Save”, you should now see the original “window” with your data structure and it should have a “Authentication” box where you need to insert the API key

Guestinfo6.png view large


11. You will also need to add under “Notes” the following (See image) above

a. FirstName: - add the Integromat variable for the First Name

b. Last Name: - add the Integromat variable for the Last Name

c. Id Number: - add the Integromat variable for the ID Number

d. Birth Date: - add the Integromat variable for the Birth Date

12. Set the module HTTP, and set this to “Make a Request”

Set the:

a. URL: https://manage.bookingautomation.com/api/json/setBooking

b. Method:Post

c. Header: Leave blank

d. Query String: Leave blank

e. Body Type: Raw

f. Content Type: JSON

g. Request Content: JSON String ( Its a variable you need to drag and drop).

Guestinfo7.png view large


After you do this, go to your Google form and fill it in as a “guest” than in Integromat click on “Run Once” it should retrieve the answers and insert into the booking in the field “Notes”.