I will automate google form responses with email and slack notifications


About this gig
Know the moment a form response lands
Google Forms already collects the answers - the slow part is noticing, copying, and telling the right person. I connect your form's response Sheet with Google Apps Script so every new submission instantly triggers the alert you actually need.
What I can set up:
- Instant email to one or more addresses when a response arrives, with the fields you choose, formatted to read at a glance
- A Slack message to your channel for new submissions
- An automatic PDF summary of each submission, attached to the email or saved to Drive
- Conditional routing: different recipients depending on an answer (by location, topic, or urgency)
Built on a copy of your Sheet, tested with dummy submissions before delivery, with plain-English notes. You authorise the script once in your own Google account (about 2 minutes) - no passwords shared, ever.
Honest expectations: one form, one response Sheet, the alerts in your package. It does not replace a helpdesk or CRM system, and delivery speed depends on Google's trigger timing (usually near-instant, occasionally a few minutes).
Get to know Ray P
Google Sheets Automation Apps Script
- FromCanada
- Member sinceJul 2021
Languages
English
FAQ
What do you need from me?
A sample of the response Sheet (or your form's questions), who should be notified, and example wording if you have it. No live access needed — samples are fine.
Email, Slack, or both?
Both are supported from Standard up. Basic is email-only: an instant email alert showing the fields you choose.
Can different answers go to different people?
Yes — that's the Premium routing option. List your rules (answer value → recipient) in your order answers and I'll build them in.
Why do I have to authorise the script in my own Google account?
Google requires it: any Apps Script that sends email, creates PDFs, or runs on a schedule must be authorised by the account owner. It's a standard Google screen, takes about 2 minutes, and my notes guide you click-by-click. The automation then runs under your account and your permissions only.
What counts as a revision — and what doesn't?
A revision fixes anything agreed that doesn't work as described: a field missing from an alert, a notification that doesn't trigger, wrong details in the PDF. It does not cover new features, extra steps, or extra forms — those are a custom extra or new order, quoted before work starts.
What is NOT included in this gig?
Not included: building a complete custom CRM or helpdesk system, work inside live bank or accounting accounts, ongoing data entry or monitoring after delivery, guaranteed business outcomes, and rush delivery unless agreed in a custom offer before you order.
What if it can't be built — for example my Google Workspace admin blocks scripts?
If a Google Workspace admin policy blocks the script, or a third-party service the workflow depends on keeps failing, I'll show you exactly what blocked it. We'll either agree a workaround inside your package, or you can cancel for a refund of the undelivered work.
