In this solution, HR submits a request, using Google Forms, for each new employee requiring system access and equipment. They indicate which devices the employee will need under various categories. They also include start dates and office location.

Upon submitting a request, IT is automatically notified to review the request in Google Sheets. They set up system access and prepare devices and equipment for the employee’s first day. Upon completion of the task, they update the status column in the sheet. With a custom Apps Script, an email notification is sent to HR once the status is marked as complete.

• The FormApp service is used to create a request form.
• The SpreadsheetApp service is used to move items in the spreadsheet through the workflow.
• Triggers are used to monitor for new requests and clean up completed items.
• The MailApp service is used to send email notifications.

1. Create a copy of the sample Equipment request spreadsheet.
2. Click Extensions > Apps Script to edit the script.
3. In the script, change the value of REQUEST_NOTIFICATION_EMAIL to your email address.
4. Save the script.
5. Close the script editor.
6. Click on custom menu item Equipment requests > Setup.
7. A dialog box will appear and tell you that the script requires authorization. Read the authorization notice and continue.
8. You will see a new Form menu. Click it and select Go to live form.
9. Fill out the form and submit your response.
10. Check your email for a notification about the equipment request.
11. Return to the sheet.
12. In the Pending requests tab, change the status of the request to Completed
13. Within 5 minutes, you will receive another email notifying you the request has been completed.

To get started with Google Apps Script, try out the codelab which guides you through the creation of your first script.

You can also view the full source code of this solution on GitHub to learn more about how it was built.