kevinschaich / mintable

🍃 Automate your personal finances – for free, with no ads, and no data collection.
https://kevinschaich.io/mintable/
MIT License
1.51k stars 198 forks source link

How do you prevent having to change google api credentials? #167

Open Sean0203 opened 1 year ago

Sean0203 commented 1 year ago

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?

bobharris commented 3 months ago

Same here. If I figure it out I'll definitely reply back. Thanks for the initial research.

https://stackoverflow.com/questions/69459141/how-to-fix-google-tokens-expiring-after-seven-days

Going to try just switch to production. I switched, and my current *.jsonc still verified. See how it goes.

*Actually. That might not be the way to go...i got this after a bit. Error 400: invalid_request The out-of-band (OOB) flow has been blocked in order to keep users secure. Follow the Out-of-Band (OOB) flow migration guide linked in the developer docs below to migrate your app to an alternative method. Moved back to testing and it went away.....