In this article, you'll use our Spreadsheets data source to connect Geckoboard to your Google Sheet hosted in Google Drive. Then you can start pulling data directly from your Google Sheets and turn it into a range of clear visualizations.
Before you start
If your spreadsheet data has been imported from a third-party service (e.g. Google Analytics, Salesforce, Zendesk, etc.), check if we have a dedicated data source for it. They contain a comprehensive list of widgets with predefined KPIs, making things even easier for you.
Alternatively, if you’re looking for complete control over how your data is displayed, our Datasets API can send data from a database or third-party service to your dashboards.
To connect your Google Sheet to Geckoboard, follow these steps.
- Hover your cursor over an empty area of your dashboard and click the + button.
Alternatively, click Add widget in the top right of your dashboard.
- You'll see a scrollable list of data sources. Click Google Sheets.
- If you haven’t done so already, you'll need create a connection to link your Google Drive account with Geckoboard.
After connecting to your Google Drive account, you may see the message: "there was an error fetching the list of spreadsheets". If so, you need to allow Google Drive permission to share data with Geckoboard.
To do this, open the Google Apps control panel and navigate to
Apps > Google Apps > Settings for Drive, and make sure "Allow users to install Google Drive apps" in the "Data Access" menu is enabled.
From the Choose File menu, search for, and select, the spreadsheet you want to connect to Geckoboard.
- And that’s it! You're now ready to prepare a visualization using your Google Sheet.
If you don't want to share the contents of your Google Drive when connecting your Google Sheet to Geckoboard, one solution is to create a direct download link.