About this solution
New employees usually require system access and equipment from IT. To manage these requests, you can create a Google Form for users to indicate what access and devices employees need. Once IT completes the request and updates its status, requesters receive an email notification.
How it works
The script creates an equipment request form. You can customize the items on the form in the sample script's code. When someone submits the form, the script sends an email notification to the designated point of contact for requests. Once the request status in the spreadsheet is changed to "Completed," the script sends a confirmation email to the person who submitted the form.
Apps Script services
This solution uses the following services:
- Forms Service: Creates the form for IT requests.
- Spreadsheet Service: Checks to see if the request form already exists to mitigate duplicates. Manages the form responses by moving them to the Pending and Completed sheets as needed.
- Mail Service: Creates and sends the request and completion notification emails.
- Script Service: Creates the triggers. One fires when a form is submitted and the other fires every five minutes to check if a request’s status is marked as "Completed."
Before you begin
To use this sample, you need the following prerequisites:
- A Google Account (Google Workspace accounts might require administrator approval)
- A web browser with access to the internet
Step 1: Set up the spreadsheet
- Click the button below to make a copy of the Manage employee equipment
Make a copy
- Click Extensions > Apps Script.
- Next to the
REQUEST_NOTIFICATION_EMAILvariable, replace the sample email with your email.
- Click Save .
- Return to the spreadsheet and click Equipment requests > Set up. You might need to refresh the page for this custom menu to appear.
- When prompted, authorize the script.
- Click Equipment requests > Set up again.
Step 2: Create and manage a sample request
- Click Tools > Manage form > Go to live form.
- Fill out and submit the form.
- Check your email for a notification about the equipment request.
- Return to the spreadsheet and on the Pending requests sheet, change the status of the request to Completed.
- Within 5 minutes, the script sends another email notifying you that the request has been completed. The script moves the request from the Pending requests sheet to the Completed requests sheet.
Open the Apps Script project
The sample script's code includes in-line comments to help you understand how it works. To access the code, in the spreadsheet, click Extensions > Apps Script.
This sample is maintained by Google with the help of Google Developer Experts.