Connect your own data

Pull in additional data using spreadsheets, databases, Zapier integrations and our custom API.

Richard Ingram avatar Anna-Lisa Gailey avatar Kelsey Milner avatar
87 articles in this collection
Written by Richard Ingram, Anna-Lisa Gailey, and Kelsey Milner
Spreadsheets: connect your spreadsheet

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

Useful for doing simple aggregations directly within your dashboard.
Kelsey Milner avatar
Written by Kelsey Milner
Updated over a week ago

Connect your Google Sheet to Geckoboard

Steps to pull data from a Google Sheet stored in Google Drive.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Connect your Excel spreadsheet from Google Drive

Steps to pull data from Excel files stored on Google Drive.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Connect your Excel spreadsheet from Dropbox

Steps to pull data from Excel files stored on Dropbox.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Connect your Excel file from OneDrive for Business

Steps to connect directly to OneDrive for Business to access your data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Connect your Excel file from a OneDrive personal account

Steps to pull data from Excel files stored on a OneDrive personal account.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Connect your Excel spreadsheet from Sharepoint

Steps to pull data from Excel files stored on Sharepoint.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Connect your Excel Spreadsheet stored locally

Steps to pull data from Excel files stored on your local computer.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Make your connected Google Sheet private

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.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago
Spreadsheets: build widgets from spreadsheets

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

Collect user-generated data, like quick polls to full-on questionnaires, and display it on a dashboard.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Customize spreadsheets widgets

Learn how to adjust presentation options and filter your spreadsheets data to create easy-to-understand visualizations.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create number widgets from spreadsheets

Learn about the various configuration options available when creating number widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create gauge widgets from spreadsheets

Learn about the various configuration options available when creating gauge widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create line chart widgets from spreadsheets

Learn about the various configuration options available when creating line chart widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create column chart widgets from spreadsheets

Learn about the various configuration options available when creating column chart widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create bar chart widgets from spreadsheets

Learn about the various configuration options available when creating bar chart widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create leaderboard widgets from spreadsheets

Learn about the various configuration options available when creating leaderboard widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create table widgets from spreadsheets

Learn about the various configuration options available when creating table widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create text widgets from spreadsheets

Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create dynamic spreadsheet widgets

Including pre-populated cells in your cell selection means your spreadsheet widgets will automatically respond as data is added.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Compare two numbers in your spreadsheet

Compare your selected spreadsheet cell with a choice of four comparison visualizations: goal, number, percentage, and sparkline.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Display data from pivot tables in Geckoboard

Learn how to retrieve pivot table data by using ImportRange to reproduce the pivot table in a new Google sheet.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create multiple series charts using spreadsheets

Learn how to add multiple series of data to line and column charts using data from spreadsheets.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Add goals to track progress on your spreadsheet data

Goals are shown as progress bars on number widgets and shaded areas on line, column and bar charts.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Highlight important changes to your spreadsheet data

Add status indicators to number and gauge widgets to spot important changes to your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create a event countdown Number widget

Learn how to build a widget displaying a countdown number.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Add milestones to a table widget

Build a table widget displaying milestones from a Google Sheet or Excel file.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Highlight table widget cells in spreadsheets using Emoji

Steps to build a table widget with conditional color-based Emoji.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

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

Steps to display a daily inspirational quote on your dashboard using our Spreadsheets data source.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

How to build visualizations from data dumps

Guidance for how to take a data dump and use formulas in a new sheet to build visualizations.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Refresh rate for Spreadsheet widgets

Widgets refresh every 15 mins, except when powered by a Google Sheet where it's within 3 mins from the sheet's last update.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Manually refresh Spreadsheets widgets

Steps to refresh your Spreadsheet widget while you're building and editing it.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

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

Learn how the ImportData function pairs with our Spreadsheet data source to build visualizations from CSV files.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Use Google Sheets’ ImportHTML function to display data in Geckoboard

Learn how the ImportHTML function imports data from a table or list within a website into a Google Sheet.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Use Google Sheets’ GoogleFinance function to display data in Geckoboard

Learn how the GoogleFinance function pairs with our Spreadsheets data source to display market data on your Geckoboard dashboard.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Use Google Sheets’ ImportRange function to display data in Geckoboard

Learn how the ImportRange function helps you import data samples and run calculations in a separate sheet from the source.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create a weather widget using Google Sheets

Steps to build a widget displaying temperature and weather using weatherstack data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago
Spreadsheets: troubleshooting

Excel spreadsheet file not showing in Geckoboard

Check if your file is saved in a different format from .xlsx.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Excel file not appearing in OneDrive

Check that your file is listed in the main OneDrive folder. Files placed within additional folders might not display.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Spreadsheet FetchError: 'Could not find spreadsheet file'

Check if your share settings are set correctly and if you have the right type of link.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Spreadsheets error: 'Error fetching the list of spreadsheets'

Check if "Allow users to install Google Drive apps" in the "Data Access" menu is enabled.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

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

Steps to avoid hitting the 5MB file size limit for connected spreadsheets.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Connected Excel spreadsheet not updating after making changes

This might be due to your changes occurring in-between refreshes, or your uploaded file failed to overwrite an older version.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Deleted spreadsheet on Google Drive still powering widgets

Files in your Google Drive Trash folder are still, in effect, regarded as active documents until emptied.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

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

This error will occur if you only have one row of data to select from.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Pivot table sheet is empty

You'll need to use ImportRange to reproduce the pivot table in a new sheet.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

X-Axis dates not display correctly on charts

This often occurs when X-Axis dates are being calculated by a formula, or when they're sourced from another sheet.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago
Dashboard tools

Use the Text widget to display text on your dashboard

Text widgets are flexible enough to accept HTML tags, including clickable links and font size adjustments.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Add images using the image widget

Display an uploaded image, with instructions on how to host images in Dropbox and Google Drive.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Display customer satisfaction scores using Image widgets

Learn how pairing our Image widget with tools like PagePixels can schedule screenshots of your ratings.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Display a QR code on your dashboard using Dropbox

Steps to build a QR Code widget that generates a QR code from a URL.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Use the clock widget to display the time and date on a dashboard

Clock widget displays the current time and date in either 12 or 24 hour format, using your local computer's clock as a reference.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Build a dashboard using data from a CSV file

Learn the key concepts of how to structure your data and push it to Geckoboard using CSV widgets.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Add an RSS/Atom Feed widget to your dashboard

Our RSS/Atom Feed widget displays items from an RSS or Atom feed as a list.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Display Google Alerts on a RSS/Atom Feed widget

Steps to create a Google Alert and display updates on a RSS/Atom Feed widget.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago
Custom widgets

Guide to using Custom Widgets

How to get data from an external API into Geckoboard.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Push to Custom Widgets from a Google Sheet

Steps to use a Google Sheets script that pulls data from a sheet, before pushing the data to a Custom Widget.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Guide to using Custom Widgets with Excel

Steps to build a custom pie chart and geo mapping widget.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Guide to Custom Widgets using Node.js

Learn how to use Node.js to get data from a datasource into your Custom Widgets.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Use a Dropbox URL as a data source for Custom Widgets

Upload your JSON file to Dropbox to use the created link with your Custom Widget.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Node.js module for Push method widgets

Learn about Gekoq, a Node.js module that simplifies sending data to your Geckoboard Push method Custom Widgets.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Template for building custom integrations in Node.js

Learn about Gekkota and how it can help build a custom integration for Geckoboard's custom Push method widgets.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Custom Widgets error: 'widget does not exist'

Learn why you might see this error message when pushing data onto Geckoboard.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Custom Widget polling timeout error

Steps to take if your Custom Widget times out.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Highcharts error: 'Chart data could not be parsed'

Learn why you may be seeing this error message when using Highcharts.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago