@redtailfanschool In this video, we demonstrate how we used Gemini by crafting a prompt outlining how we wanted the scripts to a) create a new document for each student, b) append each student document with a table of data that is a new assignment list, and c) a script that will archive each assignment on the teacher sheet as a record of what each assignment was.

Here is the prompt we used to create this set of scripts using Gemini or ChatGPT. https://docs.google.com/document/d/1k0BoirC-F1lyE-SHliS-ZUcPjHeJUQKUgxuj1Sn27v0/edit?usp=sharing