Database help

I run a number of events with an ever changing set of data that needs to be updated on a website. This data needs to be updated in a number of different places including wordpress. Currently – I update the information in a google spreadsheet and it updates the information everywhere on every platform.

My issue is that I am using shortcodes to reference specific data from a specific cell in google spreadsheet. Each placeholder on my wordpress site has its own shortcode that references a different cell so that when I update the information in google sheets it updates it across my entire website.

My current issue is the number of API requests I am getting because of this format. Currently if someone loads one of the web pages there is roughly individual API requests for information from a google spreadsheet. When I have 100 people click on that specific page, it quickly adds up to be a LOT of API requests. Google have been very kind so far and hasn’t charged me but I need to find an alternative solution that isn’t labour intensive and allows me to update the information for multiple platforms all from one database.

Google sheets is the best place for me to make these changes as I also don’t have to give back end access to my website to a number of different editors, yet each can currently correct mis-information and update bits as and when.

My question / feature request is:
Is there a way to take information from google sheets and store it in a database on the website that I can reference using short codes throughout the database. The database wouldn’t need to be updated too often, but even if it was once every 5 minutes I’d have WAY less API requests this way as essentially its one API request to update to the database. The placeholders throughout the website would then get all the information from the database via a short code.

If anyone has a better way to do this, I’m all ears! but this is what I’m currently trying to work on to better my workflow.