Google Sheets data source now supports template variables

The Google Sheets data source just got more powerful! Our 2.2.0 release adds support for template variables, making it easier to build interactive and adaptable dashboards directly from your spreadsheets.

Imagine you have a spreadsheet with sales data for different regions. With template variables, you can add a drop-down menu to your dashboard that lets users select a specific region. The dashboard automatically updates to show only the data for that region.

What’s new?

1. Variable interpolation: You can now use variables within other variables. This means you can create more complex and flexible variable relationships. For example, you could have a variable for “Country” and another for “City,” where the available “City” options change based on the selected “Country.”
2. Filtering by value: You can create new variables based on the values of existing ones. This allows you to refine your data selections. For instance, you could have a variable showing “Product Categories,” and then create a new variable that only displays “Products” within the selected category.

These new features make it much easier to build flexible, reusable dashboards using data from Google Sheets, giving your users more control and customization.

For more info, check out the Google Sheets variable documentation.

2025-09-05

Save, reuse, and share queries in Dashboards and Explore

2025-09-05

New table visualization is generally available

2025-09-05

Enhanced Ad Hoc filter support