Skip to main content

​
How to train your AI Chatbot on Google Sheet?

  1. Log into your Convertalk, and choose the bot you wish to train. 25 Google Sheets Convertalk Resource Centre 1 Pn
  2. Click on “Train Your AI Chat Bot” and start training your AI Chat Bot. 25 Google Sheets Convertalk 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 Convertalk 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.