Send Google Forms responses to Slack

Keep your team informed and responsive by sending Google Forms responses directly to Slack. This MESA workflow template shares each form submission in real time, enabling faster follow-ups and enhancing team collaboration. Perfect for managing inquiries, feedback, or requests, this automation ensures that your team is always in the loop.

🔧 Setup is needed:
➕ Create a Google Forms form
🔌 Connect with Slack
✏️ Configure your Slack message

Step 1

While logged onto your preferred Google account, locate an existing form or create a new form using this link: https://docs.google.com/forms/u/0/?tgif=d. If you are logged into multiple Google accounts, this link will use the first account that you are logged into, so please make sure that you are using the correct Google account.

If you have an existing form, click on the form to edit it.

For first-time Google Forms users, this guide can help you create your first form.

Step 2

Once you have a Google Forms form properly set up to your liking and while you are viewing it, click on the three-dotted icon at the top right-hand navigation and click on Script editor.

Step 3

In a new tab and back into your MESA workflow, click on your Google Forms Submitted trigger step.

Then, click on the Copy icon next to the Webhook Code field.

Step 4

Go back to the browser tab with the Google Script editor open.

Locate where it says this in the editor.

function myFunction() {

}<br>

Step 5

Erase everything in the editor.

Then, paste what you just copied from the MESA workflow.

Step 6

After pasting, click on the floppy disk icon (from the editor's top navigation), which is the third icon on the right. This icon lets you save the code.

Step 7

Above the floppy disk icon, click on Untitled project and rename the project to the name of your MESA workflow for organization purposes.

Step 8

On the left-hand sidebar, click on the clock icon labeled Triggers.

On the Triggers page, click on the + Add Trigger button in the bottom right corner.

Locate the Select event type field on the prompted modal. Change the dropdown menu selection to On form submit.

Then click Save.

Step 9

After clicking Save, make sure that you are prompted with a new browser tab to sign into your Google Account. If you do not see a new browser tab after clicking Save, you may have disabled pop-up notifications, so please check your notification settings as well.

Once you log into your Google account, you will be prompted to grant Google access to your Form. Click on Allow.

When viewing the Triggers page, refresh the page and make sure that a trigger has been created with the Event set to From form - On form submit.

Step 10

Go back to the MESA dashboard and view your workflow.

Click the toggle to switch the workflow On.

Step 11

Go back to your Google Forms and click Send.

Click the Link icon and then click Copy.

Step 12

Open a new browser window and paste the copied link to go to your Google Forms.

Create a test response and click Submit.

Step 13

Go back to the MESA dashboard and view your workflow.

Refresh the webpage and click on the Google Forms Submitted trigger step.

Then click on the Live records section. Select the existing live data record and click Run step.

Step 14

After the test for the trigger step is completed, click on the Slack Send Message step.

Click on Connect with Slack.

If you have already created a Slack connection, skip to step 17 in this help document.

Step 15

You will then see this permission screen. Click Allow.

Step 16

After authorizing the Slack app, open your Slack application on your computer.

You can invite the MESA Slack app to the channel you want to send messages to by typing @MESA and clicking the Invite button.

You will see the following message if you are successful with adding the MESA Slack app to your Slack channel.

Step 17

Go back to your workflow's Slack step.

Under the Step Configuration section, select the Channel.

Step 18

In the Configure section, configure your Slack message.

While clicking the Insert variable icon, you'll be able to select variables related to the responses.

Step 19

Click Save Changes to save all changes.

Step 20

To test all the steps, you can click on the Google Forms Submitted trigger step. Select an existing live data record and click Run workflow.

Step 21

Provide your customers the link to your Google Forms so their responses can be collected.

✋ Still have questions? We got you. Email us at contact@getmesa.com where actual humans are on standby, ready to help.