Short answer: Use a free Google Apps Script that posts each new Google Form response to a Slack channel the moment it arrives, so nobody waits on a lead. It runs in your own Google account; nothing is sent to us. Setup takes 4 steps: Open the responses sheet; Add your key; Paste the script; Turn it on.
How to set it up
- Open the responses sheet. Open the Google Sheet your form sends its responses to. In the form, that's the Responses tab, then Link to Sheets.
- Add your key. In the Apps Script editor, open Project Settings and add the Script property
SLACK_WEBHOOK. In Slack, create an app at api.slack.com/apps, turn on Incoming Webhooks, add one for your leads channel and copy its URL. Keys stay in the script, never in the sheet. - Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a Slack alerts menu appears.
- Turn it on. Choose Slack alerts, then Send a test message to check the channel, then Turn on alerts. Each new response is posted with every answer that isn't blank and a link to the sheet.
Want this set up for your business? Free written scope in 20 minutes
Get the script
Download it free
We'll email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.
Have us install it for you
We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
Good to know
- It works with Google Forms. For a form on your website, see our website form to Google Sheets script first.
- Anyone with the webhook URL can post to that channel, so keep it in Script properties.
- Want a text message instead? See our form to text message script.
Questions
What does this script do?
It is a free Google Apps Script that posts each new Google Form response to a Slack channel the moment it arrives, so nobody waits on a lead.
How do I set it up?
In 4 steps: 1. Open the responses sheet; 2. Add your key; 3. Paste the script; 4. Turn it on. The full steps are on this page.
Is it free, and does it send my data anywhere?
It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.
Can you install it for me?
Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
Want this connected to the rest of your tools? Send us a short brief.
Pushbuild · Automate your business with Pushbuild: pushbuild.com/