Skip to main content
The add-on is built and supported by Lightdash. What Experimental means.
The Lightdash Google Sheets add-on runs inside Google Sheets as a sidebar so you can build and load queries from your Lightdash instance without leaving the spreadsheet. It connects to your instance with OAuth and uses your existing Lightdash permissions, user attributes, and caching.

​
What you can do with the add-on

  • Browse your semantic layer: pick a project, then an explore, and see all of its dimensions and metrics grouped by table.
  • Build a query interactively: choose the dimensions and metrics you want, reorder columns, and load the results into the currently selected cell in the sheet.
  • Pivot your results: pivot dimensions into columns directly from the sidebar so the loaded range is shaped the way you want it in the sheet.
  • Filter with the model’s rules: filters defined in your dbt models are respected. required_filters are prefilled and can’t be removed (values are still editable), while default_filters are prefilled but can be adjusted or removed.
  • Add ad-hoc filters: layer additional dimension and metric filters on top of the model’s defaults from within the sidebar.
  • Refresh a saved report: each spreadsheet remembers its last query, so you can re-run it from the Lightdash menu with Refresh last report and rewrite the same range with fresh data.
  • Sign in with your Lightdash account: authentication uses OAuth against your Lightdash instance, so results reflect what the signed-in user is allowed to see.
Lightdash’s use of information received from Google APIs follows the Google API Services User Data Policy.