STUDENT CHECKOUT

@homebodyschoolsecretary

1.9K followers · usually 697 views a post

Views

58.0K

Likes

1.7K

Comments

41

Shares

626

SoundTikTok sound · original sound - angelasoverlays

Promoted product

Google Sheets

Gemini in Sheets helps you simplify complex data, reveal insights, and turn data into interactive mini-apps. Try Sheets for work today!

11 videos8 creators

Why it worked

The video addresses a common pain point for school secretaries by offering a practical, DIY solution using accessible tools like Google Sheets and Apps Script. The creator's relatable explanation and clear, step-by-step instructions, combined with a call to action for more detailed guidance in their bio, encourage engagement and sharing.

Summary

The creator demonstrates how to build a student checkout alert system for a school using Google Sheets and Apps Script. The tutorial guides viewers through creating a new spreadsheet, setting up columns, and using Apps Script to trigger alerts, with further instructions available in the creator's bio.

Structure

1Introduction to the problem: lack of intercom system
2Explaining the solution: a Google Sheets and Apps Script system
3Step-by-step guide to creating the spreadsheet

Original caption

share this check out alert system with your favorite front office school secretary, and anyone else who may benefit from this student checkout alert system. Hopefully the algorithm brings you all back to part two of my original post. I know this isn’t the best tutorial, I told yall I’m not techy! 🤣🫠 but check out my bio for the complete set up #frontoffice #schoolsecretary #officelife #officetok #pov

More from @homebodyschoolsecretary

Product placement

Google Drive (ACTS - interface operated, removing it would change what happens in the video), Google Sheets (ACTS - interface operated, removing it would change what happens in the video), Apps Script (ACTS - interface operated, removing it would change what happens in the video), Dell (APPEARS - corner watermark, removing it would not change what happens in the video)

Call to action

check my bio for step by step instructions

On-screen text

STUDENT CHECKOUT Kaleigh Fulford- Checking Out PLEASE SEND TO THE OFFICE ACKNOWLEDGE front office checkout alert system for gym (and more) part what i typed in chat, I told him i have adhd and to make the steps simple and to the point for me Go to Google Sheets. Create a Blank spreadsheet. Name it: Weight Room Checkout Rename the bottom tab to: Alerts In Row 1, type these headings: do this check my bio for step by step instructions. I would still have chat assist you even with my directions this is what the gym, cafeteria, weight room, band room, chorus room, etc will see this is what shows on the school secretaries end. always type in A2, click off the name (any other cell works) and click the send alert button. If you have any questions, feel free to reach out and share with your secretary friends!