Post Google Sheets form entries to Slack
By using Google Form's script editor, you can call Slack webhooks when form submissions are made. You can use this script to do things like creating a live feedback form for taking questions from an audience or notifying your team when someone signs up for an event.
First, be sure you're collecting the email address in the form:
Create a form script
Next, open the script editor:
You may need to authorize access to Google Docs:
Create a Slack app
Go To https://api.slack.com/apps and create a new app,
Next, create an "incoming webhook" for your app, and swap in a url for the
SLACK_WEBHOOK_POST_URL in our script in the script editor.
Then you'll need to edit the forms "triggers" so that our
onSubmit function is called when a new form response is recorded:
Once you create the trigger, you're all done!