Building a Service Request System w/ Google Apps Script

Where will the conversation continue?

Stanford Communities of Practice Slack channel #google-apps-script (see URL in notes)

The Digital Media Solutions team at the Graduate School of Business receives dozens of service requests per week for video recording, class capture, tech setups, etc. Fielding requests via email and over the phone let to incomplete requirements gathering. Copying and pasting request details into Google Calendar was susceptible to human error. A year and a half ago we set out to build our own service request system using Google Apps Script.

Notes

Contact:
Feel free to contact me with questions. Or better yet, ask on the Slack channel below! I'll be listening there.
Email: nicholjf@stanford.edu

Links:
Slack channel: https://stanfordcop.slack.com/messages/C8831M9SN/">https://stanfordcop.slack.com/messages/C8831M9SN/
Google Slides presentation: https://goo.gl/LH8L6J

Today our system has been up and running for the past year, and offers the below features (to name a few):
-Field all requests in a Google Form that offers our menu of services
-Form submissions trigger a confirmation email sent to the client and our team
-New requests can be viewed from a dashboard in Google Sheets
-Clients can use a URL in the confirmation email to modify existing requests
-Team members can schedule requests using a custom menu in the Sheets dashboard
-Calendar invites are automatically sent to our team and clients
-Requests are filtered on different tabs in the dashboard (new, modified, scheduled, pending, all)
-Management can easily pull structured data for reports and data visualization