Geckoboard

Richard Ingram

Kelsey Milner

Pull in data from Google Sheets and Excel spreadsheets.

Connect your spreadsheets

Parepare your spreadsheet for Geckoboard by importing data to it, formatting it, performing calculations and reducing errors.

Optimize your spreadsheet for Geckoboard

Using Google Sheets' query functions you can make all your spreadsheet calculations and aggregations before connecting to Geckoboard.

Calculating spreadsheet data for Geckoboard

By linking GA to your Adwords and AdSense accounts you pair a GA add-on with Spreadsheets to aggregate or manipulate your data.

Aggregate Google Adwords and AdSense data in Geckoboard

Use Supermetrics to schedule an automatic daily refresh of your data on Google Sheets for use in Geckoboard.

Automatically refresh your Google Sheets data daily with Supermetrics

Geckoboard doesn’t support any sort of modification or calculation of your data, so any changes must be done outside of Geckoboard first.

Why we don't support calculations or aggregated data using Spreadsheets

You can set your own refresh interval by writing a script using Google Apps Script Editor.

Set refresh rate for spreadsheets widgets powered by import functions

Prepare your spreadsheet

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

Connect your Google Sheet to Geckoboard

Steps to pull data from Excel files stored on Google Drive.

Connect your Excel spreadsheet from Google Drive

Steps to pull data from Excel files stored on Dropbox.

Connect your Excel spreadsheet from Dropbox

Steps to pull data from Excel files stored on OneDrive personal and business.

Connect your Excel file from OneDrive

Steps to pull data from Excel files stored on SharePoint.

Connect your Excel spreadsheet from SharePoint

Steps to access the sharing links for popular cloud services.

Create share links for connecting single spreadsheet files to Geckoboard

To pull data from an Excel file hosted on a local machine, you'll need to upload to a cloud storage platform.

Connect your Excel spreadsheet stored on a local machine

When there are spreadsheets in your Google Drive you don't want to share you can create a direct download link for your connected sheet.

Make your connected Google Sheet private

Useful for doing simple aggregations directly within your dashboard.

Send Data from Google Sheets using Datasets to calculate metrics and build visuals

Connect your spreadsheet

Learn how to adjust presentation options and filter your spreadsheets data to create easy-to-understand visualizations.

Customize spreadsheets widgets

Create a script that calls Matomo API and imports data in Google Spreadsheets, before connecting it to Geckoboard.

Create spreadsheet widgets from Matomo data

Learn about the various configuration options available when creating gauge widgets from your spreadsheet data.

Create gauge widgets from spreadsheets

Learn about the various configuration options available when creating line chart widgets from your spreadsheet data.

Create line chart widgets from spreadsheets

Learn about the various configuration options available when creating number widgets from your spreadsheet data.

Create number widgets from spreadsheets

Learn about the various configuration options available when creating column chart widgets from your spreadsheet data.

Create column chart widgets from spreadsheets

Learn about the various configuration options available when creating bar chart widgets from your spreadsheet data.

Create bar chart widgets from spreadsheets

Learn about the various configuration options available when creating leaderboard widgets from your spreadsheet data.

Create leaderboard widgets from spreadsheets

Learn about the various configuration options available when creating table widgets from your spreadsheet data.

Create table widgets from spreadsheets

Create text widgets from spreadsheets

Including pre-populated cells in your cell selection means your spreadsheet widgets will automatically respond as data is added.

Create dynamic spreadsheet widgets

Compare your selected spreadsheet cell with a choice of four comparison visualizations: goal, number, percentage, and sparkline.

Compare two numbers in your spreadsheet

Pivot tables cannot be automatically read from Google Sheets in Geckoboard. Use ImportRange to copy the pivot table in a new sheet.

Display data from pivot tables in Geckoboard

Learn how to add multiple series of data to line and column charts using data from spreadsheets.

Create multiple series charts using spreadsheets

Goals are shown as progress bars on number widgets and shaded areas on line, column and bar charts.

Add goals to track progress on your spreadsheet data

Add status indicators to number and gauge widgets to spot important changes to your spreadsheet data.

Highlight important changes to your spreadsheet data

Learn how to build a widget displaying a countdown number.

Create a event countdown Number widget

Build a table widget displaying milestones from a Google Sheet or Excel file.

Add milestones to a table widget

Steps to build a table widget with conditional color-based Emoji.

Highlight table widget cells in spreadsheets using Emoji

Collect user-generated data, like quick polls to full-on questionnaires, and display it on a dashboard.

Use Google Forms to collect information and display it on a dashboard

Steps to display a daily inspirational quote on your dashboard using our Spreadsheets data source.

Display a 'quote of the day' text widget using spreadsheets

Guidance for how to take a data dump and use formulas in a new sheet to build visualizations.

How to build visualizations from data dumps

Widgets refresh every 15 mins, except when powered by a Google Sheet where it's within 3 mins from the sheet's last update.

Refresh rate for Spreadsheet widgets

Steps to refresh your Spreadsheet widget while you're building and editing it.

Manually refresh Spreadsheets widgets

Learn how the ImportData function pairs with our Spreadsheet data source to build visualizations from CSV files.

Use Google Sheets’ ImportData function to display online data in Geckoboard

Learn how the ImportHTML function imports data from a table or list within a website into a Google Sheet.

Use Google Sheets’ ImportHTML function to display data in Geckoboard

Learn how Google Sheets' ImportRange function helps import data samples and run calculations in a separate sheet from the source.

Use ImportRange to extract data needed for Geckoboard to a new spreadsheet

Learn how the GoogleFinance function pairs with our Spreadsheets data source to display market data on your Geckoboard dashboard.

Use Google Sheets’ GoogleFinance function to display data in Geckoboard

Steps to build a widget displaying temperature and weather using weatherstack data.

Create a weather widget using Google Sheets

Build widgets from spreadsheets

Check if your file is saved in a different format from .xlsx.

Excel spreadsheet file not showing in Geckoboard

Check that your share settings are set correctly and if you have the right type of sharing link.

Spreadsheet FetchError: 'Could not find spreadsheet file'

Check if "Allow users to install Google Drive apps" in the "Data Access" menu is enabled.

Spreadsheets error: 'Error fetching the list of spreadsheets'

Steps to avoid hitting the 5MB file size limit for connected spreadsheets.

Spreadsheet import error: 'This worksheet is too large to import'

This might be due to your changes occurring in-between refreshes, or your uploaded file failed to overwrite an older version.

Connected Excel spreadsheet not updating after making changes

Files in your Google Drive Trash folder are still, in effect, regarded as active documents until emptied.

Deleted spreadsheet on Google Drive still powering widgets

This error will occur if you only have one row of data to select from.

Spreadsheets error: 'Cannot read property "offsetWidth" of undefined'

This often occurs when X-Axis dates are being calculated by a formula, or when they're sourced from another sheet.

Connect your spreadsheets

Prepare your spreadsheet

Connect your spreadsheet

Build widgets from spreadsheets

Spreadsheets troubleshooting