Change Google Calendar notification sound on iPhone 16e

How do I change the Google Calendar notification sound on iPhone 16e? None of the webpages I'm finding by doing a Google search have the right answer (maybe for older iPhones?). I'd like to have different notification sounds for my work Google Calendar and my personal Google Calendar, if that's possible.