# Google Sheets

### **Interactive Guide**

{% embed url="<https://app.arcade.software/share/eWPdkSYfuNlzCP3abzWx>" %}

***

### 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**

{% embed url="<https://www.youtube.com/embed/wBwGUcnS-nI?si=_KMZLqOVMiKqERgg>" %}

***

### **How to train your AI Chatbot on Google Sheet?**

1. Log into your BotPenguin, and choose the bot you wish to train.

<figure><img src="https://1745791824-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FAPDb8cKQtGlIAfgHjcsQ%2Fuploads%2FMJ11YxblCjSiqTu11pGx%2Fimage.png?alt=media&#x26;token=7c9e63e5-b0a8-4c4b-bf52-9bd5c6628e8f" alt=""><figcaption></figcaption></figure>

2. Click on **Bot Training** option.

<figure><img src="https://1745791824-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FAPDb8cKQtGlIAfgHjcsQ%2Fuploads%2FmG7i0trwy9WwAezFjI1f%2Fimage.png?alt=media&#x26;token=af238ba9-e91b-4e7c-b904-ca888067aceb" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="https://1745791824-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FAPDb8cKQtGlIAfgHjcsQ%2Fuploads%2FsJuUYJATuCHwGRurulln%2Fimage.png?alt=media&#x26;token=e9fec5b0-5bfb-4046-9b72-af520757ef77" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
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.
{% endhint %}

5. Connect your google account and allow the permissions

<figure><img src="https://1745791824-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FAPDb8cKQtGlIAfgHjcsQ%2Fuploads%2F4cnoSfP86kwnl23EdY95%2Fimage.png?alt=media&#x26;token=8e9a2d89-3555-4c12-be2f-8b00e83977c2" alt=""><figcaption></figcaption></figure>

6. Botpenguin will ask you to allow some permissions in order to access the Google Sheets

<figure><img src="https://1745791824-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FAPDb8cKQtGlIAfgHjcsQ%2Fuploads%2FWT3HbP5fVFHgns6VjtQH%2Fimage.png?alt=media&#x26;token=0a026e0f-62bf-4d66-ae31-18ddcd2235ff" alt=""><figcaption></figcaption></figure>

7. Click on Allow button.
8. Then your account will be connected .

<figure><img src="https://1745791824-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FAPDb8cKQtGlIAfgHjcsQ%2Fuploads%2FCwl7bgco7eCipF6fIMKn%2Fimage.png?alt=media&#x26;token=0d714016-bf3c-47c5-b6c4-2adbf10d60f9" alt=""><figcaption></figcaption></figure>

9. Click on Add Google Sheet Button
10. Add your Google Sheet URL and describe the content or purpose of this Google sheet.

<figure><img src="https://1745791824-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FAPDb8cKQtGlIAfgHjcsQ%2Fuploads%2FWu4CTCPiMXRqIxcvYYeT%2Fimage.png?alt=media&#x26;token=c09dd181-f376-4341-899c-664a2c75ae9b" alt=""><figcaption></figcaption></figure>

11. Click on **“Add Google Sheets”.**

<figure><img src="https://1745791824-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FAPDb8cKQtGlIAfgHjcsQ%2Fuploads%2FdEXROLMTpRhI6PrV8vcx%2Fimage.png?alt=media&#x26;token=538488f4-a9d3-43b9-8305-734b4811b6b2" alt=""><figcaption></figcaption></figure>

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:

<details>

<summary>What kind of Google Sheets are supported for training?</summary>

Only public or shared sheets with proper access permissions (viewer or editor) can be synced. Ensure your sheet isn't restricted or private.

</details>

<details>

<summary>My Google Sheet has multiple tabs. Will the bot train on all of them?</summary>

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.

</details>

<details>

<summary>What format should the sheet follow for best results?</summary>

Use a two-column format: one for **Questions** and one for **Answers**. Avoid using formulas, merged cells, or complex formatting.

</details>

<details>

<summary>Why was I redirected to another page while connecting Google Sheets?</summary>

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.

</details>

<details>

<summary>I clicked “Sync Google Sheet,” but nothing seems to happen. What should I do?</summary>

Refresh the page, ensure the sheet URL is correct and publicly accessible, and confirm you are logged into the correct Google account.

</details>

<details>

<summary>How can I add more than one Google Sheet?</summary>

After syncing the first sheet, simply click the **"Sync Google Sheet"** button again (top-left corner) to repeat the process for additional sheets.

</details>

<details>

<summary>Will the bot automatically update if I make changes to the sheet later?</summary>

No, you need to **manually resync** the sheet after any edits to reflect the updates in your chatbot training.

</details>

<details>

<summary>Can I delete or disconnect a synced sheet later?</summary>

Yes. Visit the connected sheets section and select the one you wish to remove or update. The training data will adjust accordingly.

</details>

<details>

<summary>I entered the correct sheet URL, but it's not syncing. What could be wrong?</summary>

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.

</details>

If everything is correct and you are still unable to move forward, write to us at <support@botpenguin.com>. We will respond back within 48 business hours.