Email Approval Workflow with Google Forms & Google Sheets скачать в хорошем качестве

Email Approval Workflow with Google Forms & Google Sheets

In this video, I'll show you how to create an email approval workflow, using an expense reimbursement request as an example. The user would use a Google Form to submit an request, the approver would get an email with the details and the option to approve or deny the request, which then triggers a follow-up email to the requestor as well as moving that row in the sheet to the appropriate section (Approved to payout or Denied). You can make a copy of the final Google Sheet, Form, and Apps Script here: https://bit.ly/41J4eBR **** TIMESTAMPS **** 0:00 Intro 0:13 1. Creating the Google Form 2:42 2. Setting up the Google Sheet 4:58 3. Scripting the Approval Request Email 18:54 4. Script to Handle Approved/Denied Status 30:25 5. Authorization, Trigger, and Web App Setup 33:15 6. Running the Workflow 34:54 7. Updates & Tweaking HTML 43:21 8. Conclusion