SystemSerenity

Work / Case study

Apps Script Toolkit

Shipped Shipped September 22, 2026 Google Apps Script

A suite of Google Apps Script automations that replaced manual reporting and scattered tools: KPI and SLA tracking, assessment generation, spend-data import and a team portal.

Request a code walkthrough

Source code is private. Walkthroughs are available on request.

4automations in the suite
10 minKPI refresh interval
5auto-graded Google Forms generated

Business impact

Replaced manual reporting and scattered tools with automations inside the platform the agency is permitted to automate, cutting manual work in KPI reporting, training and finance tracking.

Problem

Operations reporting and staff tools lived in manual spreadsheets and bookmarks, and the carrier-managed Microsoft 365 environment blocks macros and add-ins.

Solution

Delivered focused automations in the Google environment the agency is permitted to automate, cutting manual work in reporting, training and finance tracking.

Results & highlights

  • KPI tracker: computes business-hours SLA metrics (Mon–Fri, 8 AM–6 PM), generates weekly roster rows and refreshes every 10 minutes
  • Assessment generator: builds five auto-graded Google Forms with shuffled choices and per-item feedback
  • Spend tracker: CSV import, formula repair and a custom menu for a multi-source spend workbook
  • Quick-Launch Hub: a web-app portal embedded in the team intranet (v1.2, 2026-09-22)

Competencies demonstrated

  • KPI & SLA reporting: Business-hours SLA metrics (Mon–Fri, 8 AM–6 PM), generated weekly roster rows and a 10-minute refresh.
  • Google Workspace automation: Generates five auto-graded Google Forms with shuffled choices and per-item feedback.
  • Finance operations: CSV import, formula repair and a custom menu for a multi-source spend workbook.
  • Internal tools & web apps: Quick-Launch Hub web-app portal embedded in the team intranet.
  • Working within constraints: The carrier-managed Microsoft 365 environment blocks macros and add-ins, so automation runs in Google Workspace.

Architecture

  1. Google Sheets datarosters, KPIs, spend
  2. Apps Script triggers10-minute refresh
  3. Business-hours mathMon–Fri, 8 AM–6 PM
  4. OutputsKPI dashboards, Forms, team portal
Design-level view. Hostnames, addresses and account details are intentionally omitted.

Open-source companion

business-hours-sla on GitHub: Two Google Sheets custom functions for SLA reporting: business hours elapsed between two timestamps, and the due time for an SLA measured in business hours.

Next: Narrated Training Video Pipeline →