Supermetrics is a paid service that enables you to report, monitor and analyze your online marketing metrics in Google Sheets. You can use it to schedule an automatic daily refresh of your data on Google Sheets for use in Geckoboard.
To set up Supermetrics for your Google Sheet, follow these steps:
Install Supermetrics for Google Drive.
When the Supermetrics sidebar opens, choose your data source to log in to.
Log in to your chosen data source and approve permission when prompted.
You need to log in with a user account that has access to your chosen data source. For example, if you choose Google Analytics, you must log in with a Google Account that has Analytics enabled.
You can now start running queries in Google Sheets.