Title: Database help
Last modified: October 1, 2021

---

# Database help

 *  [shiftybusiness](https://wordpress.org/support/users/shiftybusiness/)
 * (@shiftybusiness)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/database-help-8/)
 * 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.

The topic ‘Database help’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer.
   svg)
 * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/)
 * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [shiftybusiness](https://wordpress.org/support/users/shiftybusiness/)
 * Last activity: [4 years, 8 months ago](https://wordpress.org/support/topic/database-help-8/)
 * Status: not resolved