Reclaim Your Evenings.
Select your technical comfort level below. Choose "Track A" for instant templates, or "Track B" for raw code.
Customize For Your Role:
Engine 1: Rapid Feedback
Assessment & Marking
Type a short code (like #sci) into your sheet and watch it instantly expand into a full, personalized rubric paragraph.
Step-by-Step Setup
1. Get the Tool: Click the blue button above to copy the template to your Drive.
2. Test It Out: In Column B, type exactly #sp and press Enter. Watch the text change!
3. Customize for Your School: Click Extensions > Apps Script. Look at the code and change "Excellent spelling." to match your own curriculum rubric. Click Save.
Engine 2: Master Sync
Data Management
Create an unbreakable pipeline that automatically pulls live grades from teacher markbooks into one master dashboard.
Step-by-Step Setup
1. Connect the Plumbing: Open the Teacher Markbook. Copy the long string of letters/numbers in the URL (The ID).
2. Fuel the Engine: Open the HOD Dashboard. Click Cell A1. Paste that Teacher ID exactly where it says "FILE_ID_HERE" in the formula.
3. Authorize: Hover over Cell A1 and click the blue "Allow Access" button. The data will instantly flow through!
Engine 3: 1-Click Updates
Parent Communication
Send 30 personalized progress update emails directly to parents with a single click from a custom spreadsheet menu.
Step-by-Step Setup
1. Prepare the Data: Add a test email address (yours) into the Email column.
2. Fire the Engine: Look at the top menu bar in Google Sheets. Click ⚡ Automations > Send Parent Updates.
3. Don't Panic! A Google "Authorization Required" popup will appear. Click Continue > Choose your account > Click 'Advanced' > Click 'Go to script (unsafe)' > Allow. Run the menu button one more time!
*Level Up (WOW Factor):* Go to Extensions > Apps Script. Click the ⏰ Clock icon on the left to set this script to run automatically every Friday at 4 PM!
Engine 4: Auto-Reports
Certification & Reporting
Submit a quick Google Form and watch it instantly generate a styled, personalized PDF certificate in your Drive.
Step-by-Step Setup
1. Link the Doc: Open the Google Doc Template. Copy its URL ID. Open the Google Sheet > Extensions > Apps Script, and paste that ID at the very top of the code.
2. Set the Trigger: In Apps Script, click the ⏰ Clock icon. Add a trigger: Event Source = 'From spreadsheet', Event Type = 'On form submit'. Save and Authorize.
3. Test it: Fill out the live Google Form. Open your Google Drive folder and wait 10 seconds. The PDF will magically appear!
Meet Your Automation Co-Pilot 🤖
Want to build something entirely custom for your specific role? Don't write the code yourself—manage the coder. Talk to our custom-trained AI assistant.
Launch the School Automation Architect