How to install Google Form

User story：

When clients submit a google form, you need to send a confirmation notification to him/her immediately

Step 1:

Open the Google form you want to integrate, find the phone number field, its name must be exactly: WhatsApp Number(with country code)

Step 2:

Click Responses, and then spreadsheet icon, and make sure to turn on Accepting responses

Step 3:

Copy id of the spreadsheet to your note for later use

Note: id is between d/ and /edit

Step 4:

Click Share and grant access to google-forms-notifications-bot@chatdaddy-uat-environment-1.iam.gserviceaccount.com, viewer access is enough, then click Done

Step 5:

Step 6:

Input Google form username: id you copy in Step 3

Step 7:

Add your custom trigger

Step 8:

Click template box and choose/create a template

Notice: For google form notification, you can use all variables you have in your spreadsheet: For example: For the below sheet, I can use variables: {{Timestamp}}, {{Your name}}, {{WhatsApp Number(with country code)}}, {{Appointment time}}, {{Appointment Date}}

So my template can be: Hi {{Your name}}

Thanks for your appointment. You have booked a meeting with us at {{Appointment time}{{Appointment Date}}. Please find our meeting address here: xxxxxxxxx.

Step 10:

When message template is set up, click 'Save'

Congratulations! You have done Google form Notification set up!🎉