Getting your data onto Geckoboard

Geckoboard integrates with a number of popular services including Google Analytics, Salesforce, Mixpanel, Shopify, Zendesk, Facebook, Twitter, and many more. Each of our pre-built integrations contains a comprehensive list of predefined metrics and visualizations, making things even easier for you to set up.

Our pre-built integrations are by far the easiest way to quickly get your data onto your dashboards, with no coding skills or advanced programming knowledge required to set them up.

Further reading

  • Our case study focuses on a great dashboard built solely on pre-built integrations.

If you don’t see an integration for the service you need or it doesn’t offer the metrics you’re looking for, there are a few other options available to help you create the perfect dashboard.

Get in touch

We also recommend that you submit a request via this form. Our product team reviews these when making decisions about the future of the tools. If you could provide more details of what metrics you’d like to show and how you’d want to visualize this, it would definitely be helpful for the decision-making process.

Tip

In some cases, while we may not have the widget or integration you need, we have a way to achieve what you’re looking for. For example, you can find tips on creating a weather widget or countdown timer here in our Help Center.

There are also some community-built and maintained integrations available in the community forum, such as this one for Calibre.

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

Datasets

Not for you?

This feature requires coding skills and programming knowledge. If you do not have the time or ability to use the Datasets Integration, fast forward to Third-Party Tools to learn about some code-free options to send data to us.

If you have programming experience or a developer available on your team, you may want to use our Datasets Integration to send information to your dashboard. You will need to 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.

If you need to collect data from a Microsoft SQL Server, MySQL, Postgres or SQLite database, you can use our command line app 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.

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.
  • Our Developer Community provides a forum where you can get real-world advice from other datasets pros.

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.

Get started with Geckoboard

Getting to grips with Geckoboard? This article is part of a series introducing you to all the ways that Geckoboard can help you broadcast live business metrics, KPIs and goals to your team in an easy-to-understand way.

Was this article helpful?

Awesome! 👍  Thanks so much for your feedback!