# Google Sheets ### **Google Sheets**

To use Google Sheets as sources, you must [link your Google Sheets account](https://docs.botdistrikt.com/business-tools/google-sheets).

1. After linking your Google Sheets account, you can add a Google Sheets source by clicking on **New Google Sheet**.

2. Search for your spreadsheet and a dropdown field will appear allowing you to select a sheet to be used from that spreadsheet. Click on **Select Sheet** once a sheet has been chosen.

3. Similarly, you will be able to view the uploaded Google Sheet chunking settings and output.

4. Click on **Train AI** to use that Google Sheet as a source. **Troubleshooting**: * If a file is stuck at queued, ensure that your account has not exceeded the respective tier Response Repo limit. * If a file is stuck at the training phase, click on **Resync Source**

* If embeddings are not created, ensure that your AI integrated account has not exceeded its token limit. ## GWS Label Lock The GWS Label Lock feature secures and facilities the approval process by ensuring that only files with the designated labels are used for knowledge sourcing. Feature available on request. ### **How to use the label lock** 1. On

, ensure that you have the necessary admin privileges to utilise the Labels feature, see [Drive Label Admin](https://support.google.com/a/answer/9292382?hl=en). 2. Create a [Google Drive Label](https://support.google.com/a/answer/13127870?hl=en). This is required for the "Label Lock" field to appear. Next, designate **one** **label option** to indicate that the file is ready to be used as a knowledge source. In this example, the designated label option is

. {% hint style="info" %} For the **Apply Label Lock** feature to show, the label type on Google Drive must be a Badged label.

{% endhint %}

3. [Apply the Label](https://support.google.com/drive/answer/13495216?hl=en\&co=GENIE.Platform=Desktop) on a Google Sheet. If the selected file has a label other than the designated label for syncing, i.e.

then the file cannot be synced so the current sources of the chatbot won't change. 4. If the GWS Label Lock feature is enabled, you will see the **Apply Label Lock** checkbox when [creating a new Google Sheet](https://docs.botdistrikt.com/features/sources). Enabling this would allow the file to be used as a knowledge source as long as the label on the file is

**Troubleshooting**: * If the initial labels are not applied, you will get a Sync error and the new content will not be synced for embeddings on the chatbot.