Google Sheets
This guide provides step-by-step instructions to setup your Google Sheet training with BotPenguin.
Interactive Guide
What is Training via Google Sheets?
Training your AI chatbot via Google Sheets allows you to provide structured data stored in spreadsheets for accurate and dynamic responses.
By connecting Google Sheets:
Your chatbot can access live data from the spreadsheet.
Responses can be updated automatically as the spreadsheet changes.
Enables dynamic and personalized user interactions based on real-time data.
Benefits of Google Sheets Training
🎯 Real-Time Data Sync: Chatbot can fetch and respond using live spreadsheet data.
🟢 Automated Knowledge Updates: Changes in the sheet automatically reflect in chatbot responses.
⚡ Flexible Data Management: Use Google Sheets as a backend for FAQs, orders, appointments, and more.
🔧 Multi-Sheet Support: Add multiple sheets to train the chatbot comprehensively.
📈 Enhanced User Experience: Provides accurate, context-aware, and timely responses.
Guidance Video
How to train your AI Chatbot on Google Sheet?
Log into your BotPenguin, and choose the bot you wish to train.
Click on “Train Your AI Chat Bot” and start training your AI Chat Bot.
Click on the "Google Sheet' tab to train on sheets.
Click on “Connect your Google Sheet” to add the sheet according to which you want to train your AI Chat Bot.
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.
Connect your google account and allow the permissions
Botpenguin will ask you to allow some permissions in order to access the Google Sheets
Click on Allow button.
Then your account will be connected .
Click on Add Google Sheet Button
Add your Google Sheet URL and describe the content or purpose of this Google sheet.
Click on “Add 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:
What kind of Google Sheets are supported for training?
Only public or shared sheets with proper access permissions (viewer or editor) can be synced. Ensure your sheet isn't restricted or private.
My Google Sheet has multiple tabs. Will the bot train on all of them?
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.
What format should the sheet follow for best results?
Use a two-column format: one for Questions and one for Answers. Avoid using formulas, merged cells, or complex formatting.
Why was I redirected to another page while connecting Google Sheets?
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.
I clicked “Sync Google Sheet,” but nothing seems to happen. What should I do?
Refresh the page, ensure the sheet URL is correct and publicly accessible, and confirm you are logged into the correct Google account.
How can I add more than one Google Sheet?
After syncing the first sheet, simply click the "Sync Google Sheet" button again (top-left corner) to repeat the process for additional sheets.
Will the bot automatically update if I make changes to the sheet later?
No, you need to manually resync the sheet after any edits to reflect the updates in your chatbot training.
Can I delete or disconnect a synced sheet later?
Yes. Visit the connected sheets section and select the one you wish to remove or update. The training data will adjust accordingly.
I entered the correct sheet URL, but it's not syncing. What could be wrong?
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.
If everything is correct and you are still unable to move forward, write to us at [email protected]. We will respond back within 48 business hours.
Last updated
Was this helpful?