Connect data to Geckoboard from any source | Geckoboard Help Center
Connect data to Geckoboard from any source
Explore how to get data into Geckoboard using native data sources or alternatives for getting data in from unsupported integrations
Updated over 3 weeks ago
Geckoboard offers multiple ways to bring data into your dashboard. Choose from over 90 pre-built data sources, or explore the alternative solutions below to integrate custom data from any source. If the tool you want to get data in from is not officially supported, there are still many ways to get your data into Geckoboard.
Official tools
Beyond our pre-built data sources, Geckoboard has many other official solutions for bringing custom data into your dashboard, including custom integrations for Bullhorn and ServiceTitan. If you’re a developer or have programming experience, we suggest using the Datasets API for the most flexibility.
| Solution | Ideal for | Details |
| Native data sources | Anyone | Connect to 90+ pre-built data sources |
| Datasets API | Developers, anyone with programming experience | Powerful and very flexible option to compile data from in-house systems, databases, third-party tools, or APIs |
| Custom Widgets API | Developers, anyone with programming experience | Legacy API that requires a specific schema for each widget type; supports Push and Poll methods |
| SQL-Dataset | SQL and command line experience necessary | If you’re not using the native Databases source, use this app to send data from Microsoft SQL Server, MySQL, Postgres, and SQLite databases to the Datasets API |
| Google Sheets to Dataset | Anyone | Push data from a Google Sheet to a dataset using our Apps Script; useful for simple aggregations or if you don’t want to link your sheet directly |
| Bullhorn to Dataset | Anyone with command-line experience | Push Bullhorn data to a dataset |
| ServiceTitan to Dataset | Anyone with command-line experience | Push ServiceTitan data to a dataset |
Automation apps
Automation apps allow you to quickly automate repetitive workflow tasks such as data retrieval and transfer to other systems, all with little to no coding or developer help. These tools can help connect data from an unsupported integration to Geckoboard to get your data in. To start with, we recommend exploring Zapier or Make, as both offer official Geckoboard-built integrations.
| Solution | Ideal for | Details |
| Zapier | Anyone | No-code automation platform with 6000+ integrations; offers an official Geckoboard integration |
| Make | Anyone | No-code automation tool with powerful function features, a generous free plan, and an official Geckoboard integration |
| Parabola | Anyone | No-code drag-and-drop automation tool that supports complex actions such as combination or calculation of data from multiple sources |
| Microsoft Power Automate | Anyone | No-to-low-code and AI automation tool; a great option if you’re using Microsoft applications |
| Zoho Flow | Anyone | No-to-low-code automation tool; good option to consider if you’re using native Zoho applications |
| N8N | Anyone | No-code to full-code workflow automation platform for technical teams; offers a self-hosted, no-cost option |
Spreadsheets
If you’re looking for a flexible way to store, organize, and manage your data, or if you need to manipulate your data to create new metrics, Google Sheets and Excel are powerful options. Below are several solutions for automating data collection into spreadsheets using import formulas, add-ons, and Apps Script.
Once you have data in your sheet, follow our guide to prepare it if needed, then use the Spreadsheets data source to create visualizations.
| Solution | Ideal for | Details |
| Google Sheets & Excel import features | Anyone | Get data in a spreadsheet automatically using built-in import formulas for Google Sheets or Excel |
| Coefficient.io add-on | Anyone | An add-on that supports syncing live data from your business systems into Google Sheets and Excel; offers a free plan |
| Data connector for BigQuery | Anyone with BigQuery knowledge | Import BigQuery data into a Google Sheet |
| Data connector for Looker Studio | Anyone | Import Looker Studio data into a Google Sheet |
| Apipheny.io | Anyone with API knowledge | Fetch data from any API and pull it into a Google Sheet |
| Google Sheets Apps Script | Anyone with Apps Script knowledge | Use JavaScript built into your Google Sheets to fetch data from any source, create automations, and much more |