GTK Timetable Builder

Connect your school's private database to get started.

1

Get Your Database Template

Click Here to duplicate the Master Template to your own Google Drive. It's completely free and private.

2

Deploy Your Backend

In your new Google Sheet, go to Extensions > Apps Script. Click Deploy > New Deployment (Web App), set access to 'Anyone', and copy the Web App URL.

Step 3: Paste URL to Connect

School Portal

Database Connected

Invalid Credentials!

ADMIN CONSOLE

System Ready

Add / Drop Staff Workload

Current Active Master Ledger

TeacherActivityClassPeriodsCT?Action

Active Custom Rules

TypeTargetConditionParameterPriorityAction

Grid Matrix Empty. Hit Process Engine.

Configure Exam and hit Generate.

Mark Absent Teachers

Select absentees and hit Generate.

Active Credentials Directory

STAFF PORTAL

Welcome, Staff

Unavailability Matrix

Click cells below to mark them as UNAVAILABLE (Max 3).

Selected: 0 / 3
Day 1234 5678

Your Allotted Workload

Workload Optimizer Audit

Override Grid Cell