Bring It All Together: Create Your Own Google Sheets Automation

Lauren Boucher
Presenter
60
mins
Course length
Multi Device
Access from mobile or laptop
4.86
Course rating
An adult and a child sitting at a table, working together on homework with notebooks and a smartphone nearby.
A sequence of black and white geometric shapes alternating between quarter circles and half circles arranged in a horizontal line.

Description

How would it feel to have a Google Sheet that automates your most time-consuming classroom tasks? With Google Apps Script and AI, you can build a spreadsheet tool tailored to your classroom's needs—whether it is an automated grade tracker, student feedback generator, or attendance manager. Join Lauren Boucher for this hands-on, interactive workshop where you will create a fully functional, time-saving automation that works for you, from start to finish, that will streamline your daily teaching tasks. Get ready to harness the power of Google Apps Script to build a custom AI-assisted spreadsheet tool tailored to your classroom! Lauren's expertise in digital teaching and learning will provide you with tools and resources to design and build a fully functional AI-powered automation tool in Google Sheets so you can focus more on teaching and less on managing data!

Objectives

Recall how Google Apps Script and AI can assist with automating classroom tasks. Understand how to design and implement custom automation scripts using Google Apps Script. Apply AI and Google Apps Script to create automation tools like grade trackers or attendance managers. Analyze how automation can simplify and improve classroom management processes. Evaluate the effectiveness and efficiency of AI-powered Google Sheets tools in the classroom. Design and build a fully functional AI-powered automation tool in Google Sheets tailored to your classroom needs.

Key Take Aways

• Learn how to create an automated grade tracker that updates with ease. • Discover how to build a student feedback generator that creates personalized comments. • Understand how to automate attendance tracking to save time each day. • Gain practical knowledge to write your first AI-powered Google Apps Script and implement it in your classroom.

Start your 7-day free trial today and explore this course at no cost.

Continue your learning with full access to our library of 1000+ courses, learning pathways and microcredentials to support your growth.

Meet

Lauren Boucher

Lauren Boucher has 18+ years in public education, teaching 3rd grade, gifted K-8, and working as a Digital Teaching and Learning Coach. Now a Southeast Regional Consultant for the NC Department of Public Instruction, she shares innovative ed tech practices nationwide.
Specializes In:
Digital Teaching & Learning Consultant

Over 1,000 courses. 40+ topics. Unlimited potential.

The most comprehensive professional learning library available — designed to grow with you.
Arrow-icon-left
Arrow-icon-right

Ready to grow?

Unlock new strategies and skills—wherever you are in your teaching journey.

A teacher with curly hair and glasses shows a glowing light bulb to a group of smiling children gathered around a table.