> ## Documentation Index
> Fetch the complete documentation index at: https://docs.lightdash.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Lightdash for Google Sheets™

> Build and load Lightdash queries from a sidebar inside Google Sheets

<Info>
  The add-on is built and supported by Lightdash. [What Experimental means](/support/feature-maturity-levels).
</Info>

Lightdash for Google Sheets™ is an add-on that 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.

## How the add-on uses your Google data

The add-on reads and writes only the spreadsheet it is opened in, so that it can insert the query results you ask for. It does not access your other files or your Google account data.

Lightdash's use of information received from Google APIs follows the [Google API Services User Data Policy](/integrations/google-sheets#google-api-services-user-data-policy).

See the Lightdash [privacy policy](https://www.lightdash.com/privacy-policy) and [terms of service](https://www.lightdash.com/terms-of-service).

Google Sheets™ is a trademark of Google LLC.