Getting Information Using Google Sheets

This page dives into detail on how we can get information using Google Sheet's

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

1. Go to Google Sheets integration either by:

   1. Searching for Google Sheets on the search bar available, or

   2. Scrolling down to Google Sheets.

2. Now Click On The ‘Connect’ Button As Shown

1. Click on the "Connect" button to continue to the integration.

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

---

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.

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

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

---

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

1. Go to your chatflow, and and select the flow in which you want the data to be entered.

2. Choose the Google Sheet’s component, and place the component at the desired place in your chatflow.

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

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

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

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

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

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

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

---

If everything is correct and you are still unable to move forward, write to us at [e-mail]. We will respond back within 48 business hours.