My suggested solution to this presuming the new owner knows how to use glide. If they don’t you might have to train them or you could run into problems.
If you are creating a new school gmail this would be the easiest but if you are giving it to another person the steps are the same. Email is email no matter who it belongs to.
But the sheet will need to be transferred and shared with the new gmail and in the share settings set the new person as owner (But do the owner part last) Just share it for now with editing access.
Log into glide with the new user email, and create a new app and call it a temporary name like (Schoolapp2)
The good thing with glide is that it will recreate the app based on the configuration you have set in sheets and you have to just do some minor adjustment until you get it just right.
After you have gotten your version 2 app set right in the new email with the shared sheet, then you change the name of the original app to something like “OldSchoolapp”, This will release the unique username from being locked by glide.
You can now go into the Version 2 app and rename it to original name that everyone has.
Glide is pretty fast at releasing app names, the name will become available in approximately 20 seconds.
Once you have confirmed that everything is working you can change the owner of the sheet and remove yourself as user.
One other caveat, Make sure you also transfer any files you have and re point any reference to images or links that were pointing to your drive. If the references were outside of your google drive and on the web then those link will still work.
I’ve done this before and it works well, the only downfall is the time it takes to reconfigure the new app but glide makes it easy.