95
edits
Changes
Jump to navigation
Jump to search
Make
,[[Media:Guestinfo2.png|view large]]
3. Click on “Responses”, and than click on the “Excel Icon”
[[Image:Guestinfo3.png|650px|link=]]
[[Media:Guestinfo3.png|view large]]
4. Select “Create a new Spreadsheet” and click on “create”
[[Image:Guestinfo4.png|650px|link=]][[Media: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”.
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:Guestinfo5.png|650px|link=]][[Media: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.
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
[[Image:Guestinfo6.png|650px|link=]][[Media:Guestinfo6.png|view large]]
11. You will also need to add under “Notes” the following (See image) above
f. Content Type: JSON
g. Request Content: JSON String ( Its a variable you need to drag and drop).
[[Image:Guestinfo7.png|650px|link=]][[Media: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”.
