Go to Geckoboard
All Collections
Connect your own data
Connect your own data
Pull in additional data using spreadsheets, databases, Zapier integrations and our custom API.
87 articles in this collection
Written by
Richard Ingram,
Anna-Lisa Gailey,
and
Kelsey Milner
Databases
Connect your SQL database to Geckoboard using Databases
Connect to your MySQL/MariaDB, PostgreSQL, Redshift, Snowflake and MSSQL databases in seconds.
Written by
Richard Ingram
Updated over a week ago
Create visualizations from SQL queries
Written by
Richard Ingram
Updated over a week ago
Troubleshoot SQL database connections
Steps to solve issues connecting your SQL database to Geckoboard.
Written by
Richard Ingram
Updated over a week ago
MariaDB: 'database connection failed'
Steps to avoid running into a Database connection failed error.
Written by
Richard Ingram
Updated over a week ago
Display boolean values on Database widgets
A workaround that converts the boolean into a string using the CASE statement.
Written by
Richard Ingram
Updated over a week ago
More ways to get data from your database
Why you might use SQL-Datasets, Supermetrics and Parabola over our Databases data source.
Written by
Richard Ingram
Updated over a week ago
Datasets API
Pre-built collection for testing Datasets API and Custom Widgets
Collection enables you to test these methods without writing your own code, or for reference if your own code shows errors.
Written by
Anna-Lisa Gailey
Updated over a week ago
Exceeding SQL-Datasets rate limit after 30 requests per minute
Datasets API allows for 60 requests per minute, but SQL-Datasets restrictions you to 30 requests per minute.
Written by
Richard Ingram
Updated over a week ago
Create a new dataset in Geckoboard
How to create a new dataset with defined schema fields.
Written by
Richard Ingram
Updated over a week ago
Customize Datasets widgets
Learn how to adjust presentation options and filter your Datasets data to create easy-to-understand visualizations.
Written by
Richard Ingram
Updated over a week ago
Build a temperature dashboard using Python
Steps to display your office’s climate on your TV dashboard.
Written by
Richard Ingram
Updated over a week ago
Spreadsheets: prepare your spreadsheet
Optimize your spreadsheet for Geckoboard
Parepare your spreadsheet for Geckoboard by importing data to it, formatting it, performing calculations and reducing errors.
Written by
Richard Ingram
Updated over a week ago
Aggregate Google Adwords and AdSense data in Geckoboard
By linking GA to your Adwords and AdSense accounts you pair a GA add-on with Spreadsheets to aggregate or manipulate your data.
Written by
Richard Ingram
Updated over a week ago
Automatically refresh your Google Sheets data daily with Supermetrics
Use Supermetrics to schedule an automatic daily refresh of your data on Google Sheets for use in Geckoboard.
Written by
Richard Ingram
Updated over a week ago
Why we don't support calculations or aggregated data using Spreadsheets
Geckoboard doesn’t support any sort of modification or calculation of your data, so any changes must be done outside of Geckoboard first.
Written by
Richard Ingram
Updated over a week ago
Set refresh rate for spreadsheets widgets powered by import functions
You can set your own refresh interval by writing a script using Google Apps Script Editor.
Written by
Richard Ingram
Updated over a week ago
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Written by
Richard Ingram
Updated over a week ago
Create text widgets from spreadsheets
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Written by
Richard Ingram
Updated over a week ago
Zapier and Geckoboard
Use Zapier to post new data to datasets created in Geckoboard
Learn how pairing Zapier can automatically post new data to a dataset linked to a dashboard widget.
Written by
Richard Ingram
Updated over a week ago
Display monday.com project metrics in Geckoboard using Zapier
Steps to pair Zapier with datasets to display monday.com project metrics on dashboard widgets.
Written by
Richard Ingram
Updated over a week ago
Display Typeform survey metrics in Geckoboard using Zapier
Steps to pair Zapier with datasets to display Typeform survey metrics on dashboard widgets.
Written by
Richard Ingram
Updated over a week ago
Make (Integromat) and Geckoboard
Track more metrics using Make (Integromat) with Geckoboard
Learn how to use the Geckoboard app in Make to create scenarios.
Written by
Richard Ingram
Updated over a week ago
Use Make (Integromat) to post new data to datasets created in Geckoboard
Steps to create a scenario that automatically posts new data to a dataset linked to a dashboard widget.
Written by
Richard Ingram
Updated over a week ago
Parabola and Geckoboard
Track more metrics using Parabola with Geckoboard
Learn how pairing Parabola and datasets can fetch data from data sources not currently supported in Geckoboard.
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.
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.
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.
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.
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.
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.
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.
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.
Written by
Richard Ingram
Updated over a week ago
Custom Widget polling timeout error
Steps to take if your Custom Widget times out.
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.
Written by
Richard Ingram
Updated over a week ago