# Google Sheets You may connect your Google Sheets Account with BotDistrikt. Navigate to **Integrations** and click on **Sheets**
You will be presented with two options to integrate Google Sheets with the BotDistrikt platform. * Use a User Account - allows you to connect to Google Sheets from your personal user account. * Use a Service Account - allows you to connect to Google Sheets from a [service account](https://developers.google.com/identity/protocols/oauth2/service-account).

Google Sheets Integration Options

### Use a User Account 1. Click on the **Sign in with Google** button and allow BotDistrikt to access your Google Account.

Use a User Account

2. After successfully linking your Google account, you will be able to see all available spreadsheets in the dropdown selector.

Successfully Integrated a User Account

Adding a Google Sheet as a Source

### Use a Service Account 1. To generate your Google Sheets private key JSON file, you must first open the [API Library](https://console.cloud.google.com/apis/library).

Use a Service Account

API Library

2. In the search bar on the API Library page, search for Google Sheets API.

Search for Google Sheets API

3. In the Google Sheets API product details, click on **Enable**.

Google Sheets API

4. At the APIs & Services dashboard, click on **Credentials** at the left navigation panel. Once at the Credentials tab, click on **Create Credentials** and select **Service Account** from the dropdown menu.

Create Credentials

5. Once at the Create service account page, fill in the necessary information for the service account details and permissions, and click **Done**.

Create Service Account

6. At the service account dashboard, click on the hyperlinked email address of the service account that was just created to access the Service account details page.

Service Accounts for a Project

7. Click on the **Keys** tab to view all service account keys. Click on **Add Key** and from the dropdown menu, select **Create new key**.
8. In the modal that appears, select the JSON key type option and click on **Create**. You will be prompted to download the JSON file.

Select a Key Type

Private Key Successfully Saved

9. Before uploading the JSON file on BotDistrikt’s platform, please ensure that the Google Drive API is enabled. This can be done by searching for Google Drive API in the search bar on the API Library page and clicking on the **Enable** button.

Search for Google Drive API

Google Drive API

10. At the Google Sheets integration page on BotDistrikt’s platform, upload the JSON file containing the private key to link the service account.

Upload JSON Containing Private Key

### Add Sources with a Service Account 1. To add a sheet as a source on the BotDistrikt platform via a Service Account, share the file with the service account email address.

Sharing File with Service Account Email

2. Once shared, the file should show up as an available document to be used as a source on the BotDistrikt platform.

Shared File Showing as Available

You can now head on to Sources to [train your LLM to learn from your Google Sheets](https://docs.botdistrikt.com/features/sources/google-sheets)