Skip to main content

How to train your AI Chatbot on Google Sheet?

  1. Log into your Cube6, and choose the bot you wish to train. 25 Google Sheets  Cube6 Resource Centre 1 Pn
  2. Click on β€œTrain Your AI Chat Bot” and start training your AI Chat Bot. 25 Google Sheets  Cube6 Resource Centre 2 Pn
  3. Click on the β€œGoogle Sheet’ tab to train on sheets.
  4. Click on β€œConnect your Google Sheet” to add the sheet according to which you want to train your AI Chat Bot. 25 Google Sheets  Cube6 Resource Centre 3 Pn
    You may be redirected to the third party integrations page. Sign into your google account and then go back to the β€œGoogle Sheets” tab. Click on the β€œConnect your Google Sheet” again.
  5. Add your Google Sheet URL and describe the content or purpose of this Google sheet.
  6. Click on β€œSync Google Sheets”.
Congratulations! You have just added a google sheet! The training for the current sheet should have started, and you can add more sheets using the β€œSync Google Sheet” button on the top left corner.

FAQ’s:

Here are some common FAQ’s regarding Google Sheets:
Only public or shared sheets with proper access permissions (viewer or editor) can be synced. Ensure your sheet isn’t restricted or private.
Currently, the system typically trains on the first tab of the sheet. For multi-tab training, ensure relevant data is consolidated in a single tab.
Use a two-column format: one for Questions and one for Answers. Avoid using formulas, merged cells, or complex formatting.
That’s a normal part of the OAuth authentication process for Google account access. After signing in, return to the β€œGoogle Sheets” tab to complete the sync.
Refresh the page, ensure the sheet URL is correct and publicly accessible, and confirm you are logged into the correct Google account.
After syncing the first sheet, simply click the β€œSync Google Sheet” button again (top-left corner) to repeat the process for additional sheets.
No, you need to manually resync the sheet after any edits to reflect the updates in your chatbot training.
Yes. Visit the connected sheets section and select the one you wish to remove or update. The training data will adjust accordingly.
Double-check the sheet’s sharing settings and make sure it’s not restricted. Also, confirm that you’ve completed the Google sign-in process correctly.