How to Send Google Forms Responses to Slack Automatically

Learn how to send Google Forms responses to Slack automatically using Pabbly Connect. Follow this step-by-step guide for seamless integration. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start sending Google Forms responses to Slack, you need to access Pabbly Connect. Open a new browser tab and navigate to Pabbly.com/connect. This platform is essential for automating the integration between Google Forms and Slack.

Once on the Pabbly Connect site, you will see two options: ‘Sign In’ and ‘Sign Up Free.’ If you are new to Pabbly, click on ‘Sign Up Free’ to create an account. Existing users can simply sign in. After logging in, navigate to the Pabbly Connect dashboard to begin creating your workflow.

2. Creating a New Workflow in Pabbly Connect

After accessing the dashboard, the next step is to create a new workflow using Pabbly Connect. Click on the ‘Create Workflow’ button, and you will be prompted to select a workflow builder. Choose the ‘New Beta’ version for this tutorial.

Next, enter a descriptive name for your workflow, such as ‘Notify Team Members from Google Forms to Slack.’ Select a folder for your workflow and click the ‘Create’ button. This action sets the foundation for your automation process.

• Click on ‘Create Workflow’.
• Select ‘New Beta’ as the workflow builder.
• Enter the workflow name and select a folder.

Now your workflow is created successfully, and you are ready to set the trigger for your automation.

3. Setting Up the Trigger with Google Forms

The next step in using Pabbly Connect is to set up the trigger. Click on the trigger application option and select ‘Google Forms’. Choose the event type as ‘New Response Received’ to ensure that the automation triggers whenever a new form submission is made.

After selecting the event, click on the ‘Connect’ button. Pabbly Connect will provide you with a webhook URL. Copy this URL as you will need it to connect your Google Forms account to Pabbly Connect.

• Select ‘Google Forms’ as the trigger application.
• Choose ‘New Response Received’ as the event type.
• Copy the webhook URL provided by Pabbly Connect.

Now, navigate to your Google Forms account to set up the connection using the webhook URL you copied.

4. Connecting Google Forms to Pabbly Connect

In your Google Forms account, select the form you want to integrate. Click on the ‘Responses’ tab, and then click on ‘View in Sheets’. This action opens a Google Sheets document where all form responses are collected. To send this data to Pabbly Connect, you need to install the Pabbly Connect Webhooks add-on.

To install the add-on, click on ‘Extensions’, then select ‘Add-ons’, and finally click on ‘Get Add-ons’. Search for ‘Pabbly Connect Webhooks’ and install it. Once installed, go back to the add-ons menu, click on ‘Pabbly Connect Webhooks’, and select ‘Initial Setup’. Paste the webhook URL you copied earlier into the designated field and set the trigger column to the final data column.

Select your Google Form and go to the ‘Responses’ tab. Open the Google Sheets linked to your form. Install the Pabbly Connect Webhooks add-on.

After setting up the webhook, send a test response through your Google Form to ensure that the connection to Pabbly Connect is working properly.

5. Setting Up the Action to Send Messages to Slack

With the Google Forms connection established, it’s time to set up the action in Pabbly Connect to send notifications to Slack. Click on the plus icon to add a new application and select ‘Slack’. Choose the event type ‘Send Channel Message’ to notify your Slack channel whenever a new form response is received.

Click on the ‘Connect’ button, and you will be prompted to create a new connection. Select ‘Add New Connection’ and enter the token type as ‘Bot’. After saving, authorize the connection. Then, select the Slack channel where you want to send the notifications and customize the message content. Use mapping to pull in data from the Google Forms responses.

Select ‘Slack’ as the action application. Choose ‘Send Channel Message’ as the event type. Map the response fields to customize your Slack message.

Once you have configured the message, save your settings. Now, every time a new response is submitted in Google Forms, a notification will be sent to your designated Slack channel.

Conclusion

In this tutorial, we explored how to send Google Forms responses to Slack automatically using Pabbly Connect. By following the detailed steps outlined, you can easily set up this integration to streamline communication within your team. With Pabbly Connect, automating your workflows has never been easier.