How do you prevent having to change google api credentials?

[Sean0203]

So I'm exporting my transactions every hour to a google sheets document with gh actions, but every week they start failing. Upon initial research, it seems that in test mode, Google's API credentials expire after a week. To anybody using the Google sheets method for Mintable, what do you do so you don't have to replace credentials every week? Does taking the project out of test mode bring any security issues?