Skip to main content
All CollectionsConnect to pre-built integrations
Connect data to Geckoboard from any source
Connect data to Geckoboard from any source

Explore the methods of bringing data into Geckoboard – using native data sources, a robust API, professional services, or automation tools.

Updated over 4 months 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 bring custom data in, from any source.

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

Anyone

Connect to 90+ pre-built data sources

Developers, anyone with programming experience

Powerful and very flexible option to compile data from in-house systems, databases, third-party tools, or APIs

Developers, anyone with programming experience

Legacy API that requires a specific schema for each widget type; supports Push and Poll methods

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

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

Anyone with command-line experience

Push Bullhorn data to a 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. To start with, we recommend exploring Zapier or Make, as both offer official Geckoboard-built integrations.

Solution

Ideal for

Details

Anyone

No-code automation platform with 6000+ integrations; offers an official Geckoboard integration

Anyone

No-code automation tool with powerful function features, a generous free plan, and an official Geckoboard integration

Anyone

No-code drag-and-drop automation tool that supports complex actions such as combination or calculation of data from multiple sources

Anyone

No-to-low-code and AI automation tool; a great option if you’re using Microsoft applications

Anyone

No-to-low-code automation tool; good option to consider if you’re using native Zoho applications

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

Anyone

Get data into a spreadsheet automatically using built-in import formulas for Google Sheets or Excel

Anyone

An add-on that supports syncing live data from your business systems into Google Sheets and Excel; offers a free plan

Anyone with BigQuery knowledge

Import BigQuery data into a Google Sheet

Anyone

Import Looker Studio data into a Google Sheet

Anyone with API knowledge

Fetch data from any API and pull it into a Google Sheet

Anyone with Apps Script knowledge

Use JavaScript built into your Google Sheets to fetch data from any source, create automations, and much more

Did this answer your question?