# Google Sheets

## Overview <a href="#overview" id="overview"></a>

The Google Sheets integration allows you to bring any spreadsheet data into Sola in real time.

Connect any Google Sheet to Sola and query your data directly, from user access records and asset inventories to compliance trackers, security context and investigation, and more.

{% hint style="info" %}
Google Sheet names are currently supported in English only. Support for additional languages is not yet available. Data in your sheets can be in any language.
{% endhint %}

{% hint style="warning" %}
**Your data can only be retrieved, never modified.**

Once connected, your data is securely stored, and access is restricted to retrieving configurations and metadata only. Authentication methods ensure secure delegation of permissions while maintaining data integrity.
{% endhint %}

## Set up Google Sheets data source integration with Sola <a href="#set-up-wiz-data-source-integration-with-sola" id="set-up-wiz-data-source-integration-with-sola"></a>

{% columns %}
{% column width="66.66666666666666%" %}
Go to ***Integrations*** > [***Data Sources***](https://app.sola.security/integrations/data-sources) > click ***New data source*** > select ***Google Sheets***.

*The Sola wizard will take you through the steps.*
{% endcolumn %}

{% column width="33.33333333333334%" %} <a href="https://app.sola.security/integrations/data-sources?integration=google_sheets" class="button primary">Set up Google Sheets -></a>
{% endcolumn %}
{% endcolumns %}

To connect Google Sheets, you'll need a Google account with access to the spreadsheet you want to connect.

{% tabs %}
{% tab title="Google OAuth" %}
This method uses Google OAuth to securely grant Sola read-only access to your Google Drive.

Click **Connect with Google Sheets** in the Sola wizard to sign in and authorize access.
{% endtab %}
{% endtabs %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.sola.security/integrations/data-sources/google-sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.