# Integrations Component

### 1. Google Sheets Component 

The **Google Sheets Component** allows your WhatsApp chatbot to read from and write data to Google Sheets in real-time. This makes it easy to collect user responses, store leads, track orders, or manage any data directly from your chatbot without manual intervention.

### Why use BotPenguin with Google Sheets

* **Real-time Data Sync** – Automatically store chatbot conversations, leads, and customer queries in Google Sheets for easy tracking and analysis.
* **Automated Workflows** – Eliminate manual data entry by using Google Sheets as a backend for appointments, orders, feedback, and more.
* **Instant Customer Engagement** – Fetch and update customer details dynamically from Google Sheets to provide personalized responses.
* **Effortless Integration** – No coding or third-party tools required—simply connect and automate.
* **Scalable & Flexible** – Perfect for sales, support, marketing, and surveys, adapting to your unique business needs.

***

### Prerequisites:

The following conditions must be fulfilled to use Google Sheet Integration with BotPenguin:

1. **BotPenguin Account**: The user must have an active BotPenguin Account, and must have an active bot which they wish to connect.

Google Sheets integration is not available for MS Teams, Facebook, Instagram or Telegram.

***

### Step 1 of 3: Login to BotPenguin and Integrate with Google Sheets

1. Login to your BotPenguin account. Now, select and click the chatbot you want to integrate with Google Sheets. Click on the “Third-party Apps Integration”.

<figure><img src="/files/oI7mdB5wFCdZnmwb98lG" alt=""><figcaption></figcaption></figure>

2. Go to Google Sheets integration either by:
   1. Searching for Google Sheets on the search bar available, or
   2. Scrolling down to Google Sheets.
3. Now Click On The **‘Connect’** Button As Shown

<figure><img src="/files/REIRMGROLqkA0SGMAKLn" alt=""><figcaption></figcaption></figure>

4. Click on the "**Connect**" button to continue to the integration.

<figure><img src="/files/rrvreTVl90d46FbdeBgm" alt=""><figcaption></figcaption></figure>

5. Click on the "**Sign-in with Google**" to start the connection process.

<figure><img src="/files/eiXkYn9lnT4qFnh7kKRD" alt=""><figcaption></figcaption></figure>

***

### Step 2 of 3: Establish Connection with Google Sheets

1. After you click the **“Sign In With Google”** button, it will redirect you to a Google login window. Here, fill out your account credentials and sign in.

<figure><img src="/files/8BrR5oZrmcA0BPC1bjwl" alt=""><figcaption></figcaption></figure>

2. Now, click allow for BotPenguin to access your Google account.

<figure><img src="/files/ss8xLmNjPACMqF0i2f7S" alt=""><figcaption></figcaption></figure>

3. After you click allow, the connection between BotPenguin and Google Sheets is established, and you will be redirected back to Botpenguin onto the following page.

<figure><img src="/files/LCCKotB4gGnM9TROEK8a" alt=""><figcaption></figcaption></figure>

***

### Step 3 of 3: Configuring "Google Sheet" Component:

1. Now that the Google Sheet integration has been set up, we now need to configure the chatflow to get the information from selected Google Sheet.
2. Click on the back arrow till we get on the Dashboard, then click on “Edit your Chatflow”.

<figure><img src="/files/IXFkXdOFmPJLr3RcgnUe" alt=""><figcaption></figcaption></figure>

3. Go to your chatflow, and and select the flow in which you want the data to be entered.
4. Choose the Google Sheet’s component, and place the component at the desired place in your chatflow.

<figure><img src="/files/ue14osbmTuR1UHvrNHD0" alt=""><figcaption></figcaption></figure>

5. In the “Customization Bot Messages”, or the right hand ride of the integration screen, select the following:
   1. The Default Sheet: Select the sheet from which the data will be extracted from.

<figure><img src="/files/fSRO6U4UOa2v4ZpGNn0W" alt=""><figcaption></figcaption></figure>

b. Select the default sub-sheet, or tab inside the spreadsheet.

<figure><img src="/files/T3iBir4emgMu6QVNhbWK" alt=""><figcaption></figcaption></figure>

c. Select “Get Details” from the “Choose Action” dropdown

<figure><img src="/files/vVGdgk0a3Etf4zBuYJdI" alt=""><figcaption></figcaption></figure>

6. A new section will open post selecting “Get Details”.

<figure><img src="/files/25iIa6X4UPY4R9Fv9rru" alt=""><figcaption></figcaption></figure>

7. In the “Search Options” box:
   1. In the “Search Key” box, enter the value against which you what to search the sheet. In other words, enter the cell information against which you will search for another cells. If the value you are searching against is variable, or will change every time, please make use of a custom variable.
   2. Choose the Range of the sheet where you expect the data to be found in the “Search Range” box.
   3. Enter the index of the column(in numerical form 1,2,3….) where you want the information to be extracted from.

<figure><img src="/files/eJl4cI9Tb3crMYQO3Li7" alt=""><figcaption></figcaption></figure>

8. In the Success box:
   1. Choose the custom attribute in which you want to store the information retrieved from the Google Sheet.
   2. Select the message that we want the chatflow to go to next.

<figure><img src="/files/WJ9R5OViotp52UAsRJ8T" alt=""><figcaption></figcaption></figure>

9. In case of failure, we select the message we want the chatflow to go to if some trouble is faced.

<figure><img src="/files/S3mV3ZqTdRoxj2Q2YAth" alt=""><figcaption></figcaption></figure>

***

## 2. Zendesk Component&#x20;

The **Zendesk Component** allows your WhatsApp chatbot to seamlessly interact with Zendesk, enabling automated ticket creation, updates, and retrieval of customer support information. This integration ensures a smooth support experience by connecting your chatbot conversations with your Zendesk helpdesk.

### Key Features

* Automatically create Zendesk tickets from WhatsApp conversations.
* Retrieve ticket status or information for users in real-time.
* Update existing tickets with new messages or user inputs.
* Personalize responses based on ticket data stored in Zendesk.
* Enable agents to track and respond to WhatsApp queries from Zendesk.

### How to Use

1. **Connect Zendesk**
   * Navigate to the **Integrations** section in BotPenguin.
   * Select **Zendesk** and authenticate using your Zendesk account credentials.
2. **Configure the Component**
   * **Action Type**: Choose between **Create Ticket**, **Update Ticket**, or **Fetch Ticket Status**.
   * **Ticket Fields**: Map WhatsApp user responses or variables to the relevant Zendesk ticket fields (e.g., subject, description, priority).
   * **Assignee / Group**: Optionally assign tickets to specific agents or groups.
3. **Use in WhatsApp Flow**
   * Drag and drop the **Zendesk Component** at the point in your WhatsApp flow where you want to handle support.
   * Customize messages sent to users after ticket creation or status retrieval.
   * You can create dynamic responses based on ticket status or priority.
4. **Test the Integration**
   * Test ticket creation, updates, and status retrieval using a sample WhatsApp conversation to ensure everything works as expected.

<figure><img src="/files/DiJ3SkxxUNsFbuKzxQaO" alt=""><figcaption></figcaption></figure>

### FAQs

<details>

<summary>Can I integrate Google Sheets with all BotPenguin bots?</summary>

No. Google Sheets integration is available only for certain bots and is not supported on MS Teams, Facebook, Instagram, or Telegram.

</details>

<details>

<summary>Do I need coding knowledge to use Google Sheets integration?</summary>

No. The integration is designed to work without coding. You can connect and configure it directly through the BotPenguin dashboard.

</details>

<details>

<summary>What should I do if my search value changes dynamically?</summary>

Use a \*\*custom variable\*\* in the “Search Key” field to handle dynamic values for searching data in your spreadsheet.

</details>

<details>

<summary>How do I specify which sheet or tab to use?</summary>

Select the \*\*Default Sheet\*\* and then the \*\*Default Sub-Sheet (tab)\*\* from the integration configuration screen.

</details>

<details>

<summary>What happens if the data retrieval fails?</summary>

You can configure the \*\*failure path\*\* in the chatflow to specify which message or component the flow should go to in case of an error.

</details>

<details>

<summary>Can I extract data from multiple columns?</summary>

Yes. Use the \*\*Index Column\*\* field to specify the column number (1, 2, 3, …) from which to retrieve the information.

</details>

<details>

<summary>How is the retrieved information stored in the chatbot?</summary>

Select a \*\*Custom Attribute\*\* where the retrieved data will be stored for use in subsequent chatflow steps.

</details>

<details>

<summary>Can I test the integration before going live?</summary>

Yes. After configuration, use the \*\*Test Flow\*\* option to verify that data is correctly fetched and the chatflow behaves as expected.

</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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.botpenguin.com/bots/whatsapp-bot/manage-chatflow/components-in-chatflow/integrations-component.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.