Instantly posts your Google Forms responses to a Slack channel
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.gitignore Add .gitignore Jan 4, 2017
README.md Update comments and README in light of the programmatic trigger enhan… May 20, 2018
code.js Add comments and document links May 20, 2018

README.md

Google Forms To Slack

Do you have a Google Form? Did you ever wish that you could get a Slack message when someone submits the Google Form? Great, because that is exactly what this script does.

Technology Info

  • This script is a web service client to the Slack Incoming Webhook API; it posts slack messsages using HTTP Post.
  • This is a Google Apps script. That is, a JavaScript environment that can automate Google Drive products such as Google Sheets and Google Forms. It also comes with a neat browser based IDE. https://developers.google.com/apps-script/

Setup

You'll need a few things

  • A Google Sheet attached to your Google Form.
  • An Incoming Webhook integration for your Slack channel. Set this up in Slack and make note of the URL it provides, you'll need it. https://api.slack.com/incoming-webhooks

Procedure

  • Open your Google Forms Spreadsheet.
  • In the menu, click on "Tools" -> "Script Editor".
  • Paste the code.js script into the Script Editor.
  • Edit the code you pasted to include the Slack Incoming Webhook URL in the customizations block; change the variable slackIncomingWebhookUrl and then set your channel name in the variable postChannel. Save.
  • Set up the event triggers by running the initialize() function. In the Script Editor's menu bar, select the function initialize and click Run. Agree to any permission requests.
  • You're done! Try it out by submitting a response to your Google Form. If successful, you'll see a new message in your slack channel.