91
edits
Changes
Jump to navigation
Jump to search
Make
,no edit summary
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”.
</div>
</div>
<div class="mw-collapsible mw-collapsed">
<div class="headline-collapse" >
== Collect Guest details from a Google Form ==
</div>
<div class="mw-collapsible-content">
If you want to collect additional guest information ( or update the current 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, address, city, postcode and country. And insert this into the corresponding field of the booking
1. Setup a new google form and name this “Guests Information”
Create the questions
a. Booking ID
b. First Name
c. Last Name
d. address
e. city
f. postcode
g. country
IMAGE1
2. Click on “Responses”, and than click on the “Excel Icon”
IMAGE 2
3. Select “Create a new Spreadsheet” and click on “create”
IMAGE 3
4. 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”.
4.1. 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
IMAGE 4
4.2. 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”
IMAGE 5
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",
"propKey": "propKeyAsSetForTheProperty"
},
"bookId": "12345678",
"guestFirstName": "Joe",
"guestName": "Smith",
"guestAddress": "1 Big Street",
"guestCity": "London",
"guestPostcode": "EX 1234",
"guestCountry": "United_Kingdom"
}
6.1. 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
6.2You will also need to add the correct “Google form” variables into the corresponding fields., just like the image below
IMAGE 6
7. Next Add a new module, you need a HTTP module and set this to “Make a Request”
Set the:
a. URL: https://api.beds24.com/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).
IMAGE 7
7.1 Click on safe, now go to your google form, firl in the form with a actual Booking ID ( make sute i tis a “test” booking) after you do this go back to integromat and click on “Run Once”, it should get the responses and insert the infromation into the Booking.
</div>
</div>
