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

# Sheets

> Connecting a Google Sheets Data Source

To integrate a Google Sheets into your Typper BI environment, follow the comprehensive steps below:

<Steps>
  <Step title="Choose the Data Source Type">
    ![add\_a\_data\_source](https://mintlify.s3-us-west-1.amazonaws.com/typper/images/add_data_source_01.png)

    1. Navigate to the 'Add Data Source' page in your Typper BI dashboard.
    2. Under the 'Databases' section, select the 'Google Sheets' option.
  </Step>

  <Step title="Add Data Source Connection Details">
    ![add\_a\_data\_source](https://mintlify.s3-us-west-1.amazonaws.com/typper/images/add_data_source_08.png)

    Provide the necessary connection details in the form fields:

    2. URL: Enter the full Google Sheets URL in the format [https://docs.google.com/spreadsheets/d/sheetsid/edit#gid=0](https://docs.google.com/spreadsheets/d/sheetsid/edit#gid=0).
    3. Data Source Name: Assign a unique name for easy identification of your database within Typper BI.
    4. Typper BI Email: Ensure that the Typper BI's Email address able to access your document.

    ```bash
    typper-bi-sheets@typper-bi-backend.iam.gserviceaccount.com
    ```
  </Step>

  <Step title="Select the Schemas to Use">
    ![add\_a\_data\_source](https://mintlify.s3-us-west-1.amazonaws.com/typper/images/add_data_source_04.png)

    1. Once the database connection is successful, you'll be prompted to select the schemas you wish to use.
    2. Choose the relevant schemas that contain the data needed for your analytics.
  </Step>

  <Step title="Schemas Verification">
    ![add\_a\_data\_source](https://mintlify.s3-us-west-1.amazonaws.com/typper/images/add_data_source_03.png)

    Typper BI will load and verify the tables from the selected schemas.
    You might have to wait a few moments while the system processes the tables.
  </Step>

  <Step title="Confirm the Pages (Tables) and Columns">
    ![add\_a\_data\_source](https://mintlify.s3-us-west-1.amazonaws.com/typper/images/add_data_source_06.png)

    1. After schemas are loaded, select the tables and specific columns you need for your reports.
    2. You can add descriptions to each table to provide context for our AI.
  </Step>

  <Step title="Finalize Adding Your Data Source">
    ![add\_a\_data\_source](https://mintlify.s3-us-west-1.amazonaws.com/typper/images/add_data_source_05.png)

    1. Review all the details and ensure that everything is correctly set up.
    2. Click 'Add Data Source' to complete the process.
  </Step>
</Steps>

## Troubleshooting

Here's how to resolve some of the most common errors related to registering a sheet.

### Unsupported file format

Instead of importing data, you can convert an Excel file into a Google Sheets file and continue working on it in Sheets. The Excel file will not be changed.

1. Open [Drive](https://drive.google.com/) and double-click an Excel file. A file preview will open.
2. At the top, click **Open with Google Sheets**.
3. Click File and then **Save as Google Sheets**.

To automatically convert all future Office file uploads into Google Sheets files, do the following:

1. At the top of [Drive](https://drive.google.com/), click the gear icon and then Settings.
2. Next to "Convert uploads," enable the option *Convert uploaded files to Google Docs editor format*. *Note*: Files uploaded previously will not be converted.

In Drive, you will see both the Excel file and the new Sheets file. Choose between keeping the Excel file or deleting it. If you decide to keep the Excel file, to avoid confusion, you could rename it as \[Archived] My document.xls or something similar.