The iDashboards Google Sheets connection uses a third party application to sync the data of Google Sheets back to a database. When properly configured the sync application will allow you to sync the data as frequently as every 15 minutes. This will allow your iDashboards application the ability to display the data from your Google Sheets installation.
The document that is available below will walk you through the setup process of the CDATA Sync application.
- CDATA Sync for Google Sheets (http://www.cdata.com/drivers/gsheets/odbc/)
- Google Sheets
- SQL Database (MS SQL Server, Oracle, MySQL)