Getting your data onto Geckoboard

Geckoboard's 60+ data sources pull in data from your everyday tools. You can also connect your own data via Spreadsheets, Databases, and our Datasets API.

Add data tracked in a Google Sheet or Excel file to your dashboard.

Connect your PostgreSQL, MySQL and Redshift SQL database to your Geckoboard account, enabling you to set up widgets which query that database regularly.

Send any other data from in-house systems and third party tools with this flexible solution for developers.

Spreadsheets

A great solution for simple metrics is to transfer them into a Google Sheet or Excel spreadsheet, which you can then use with our Spreadsheets integration to build visualizations on your dashboard.

Google Sheets has import functions that you can use to pull data into your spreadsheet from a variety of sources including XML, HTML, RSS and CSV - perfect for importing lists of blog posts, tweaks, product inventories or data from another source.

Additionally, tools such as the Google Analytics Spreadsheet Add-on , Zapier and Supermetrics can be used to automatically send or import data to your sheet from other services

Using a spreadsheet also allows you to perform calculations or combinations with your data. You can take a look at some of the functions you might want to use here

Databases

Our Database integration connects your PostgreSQL, MySQL and Redshift SQL database to your Geckoboard account, enabling you to set up widgets which query that database regularly. We currently support PostgreSQL and Redshift.

Tip

If you need to collect data from a MSSQL or SQLite database, you can use our command line app (SQL-Dataset) for this. This allows you to map a SQL query to a dataset, then automatically collect the data you need and send it on to us. It requires you to complete a simple configuration file and run the app on your own computer.

You don't need coding experience to use the Database integration. You just need the database details and a query. We only allow users to connect as a read-only database user and we restrict queries to only allow SELECT queries, so there’s little danger of breaking anything.

Datasets API

Our Datasets API is designed for anyone who’s comfortable creating custom-coded solutions or integrating with APIs. A dataset is particularly useful when you have specific sets of data that you want to display on a dashboard that can’t be accessed by the integrations Geckoboard currently support.

It’s also helpful if you want to get data from your own internal systems, or if you need to extend the functionality of one of our pre-built integrations.

You'll write a script/application that authenticates and connects to the API of the desired product and requests the data. You can then reformat this data as needed and 'push' it to our Rest API as a dataset. We have libraries for Node.js, Python, Ruby and cURL but you can use any programming language for this.

While the Dataset is updated via the API, the widgets are configured via the same user interface as other widgets. This means that, if necessary, the more technical aspects may be delegated or outsourced.

The same Dataset can be used to power widgets on multiple dashboards or with a number of different visualizations. When an update is received via the API, all the widgets powered by that dataset are then updated automatically. Geckoboard can also handle data aggregation and grouping for datasets, so there’s no need to pre-aggregate your data.

Datasets give you full control over our most popular visualizations and allow you to decide how your data is displayed, making them our most flexible and advanced tools for data visualization.

Further reading

  • Our developer documentation will help you learn how to use the API to send data to Geckoboard.
  • Our guide to building the visualizations powered by the API.

Third-Party Tools

While we don’t offer development as a service, it is also possible to use some third party tools to send data directly to Geckoboard or request a custom integration.

If you’d like someone else to take care of building an integration with the specific metrics and sources that you need, we have a partnership with Saasler. They can create a custom integration to collect data from another service and send it to a Geckoboard dataset, with no additional work required by you. You can see information and pricing for this in this PDF document.

If you're not looking for something custom but don’t have the coding expertise or time needed to build your own app for our datasets integration, another option is Parabola. Their drag-and-drop interface can be used to collect and combine many different sources of data, including Smartsheets, Twilio and Airtable. You can also automatically clean, filter, group, and manipulate your data before sending it on to Geckoboard as a dataset. You can read about connecting to Parabola here.

Tip

If you skipped over the section on Spreadsheets, you may wish to revisit it now to take a look at third-party tools that you can use to send data to a Google Sheet. The sheet can then be used to power your widgets.

Finally, as well as using Zapier with spreadsheets, it can also be used to send some types of data directly to your dashboard via a Text, Number or Geck-o-meter custom widget. You can learn more about setting up a widget using Zapier here.

Important note

Custom Widgets are marked as a legacy option. We are not intending to remove these from Geckoboard in the near future, but are focused on creating a better experience for our API via the Datasets Integration. All future updates will be to this, rather than to Custom Widgets.

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

    Heather

    USA