How to automate Google Forms without Apps Script

What you can automate after a submission

This guide is about what happens after someone submits. Creating forms, filling them in automatically or importing data into them are different subjects.

One-step automations and multi-step workflows

A one-step automation reacts to a single event: a response arrives, an email goes out. It's quick to set up and rarely breaks.

A workflow follows each response over time:

1. Submitted
2. Assigned
3. Reminded
4. Overdue alert
5. Handled

That needs two things a one-step automation doesn't have: a place that remembers whether each response is still open, and checks that run on a schedule, because “nobody has replied for 24 hours” isn't an event any app sends. General automation platforms can do it with delays, lookups and a status column that you maintain. Follow-up tools have it built in.

Your no-code options

Built into Google Forms and Google Sheets

Free and dependable: email notifications for editors, copies for respondents, and a linked spreadsheet with formulas, conditional formatting and a daily email digest of new submissions for yourself. They inform; they don't follow up.

Google Workspace Studio

Google's own no-code flow builder, available on eligible Google Workspace editions, can start a flow when someone submits a form, for example to post a message in Google Chat. Check whether your edition includes it.

AppSheet

AppSheet, Google's no-code app builder, can run an automation each time a Google Form receives a response, for example to send an email, and can also run scheduled automations, such as a check every morning. It suits teams that want a custom app around their responses, with their own screens and rules. That flexibility has a cost: you design the app and its automations, and someone has to maintain them. Building automations with Google Forms requires a Google Workspace account; see Google's guide to building an automation using Google Forms.

Add-ons from the Google Workspace Marketplace

Each add-on does one job inside Forms: richer notifications, documents generated from responses, approvals, response limits. They're quick to install. Check the permissions they request and who maintains them.

Automation platforms such as Zapier or Make

They connect a form to the other apps you use: create a task or a card, add a CRM contact, post to Slack, update another spreadsheet. Both can start a workflow when a new response arrives. Zapier's Google Forms trigger reads the response spreadsheet, so the form must be linked to Google Sheets. Free plans exist with monthly usage limits, so check what your workflow needs before you build on one.

Response follow-up tools

Specialized tools such as Form Watchdog cover the part that's hard to build elsewhere: owners, deadlines, reminders and escalations, with defaults you can adjust. They do one job and don't try to connect every app.

General platform or specialized tool?

The two also work together: a platform can copy each response into your project tool while a follow-up tool makes sure someone handles it.

Example: a facilities request workflow, step by step

Here is a complete workflow for a building maintenance form, with a no-code way to do each step.

1. Collect the request. The form asks for the request type, the location, the priority and a description, and collects the requester's email. Google Forms
2. Confirm receipt. The requester gets a copy of their answers. Built in
3. Route it. Repairs go to the facilities coordinator, cleaning to the site manager, everything else to the office manager. Add-on or follow-up tool
4. Notify the owner, with the deadline. Follow-up tool
5. Remind and escalate. Remind the owner if the request is still open after 4 hours and again after 24 hours, then alert the team lead once it's 48 hours old. Follow-up tool, or a platform with delays
6. Create a work order in your maintenance or project tool, if you use one. Automation platform
7. Close it. The owner marks it handled, with a short note on the outcome. Follow-up tool or spreadsheet
8. Review each month: requests by type, late requests, handling time. Spreadsheet or analytics

In Form Watchdog, steps 3 to 5 and 7 come from one setup. The Team follow-up preset assigns each response to the owner you choose, sends reminders 4 and 24 hours after it arrives, sets a 48-hour response deadline, and alerts the assigned responder and the workspace owner when it passes. Add routing by answer and adjust the timings from there.

What each option costs to maintain

• Built-in settings: nothing to maintain, and nothing beyond what they do.
• Add-ons: the vendor maintains the code; you keep the settings current and review permissions.
• Automation platforms: each workflow is yours. Renamed questions or columns can break a step, failed runs need checking, and usage grows with your volume.
• Apps Script: free within Google's quotas, but someone has to own the code, and triggers run under one person's account.
• Follow-up tools: a subscription and less flexibility, in exchange for less to build and watch.

Free options are often the right choice for simple workflows that someone keeps an eye on. Paid tools make sense when building and checking the workflow takes more time than it saves.

What Form Watchdog automates

Form Watchdog connects to your existing form without changing it and runs the follow-up for each response. You start from a preset and adjust it:

Also automated: routing by answer, a second overdue alert after a delay you choose, a daily summary with the number of new, unhandled and overdue responses for each form, Slack updates, and signed webhooks for events such as response received, assigned, reminder sent, overdue alert, handled and reopened. Webhooks carry the form, a response reference, its status, its owner's ID and its deadline, not the answers.

It doesn't send confirmations to respondents, generate documents, run approvals or create records in other apps. Use the built-in settings or an automation platform for those.