Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start integrating Google Forms with Google Chat, you first need to access Pabbly Connect. Simply visit the Pabbly website by typing pabby.com in your browser. Once there, you will see options to sign in or sign up for free.

If you are an existing user, click on the “Sign In” option. New users can click on “Sign Up for Free” to get 100 tasks monthly. After signing in, navigate to the Pabbly apps page and select Pabbly Connect to begin your workflow.

2. Creating a New Workflow in Pabbly Connect

In Pabbly Connect, you can create a new workflow to connect Google Forms with Google Chat. Click on “Create Workflow” and name it “Get Instant Google Chat Alerts for New Google Form Submission”. Choose a folder for organization, such as “Forms Automation”.

  • Click on “Create” to finalize the workflow setup.
  • You will see a box for entering your trigger application.
  • Select Google Forms as your trigger application.

Once the workflow is created, you will be prompted to select a trigger event. Choose “New Response Received” from Google Forms and click on “Connect” to establish the connection.

3. Setting Up the Trigger for Google Forms

The next step in Pabbly Connect is to set up the trigger for Google Forms. A webhook URL will be provided, which acts as a bridge between Google Forms and Pabbly Connect. Copy this URL and proceed to your Google Forms.

Open your Google Form and navigate to the responses section. Click on “View in Sheets” to ensure that your form is linked to a Google Sheet. This connection allows form submissions to automatically populate the spreadsheet.

  • Ensure the toggle for accepting responses is turned on.
  • Perform a test submission to check if the data populates correctly in the Google Sheet.

Once the form submission is successful, you can proceed to configure the webhook by going to “Extensions” in Google Sheets, selecting “Add-ons”, and then “Get add-ons”. Search for “Pabbly Connect Webhooks” to install it.

4. Configuring the Webhook in Google Sheets

After installing the add-on, refresh your Google Sheets and navigate to the “Extensions” menu again. Click on “Pabbly Connect Webhooks” and then select “Initial Setup”. Here, paste the webhook URL you copied earlier.

In the setup, specify the trigger column, which is the final data column where new data entries will be sent. For example, if your final data entry is in column F, enter that in the trigger column field.

  • Click on “Send Test” to ensure the data is being sent successfully.
  • Submit the setup to confirm the configuration.

Once the setup is complete, you will need to enable the “Send on Event” option to ensure that new form submissions trigger the workflow in Pabbly Connect.

5. Sending Data to Google Chat Using Pabbly Connect

To send the form submission data to Google Chat, return to Pabbly Connect and select Google Chat as your action application. Choose “Create Message” as the action event and click on “Connect”.

In the message setup, you will need to enter the webhook URL for your Google Chat space. Go to Google Chat, click on the arrow next to your chat space, and select “Apps and Integrations” to add a webhook. Name it appropriately, such as “Google Forms”.

  • Copy the provided webhook URL and paste it into Pabbly Connect.
  • Compose your message, including details from the form submission.

Finally, click on “Save and Send Test Request”. If successful, you should see the message appear in your Google Chat space, confirming that the integration works seamlessly.

Conclusion

In this tutorial, we demonstrated how to integrate Google Forms with Google Chat using Pabbly Connect. This automation allows you to receive instant notifications for new form submissions, streamlining your communication process.