Connect your own data to 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. Also available on our free plan.

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

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

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-Datasets) 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

Integromat recommended

We have a partnership with Integromat, an automation platform that can pull data from services we don't have a pre-built integration for into Geckoboard. The Geckoboard app on Integromat's platform integrates with our Datasets API so you can send custom data to your dashboard with no coding required. See our article on how to use Integromat with Geckoboard.

Integromat offer a generous free plan that doesn't require billing information to on sign up. See their list of integrations for more details.

Parabola

If you don’t have the coding expertise or time needed to build your own app for our Datasets API, 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.

Saasler

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.

Zapier

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 Gauge custom widget. You can learn more about setting up a widget using Zapier here.

Pabbly Connect

Like Zapier, Pabbly Connect have an integration with Geckoboard that allows you to send data directly to your dashboard via a Text, Number or Gauge custom widget.

It's important to note that Custom Widgets are a legacy option. While we're 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. All future updates will be to this, rather than to Custom Widgets.

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.

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.