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:
- Go to ChatDaddy notifications(https://app.chatdaddy.tech/notifications)
- click "Google Form" in the pop-up window
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!🎉