Skip to content

ashtonfei/google-apps-script-projects

 
 

Repository files navigation

GAS-070 Google Form Approval

Description

This is an approval workflow built with Google Form, Gmail, and Google Apps Script.

Make a copy of the script

Make a copy

If you prefer to use clasp

GAS-059 How to use clasp - Watch on YouTube

Script Type

Google Form

Configuration

  • Approval flows
// Define the approval flows in this object
const FLOWS = {
	defaultFlow: [
		{
			email: "[email protected]",
			name: "Ashton Fei (default 1)",
			title: "Team Lead",
		},
		{
			email: "[email protected]",
			name: "Ashton Fei (default 2)",
			title: "Manager",
		},
	],
	HR: [
		{
			email: "[email protected]",
			name: "HR Lead",
			title: "HR Team Lead",
		},
		{
			email: "[email protected]",
			name: "HR Manager",
			title: "HR Manager",
		},
	],
	IT: [
		{
			email: "[email protected]",
			name: "IT Lead",
			title: "IT Team Lead",
		},
		{
			email: "[email protected]",
			name: "IT Manager",
			title: "IT Manager",
		},
		{
			email: "[email protected]",
			name: "IT President",
			title: "IT President",
		},
	],
};
  • Web App Url
this.url =
	"https://script.google.com/macros/s/AKfycbzKrd0zkrNgCm54Ycdv3e82BWxe4r34zSx4iZ0nTMU_TuhApgY/exec"; // IMPORTANT - copy the web app url after deploy
  • Header name of flow key
this.flowHeader = "Department"; // IMPORTANT - key field for your flows

Screenshots

  • Requester notification image

  • Approver notification image

  • Approver action page image

  • Requester notification (final result) image image

  • Approval progress check page image

  • Reset UID image

YouTube