Stop Doing It Manually: Free Automation Tools Every Educator Needs

27 Jan 2027
SOUTH 330B
Classroom Leaders
What if you could automate the repetitive tasks that eat up your evenings and weekends, for free, using tools your school already pays for? In this session, a Spanish teacher with no formal coding background shows how to use Google Apps Script, built into Google Workspace at no cost, to automate the workflows that steal your time. From behavior tracking to parent notifications to personalized student feedback, every automation demonstrated is running at a K-8 school right now. No coding experience is required: AI writes the script, and you paste and run it. Learn how to spot repetitive tasks in your own practice, open Google Apps Script or Microsoft Office Scripts, use plain English to have AI generate working code, set up triggers that run on form submission or a schedule, and test and deploy a live automation. Build your first one, a form that automatically emails a confirmation to the submitter, and leave with a working script on your own Google Sheet or Excel file plus commented copies of every script demonstrated.
Speakers
Gerardo Gancz
Gerardo Gancz, Educator & Workflow Designer - Allegiance STEAM Academy

Access Type

Session or Session+ or All-Access Registration Permitted

Content Topic

Emerging Technology (blockchain/web 3.0/metaverse/etc)

Curriculum Area

Emerging Technology (AI/AR/VR/XR/MR/3D Printing/Metaverse/etc.)

Session Type

Concurrent Session

Education Challenges

Community & Family Communication

EdTech Product

Educator Curriculum & Instructional Technology,Information Technology,Student Support Technology