Google Sheets
Last updated
Was this helpful?
Last updated
Was this helpful?
To use Google Sheets as sources, you must .
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.
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 .
Create a . 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 .
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 . Enabling this would allow the file to be used as a knowledge source as long as the label on the file is .
