Run on form submit
A script needs a reliable trigger that starts when a new response lands.
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.
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.
A script needs a reliable trigger that starts when a new response lands.
The script has to choose recipients, format request details, and send approval emails.
Reviewer links need identity, state, error handling, and a way to record approve or reject.
The workflow needs to update the same response row with Pending, Approved, or Rejected.
Simple requests where one reviewer can approve or reject the submitted details.
Lightweight approvals where a Sheet status record is enough for tracking.
Small approval queues that need reviewer email and a decision trail.
Teams that want to prove the workflow before writing or maintaining Apps Script.
Yes, for a lightweight approval path. FormFlow handles reviewer email, approve/reject decisions, Preflight, and linked-Sheet status tracking.
You can, but then someone must maintain authorization, triggers, email templates, reviewer links, error handling, and Sheet write-back behavior.
Only after Preflight passes, the reviewer email arrives, the decision link works, and the linked Sheet status updates.