Geckoboard integrates with a number of popular services including Google Analytics, Salesforce, Mixpanel, Intercom, Zendesk, Facebook, Twitter, and many more. These pre-built integrations contain a comprehensive list of predefined metrics and visualizations, making them by far the easiest way to quickly get your data onto your dashboards.
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.
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.
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.
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
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 are PostgreSQL and Redshift.
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.
Not for you?
This feature requires coding skills and programming knowledge. If you don't 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.
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.
- 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.
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.
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.
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.