Google Sheets
Last updated
Last updated
To use Google Sheets as sources, you must link your Google Sheets account.
After linking your Google Sheets account, you can add a Google Sheets source by clicking on New Google Sheet.
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.
Similarly, you will be able to view the uploaded Google Sheet chunking settings and output.
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 embeddings are not created, ensure that your AI integrated account has not exceeded its token limit.
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.
For the Apply Label Lock feature to show, the label type on Google Drive must be a Badged label.
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.
If a file is stuck at the training phase, click on Resync Source
On , ensure that you have the necessary admin privileges to utilise the Labels feature, see Drive Label Admin.
Create a Google Drive Label. 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 .
Apply the Label 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.
If the GWS Label Lock feature is enabled, you will see the Apply Label Lock checkbox when creating a new Google Sheet. Enabling this would allow the file to be used as a knowledge source as long as the label on the file is .
