All Collections
Pair with task automation tools
Zapier and Geckoboard
Use Zapier to post new data to datasets created in Geckoboard
Use Zapier to post new data to datasets created in Geckoboard

Learn how pairing Zapier can automatically post new data to a dataset linked to a dashboard widget. In this example, we'll use Typeform.

Updated over a week ago

By creating an automation, using Zapier, you can post new data to a dataset created in Geckoboard before using that dataset to power a new widget on your dashboard.

How Geckoboard and Zapier work together

In Geckoboard, you can create datasets, which are essentially like big tables/spreadsheets. Our Zapier integration enables you to add new rows to those datasets. You can then build widgets using those datasets.

To demonstrate this process, we'll use a Typeform survey to provide the data for our dataset and then build a data widget using that data.

Example Typeform widgets you can build with datasets in Geckoboard

Step 1: Create a new dataset in Geckoboard

We'll create a new dataset in Geckoboard that matches the required data types of a Typeform survey.

  1. In Geckoboard, add a new Datasets widget. On the connection panel, click Create new dataset.

  2. Give the dataset a name. Keep to lowercase letters, digits and no spaces. We don't support unicode characters in dataset or field names.

    Naming a new dataset in Geckoboard
  3. Now add the schema fields that correspond to the data types that make up the Typeform survey. There are 7 types of fields: string, number, money, percentage, date, datetime, and duration. Learn more about what data and format each field type can accept. For our example, we'll only need String for the survey submission IDs and Datetime for when the survey responses were submitted.

    Adding dataset schema fields for Typeform in Geckoboard

    As your survey submission ID field can make up a unique key, tick the Add to unique key checkbox. Learn more about using empty/null and unique key fields.

    Optional settings for new datasets fields in Geckoboard
  4. When you've finished configuring your fields, click Create dataset.

  5. With your dataset created, we'll switch to Zapier to connect our new dataset to a Zap.

Step 2: Create a Zap that connects Typeform to your dataset

We'll create a new Zap in Zapier that connects both your Typeform and Geckoboard accounts before linking it to your new dataset.

  1. Create a new Zap in Zapier. In the first Trigger step, search for and select Typeform.

  2. Next, we'll set up our trigger event. From the drop-down list, select New Entry. This will trigger an update whenever your survey is completed.

    Adding a new entry Typeform trigger in Zapier
  3. Connect to and select your Typeform account. Then click Continue.

  4. Locate the Typeform survey from the Form select menu.

    Adding an Typeform trigger in Zapier
  5. Click Test trigger. Zapier will attempt to find an entry from your survery to use in the Zap.

  6. With your trigger now set up, we'll now add an action to your Zap. Actions are events your Zap performs when your trigger event occurs. Search for and select Geckoboard.

  7. Click the Action Event drop-down list and select Add Record to Dataset. Then, click Continue.

    Adding a new data Geckoboard action in Zapier
  8. Connect to, and select, your Geckoboard account. You'll need to access your Geckoboard API key. Then click Continue.

  9. Under Dataset ID, select your new dataset.

    Selecting dataset in Zapier
  10. You'll now see all the schema fields for your dataset. Click each one and select the corresponding field from your Typeform survey.

    Linking Typeform fields with Geckoboard dataset schema in Zapier
  11. The Update Type dropdown menu is set to Add to existing records (Post) by default. If you've added fields to a unique key, this can be used to modify existing records in case their values have changed since your last update or if you want to fix an incorrect record.

    Select the method of updating your dataset data in Zapier
  12. Click Test & Continue. In this test Zapier will attempt to send a record to your dataset. You're now ready to click Turn on Zap.

  13. Our new Zap will post that new data to our dataset. Finally, we'll return to Geckoboard and add a new dataset widget.

Step 3: Add a new dataset widget in Geckoboard

With the survey submission IDs and datetimes, you can quickly build visualizations that show the number of submissions, either as a total or charted over time.

Example Typeform widgets you can build with datasets in Geckoboard
  1. Switch to Geckoboard, click See dataset and select your new dataset from the list to start configuring your widget.

  2. Now you can configure your widget by selecting your visualization type, add status indicators for number and gauge visualizations, comparison metrics, goals, and any additional formatting information about the data displayed.

    Datasets default to a line chart, however if your dataset does not contain date or datetime fields you won't see a line chart. You'll need to select another visualization type.

    To see a preview of your original dataset from the dataset options menu in the navigation bar.


    You'll also see a preview of the widget as you configure it. For more on configuring datasets widgets, see create visualizations from datasets.

  3. When your widget is ready, click Add to dashboard. Datasets widgets refresh automatically every 5 minutes, so you'll shortly see any new data added to your widget.

Did this answer your question?