Also came here to say this.

Nuh-uhh! Uni-ball makes an erasable pen?!? I came here to recommend Frixion pens. Uni-Ball Visions were my favorites before I found erasables!

Feel free to DM if you have questions.

I have a master library that I keep the scripts/html in. That way, when I create a new sheet, I can copy a shorter script to create the menus and access the scripts/sidebar html without having to copy all of them to each new sheet.

I created a project in Claude (or Perplexity or ChatGPT as I experiment with other models) with all the scripts and sidebar html files. This allows the AI to keep the larger project in context when writing new scripts to avoid redundancy or conflicting functions.

I’ve got a ton of scripts. The ones I use most pull data from a turn-in Google Form to a unit-tracking Sheet. The other one distributes copies of files to students. I’ve also got some that will find and replace text (for typos/updates to student docs).

I've been using AI to help me code Google Apps Scripts for a little over a year. It's completely changed how I use Google apps with students!