Loading tutorials…
Loading tutorials…
Google Forms has weak native notifications, fine Sheets-based notifications, and powerful Apps Script notifications. This walks through each tier and when to upgrade.
Who this is forOperators who need to know when a new response comes in. Sales teams, support teams, event coordinators. Skip this if you check the Responses tab manually.
What you'll need
Step 1
In the Form: Responses tab → 3-dot menu → "Get email notifications for new responses."
Open the form. Click "Responses" tab.
Click the 3-dot menu (top-right).
Toggle "Get email notifications for new responses" ON.
You will get an email each time a response comes in. The email contains: form title, response link. No response content.
Useful for low-volume, low-urgency contexts. Useless for sales response.
Step 2
In the linked Sheet: Tools → Notification rules → "Any changes are made" + email frequency.
Open the linked Google Sheet (see "Connect Google Forms to Sheets").
Tools → Notification rules → Add another rule.
Pick: "Any changes are made" + "Email — right away" or "Email — daily digest."
Save. You will get an email summarizing changes. Still does not include response content directly, but you can click into the Sheet quickly.
Step 3
Write a Google Apps Script with an `onFormSubmit` trigger that sends an email containing the actual response content.
In the linked Sheet: Extensions → Apps Script.
Paste this script: ``` function onFormSubmit(e) { const values = e.namedValues; let body = "New response:\n\n"; for (const key in values) { body += `${key}: ${values[key]}\n`; } MailApp.sendEmail("you@yourcompany.com", "New form response", body); } ```
Save. Click the clock icon (Triggers) → Add trigger → Choose function `onFormSubmit` → Event source "From spreadsheet" → Event type "On form submit."
Save and authorize. Test by submitting a response — email arrives within 30 seconds with full content.
Step 4
Modify the Apps Script to POST to a Slack incoming webhook instead of (or in addition to) email.
In Slack: create an Incoming Webhook (Slack App Directory → search Incoming Webhooks → Add to Slack).
Copy the webhook URL.
In Apps Script, replace the email line with: ``` UrlFetchApp.fetch(SLACK_WEBHOOK_URL, { method: "post", contentType: "application/json", payload: JSON.stringify({ text: body }) }); ```
Save. Re-test with a form submission. The message arrives in Slack with full response content.
Step 5
Submit a real test response. Verify email and/or Slack arrive within 30 seconds with correct content.
Submit a test response from Preview.
Check your email inbox — should see notification within 30 seconds.
Check Slack — should see message within 30 seconds.
Delete the test response after verification.
Common mistakes
Relying on native notifications for sales response
What goes wrong: Native notification says 'New response' with a link. Sales rep has to click into the form to see what the lead said. By the time they read it, response time is 30+ minutes. Lead-conversion drops 50% for every minute past 5.
How to avoid: Use Apps Script or Slack notifications with full response content. Sales rep can read and respond in one screen.
Sending notifications to the wrong inbox
What goes wrong: Notifications go to a personal Gmail. When the person leaves the company, no one sees new responses for 3 weeks.
How to avoid: Send to a shared inbox (sales@) or a Slack channel. Multiple people see notifications.
Setting daily digest for time-sensitive forms
What goes wrong: Demo-request form notifications come in a daily digest at 8am. By the time the rep follows up, the lead has already booked with a competitor.
How to avoid: Time-sensitive forms = real-time notifications. Daily digest only for non-urgent forms (NPS surveys, etc.).
Not testing Apps Script trigger
What goes wrong: You write the script, save it, but the trigger never fires because authorization was skipped. Notifications silently fail. You realize at 50 missed responses.
How to avoid: After saving the trigger, ALWAYS submit a test response to verify. Check Triggers panel for execution log.
No fallback when Apps Script fails
What goes wrong: Apps Script hits a daily quota (Google limits ~1,500 emails/day per account). All notifications stop without warning.
How to avoid: Keep native notifications ON as a fallback. If Apps Script fails, native at least tells you a response came in.
Recap
Done — what's next
How to connect Google Forms to Google Sheets
Read the next tutorial
Hand it off
Setting up notifications is a 30-minute task. Building a real lead-routing system with conditional alerts, SLA tracking, and CRM enrichment is a job. A vetted specialist will set up the system. From $14-16/hr.
See specialist rates
Google Forms is built for survey use cases, not sales response. Native notifications were designed for the 'hey, you have a new response, check it later' workflow.
Yes — Apps Script is part of Google Workspace at no extra cost. There are daily quotas (~1,500 emails/day for personal accounts, higher for Workspace), but they are generous for most use cases.
Yes via Apps Script — read the response answer, then send to different emails. ~15 min of script to set up conditional routing.
Typically 5-15 seconds after submission. Occasionally 30-60 seconds during peak load. For sub-second SLA, use Zapier or a webhook tool.
Yes. Same pattern — create an Incoming Webhook in Teams, POST from Apps Script. Same code structure with the Teams webhook URL.
Google Forms
Google Forms → Sheets is the simplest sync in the SaaS ecosystem — and the easiest to mess up by adding formulas in the wrong place. Here is the setup that survives 10,000 responses.
Google Forms
Google Forms is free, fast, and forgiving — which is why most surveys collect garbage data. This walks through the setup path that actually returns reliable answers.
Google Forms
Most customer feedback surveys collect data that nobody uses. This walks through structuring NPS, CSAT, and qualitative feedback in Google Forms so the data drives decisions.
Google Forms
DIY surveys are great — until the data stops driving decisions, or your forms convert at 18%. Here is the honest framework: when the cost of self-managing exceeds the cost of hiring.