If your school is using Google to sign into OverDrive and/or the Sora app, only your school-assigned Gmail address will work. Your personal Gmail address will not work.
If you're trying to log into Sora but you're seeing a Google login screen instead, it could be that there is a problem with your school account itself, and not necessarily Sora.
If these steps do not work or you still need help: