Connect your Google Sheet to Geckoboard

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.

  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.

    Tip

    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.

Note

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.

We're ready to help, 24 hours a day, 5 days a week

Get support
  • Fernanda Customer Success Avatar

    Megan

    USA
  • Hariharan Customer Success Avatar

    Hariharan

    India
  • Fernanda Customer Success Avatar

    Yasmin

    Spain
  • Luis Customer Success Avatar

    Luis

    UK
  • Richard Customer Success Avatar

    Richard

    UK
  • Fernanda Customer Success Avatar

    Fernanda

    Brazil
  • Heather Customer Success Avatar

    Kirby

    USA
  • Heather Customer Success Avatar

    Heather

    USA