Google Forms + Google Chat Integration
Send messages to Google Chat on Google Form Submission
You can integrate Google Forms with Google Chat using Form Director. Form Director enables you to connect Google Forms with Google Chat, allowing you to send messages based on form responses.Â
When a user submits a Google Form, the responses are automatically sent to Google Chat accordingly.
Form Director is a Google Workspace add-on that directs data submitted from Google Forms to applications like Google Docs, Forms, Sheets, Contacts, Calendar, Tasks, Email, Trello, Slack, QuickBooks etc.
Installation:
It is available in the Google workspace Marketplace.Â
Please check installation instructions to install the add-on.
Google Chat is a communication software developed by Google. Originally a feature of Google+, Google Chat became a stand-alone product in 2013, when Google also began integrating features from Google+ Messenger and Google Talk into Hangouts.
Name your service
Choose Hangout from the list of Applications
Choose Send Message (Webhook) under services
Google Chat sends messages to Chat Rooms using to services.
Send Messages through Webhook
Provide your webhook URL.
From the chat room menu:
Select Manage Webhooks
2.Click on Add Webhook
3.Fill in the name field and optionally the avatar URL field.Â
4.Click Save.Â
5.Copy and provide the webhook URL in Form Director
Mapping of form fields to that of app fields is to be done in order to send messages with your form data.
Click on the edit mapping
Once you have done mapping you can save the service
Note : Mapping should be done between app field and form field of same type.Â
Notify your audience with success or error notifications.
Switch on Send Email to send email during execution.
Send your own customized emails on form submission to your audience.
Select the attachment to email from file upload in Google Form.
Click Pick Drive Files to attach files to Email.
Save service
You are all set to send messages to Google Chat on your Google Form submission
Submit the Google Form