Connect your Google Sheet to Geckoboard

Steps to pull data from a Google Sheet stored in Google Drive.

Updated over a week ago
  1. Click + Add widget and select either Spreadsheets or Google Sheets from the data sources list.

  2. From the Select a data source panel, hover over Google Drive and click Connect.

  3. In the pop-up window you'll need authorize the connection to Geckoboard.

  4. Once this is done you’ll see a list of spreadsheet files you can select to build your dashboard.

  5. If you have spreadsheets saved across multiple Google Drive accounts or users that you’d like to connect to your dashboard, click + Add account after selecting Google Drive from the Choose file panel.

    Add additional Google Drive accounts to Geckoboard

To learn how to create spreadsheet widgets powered by your Sheets file, select from the following visualization types:

There was an error fetching the list of spreadsheets

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 enable Allow users to install Google Drive apps.

Keeping your connected sheets files private

Connecting your Google Drive account to Geckoboard can indirectly give access to anyone else invited to your Geckoboard account. When there are spreadsheets on your Google Drive you don't want to share you can create a direct download link for your connected sheet.

Did this answer your question?