No custom script maintenance

Google Forms approval workflow without Apps Script

Use Google Forms for the request, the linked response Sheet for the workflow record, and FormFlow for reviewer emails, approve/reject decisions, Preflight, and status tracking.

Quick answer

You can build a lightweight Google Forms approval workflow without Apps Script by connecting the form to a response Sheet, installing FormFlow, adding one internal reviewer, running Preflight, submitting one internal test response, and confirming the reviewer email plus linked-Sheet status update.

What custom Apps Script normally has to do

Trigger

Run on form submit

A script needs a reliable trigger that starts when a new response lands.

Email

Build reviewer messages

The script has to choose recipients, format request details, and send approval emails.

Decision

Handle approval links

Reviewer links need identity, state, error handling, and a way to record approve or reject.

Record

Write back to Sheets

The workflow needs to update the same response row with Pending, Approved, or Rejected.

No-code setup path

  1. Create or copy the Google Form you want to test.
  2. Link the form to a Google Sheets response file.
  3. Install FormFlow from Google Workspace Marketplace.
  4. Open FormFlow from the Google Forms add-ons menu.
  5. Select the exact linked response Sheet.
  6. Add one internal reviewer email address.
  7. Save the workflow and run Preflight.
  8. Submit one internal response and make one approve or reject decision from the reviewer email.
  9. Check that the linked Sheet status updates on the same response row.

When this fits

Internal request forms

Simple requests where one reviewer can approve or reject the submitted details.

School or team operations

Lightweight approvals where a Sheet status record is enough for tracking.

Event or resource requests

Small approval queues that need reviewer email and a decision trail.

Prototype before code

Teams that want to prove the workflow before writing or maintaining Apps Script.

Limits and cautions

Next steps

FAQ

Can I create a Google Forms approval workflow without Apps Script?

Yes, for a lightweight approval path. FormFlow handles reviewer email, approve/reject decisions, Preflight, and linked-Sheet status tracking.

Why not just write Apps Script?

You can, but then someone must maintain authorization, triggers, email templates, reviewer links, error handling, and Sheet write-back behavior.

When should I leave a Marketplace review?

Only after Preflight passes, the reviewer email arrives, the decision link works, and the linked Sheet status updates.