Connect your Google Sheet to Geckoboard

With your Google Sheet prepared, in this article you'll use our Spreadsheets data source to connect it to Geckoboard. Then you can start pulling data directly from your Google Sheet 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.

  1. 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.
  2. You'll see a scrollable list of data sources. Click Google Sheets.
  3. 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. Choose your Google Sheet from your Google Drive
  4. 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.

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.