Replace automatically new GCP service account key in Metabase

Hello Metabase community,
I'm seeking guidance on automating the retrieval of a newly generated service account private key stored in GCP's Secret manager, with the aim of seamlessly updating it in Metabase to replace the existing one. As a newcomer to Metabase, I'm wondering:

  1. Has anyone encountered a similar use-case before?
  2. Can this task be accomplished using Metabase's API? If so, which endpoint should I utilize?
  3. Are there alternative solutions to address this challenge?

Any assistance or insights you can provide would be immensely appreciated. Thank you in advance! :pray: