BotPenguin Resource Centre
What's NewDashboard
  • 🏠Introduction
  • 📒BotPenguin Resource Centre
    • 🏃‍♂️How BotPenguin works?
      • Onboarding
      • Create new chatbot
        • Website Chatbot
        • Landing Page Chatbot
        • WhatsApp Chatbot
        • Instagram Chatbot
        • Facebook Chatbot
        • Telegram Chatbot
        • Microsoft Teams Bot
        • Make Your Live Chat Chatbot
      • Edit Your Chat Flow
        • Multiple flows(Redirect component)
        • Components In Chatflow
          • Request Information
          • Send Information
          • Trigger Actions
        • Email Validation
      • Pre-Built Chatbot Templates
      • Train Your AI Chatbot
        • Website
        • File Upload
        • Google Sheets
        • FAQs
        • Unanswered Questions
        • Other Sources
      • Install your Chatbot
        • Install your Website Chatbot
        • Install Website Chatbot on Custom Build Website
        • Install Website Bot on WordPress
        • Install Website Chatbot on Wix
        • Install Website Chatbot on Squarespace
        • Widget Installation
      • Automation
        • Widget
        • WhatsApp Template Setup
        • WhatsApp Catalog Setup
        • WhatsApp Flows (Forms) Setup
        • WhatsApp Broadcast Setup
        • WhatsApp Drip Campaigns Setup
        • Facebook Auto-Reply Feature
        • Instagram Auto-Replies
        • Instagram Automation
          • Instagram Broadcast
      • Bot Settings
        • Website Chatbot Settings
          • Design
            • Customize Landing Page Bot
          • General
          • Alerts
          • Triggers
          • User Access
          • Chat Window
            • Transfer Chat to WhatsApp Functionality
          • AI settings
            • Configuring Chatbot Scenarios
        • WhatApp Chatbot Settings
          • General
          • Triggers
          • Alerts
          • API Key
          • WhatsApp Profile
          • AI settings
            • Configuring Chatbot Scenarios
        • Telegram Chatbot Settings
          • General
          • Telegram Profile
          • AI settings
        • Instagram Chatbot Settings
          • General
          • AI settings
            • Configuring Chatbot Scenarios
        • Facebook Chatbot Settings
          • General
          • AI settings
            • Configuring Chatbot Scenarios
        • Chatbot Persona
        • Creating Custom Instructions
        • How to configure and use AI Assistants
      • 3rd Party Apps Integrations
        • ChatGPT
        • BotPenguin Integrations
          • Integrate BotPenguin with Acuity Scheduling
          • Integrate BotPenguin with Microsoft Teams
          • Integrate BotPenguin with WooCommerce
          • Integrate BotPenguin with Autopilot
          • Integrate BotPenguin with Firmao CRM
          • Integrate BotPenguin with Capsule CRM
          • Integrate BotPenguin with Facebook Pixels
          • Integrate BotPenguin with Elevio CRM
          • Integrate BotPenguin with Close CRM
          • Integrate BotPenguin with CalendarHero CRM
          • Integrate BotPenguin with Extraaedge CRM
          • Integrate BotPenguin with Infobip CRM
          • Integrate BotPenguin with Google Sheets
          • Integrate BotPenguin with Google Calendar
          • Integrate BotPenguin with Google Task
          • Integrate BotPenguin with HelpShift CRM
          • Integrate BotPenguin with Zendesk CRM
          • Integrate BotPenguin with LeadSquared CRM
          • Integrate BotPenguin with Zoho Desk
          • Integrate BotPenguin with SupportBee CRM
          • Integrate BotPenguin with Wealthbox CRM
          • Integrate BotPenguin with Brevo (formally SendInBlue)
          • Integrate BotPenguin with Apptivo CRM
          • Integrate BotPenguin with Freshdesk CRM
          • Integrate BotPenguin with Help Desk CRM
          • Integrate BotPenguin with Helpcrunch CRM
          • Integrate BotPenguin with Jira CRM
          • Integrate BotPenguin with KarmaCRM
          • Integrate BotPenguin with LiveAgent CRM
          • Integrate BotPenguin with NetHunt CRM
          • Integrate BotPenguin with Plivo CRM
          • Integrate BotPenguin with Recurly CRM
          • Integrate BotPenguin with Shipway CRM
          • Integrate BotPenguin with TeamGate CRM
          • Integrate BotPenguin with Zoho Projects
          • Integrate BotPenguin with Zoho CRM
          • Integrate BotPenguin with Google Drive
          • Integrate BotPenguin with Agile CRM
          • Integrate BotPenguin with Pipedrive
          • Integrate BotPenguin with Drip CRM
          • Integrate BotPenguin with GetResponse
          • Integrate BotPenguin with Groove
          • Integrate BotPenguin with Helpdocs
          • Integrate BotPenguin with Bitrix24
          • Integrate BotPenguin with Freshworks CRM
          • Integrate BotPenguin with Insightly CRM
          • Integrate BotPenguin with Nimble CRM
          • Integrate BotPenguin with Nutshell CRM:-
          • Integrate BotPenguin with OntraPort CRM
          • Integrate BotPenguin with HubSpot
          • Integrate BotPenguin with WebHoper
          • Integrate BotPenguin with EngageBay
          • Integrate BotPenguin with FrontApp
          • Integrate BotPenguin with Copper CRM
          • Integrate BotPenguin with Salesflare
          • Integrate BotPenguin with No CRM
          • Integrate BotPenguin with Helprace
          • Integrate BotPenguin with Flowlu
          • Integrate BotPenguin with Pipeline
          • Integrate BotPenguin with Zingtree
          • Integrate BotPenguin with Salesforce CRM:-
          • Integrate BotPenguin with Chakra CRM:-
          • Integrate BotPenguin with SimplyBook:-
          • Integrate BotPenguin with Gitbook
          • Integrate BotPenguin with GoHigh Level
          • Integrate BotPenguin with Voxloud
          • Integrate BotPenguin with ViaSocket
          • Integrate BotPenguin with Twilio
          • Integrate BotPenguin with Shopify
          • Integrate BotPenguin with Razorpay
          • Integrate BotPenguin with Pabbly
          • Integrate BotPenguin with Outlook
          • Integrate BotPenguin with OnPipeline
          • Integrate BotPenguin with Notion
          • Integrate BotPenguin with MoEngage
          • Integrate BotPenguin with Kylas CRM
          • Integrate BotPenguin with Google Analytics
          • Integrate BotPenguin with FirstPromoter
          • Integrate Botpenguin with Google Contacts
          • Integrate Botpenguin with Zoho CRM
          • Integrate BotPenguin with Zapier
          • Integrate BotPenguin with Make.com
      • Inbox
        • Chats window
        • Orders
        • Contacts
        • Groups
        • Real-Time Customer Interaction
        • Importing WhatsApp Contacts
        • Creating Segments
        • Using Tags
      • Analytics
      • Teams
        • Departments
        • Business hours
        • Team
        • Role
        • Using Teams in Chatflow
      • Settings
        • Custom Attribute
        • Tags
        • Custom Status
        • Quick Replies
        • Custom Tabs
      • My Account
        • Account
        • Password
      • Subscription & Plans (Legacy Version)
      • Subscription & Plans (Latest Version)
    • ❓Frequently asked questions (FAQs)
      • Onboarding FAQs
      • Edit your chat flow
      • Bot Installation FAQs
      • Inbox FAQs
      • Profile, Team & Notifications FAQs
      • Analytics FAQs
      • Chat Flow FAQs
      • Bot Settings FAQs
      • WhatsApp FAQs
      • Subscription FAQs
      • Product Update FAQs
      • ChatGPT FAQs
    • 🛠️Common Errors & Troubleshooting
  • 📖Platform Guidelines & Training
    • 👩‍💻WhatsApp Cloud API by Meta
      • ⚙️Setting Up Your Facebook Business Manager
      • 💰Meta Conversation Pricing for WhatsApp Cloud API
      • 👧Update WhatsApp Bot Profile
      • ✅Getting a Blue Tick(previously Green Tick) on WhatsApp
    • 🔑WhatsApp Bot Creation with Manual Onboarding
      • ✅Prerequisites for WhatsApp Bots
      • 🔤Create a Meta App
      • ✔️Register & Verify your WhatsApp Number
      • 🔗Subscribe WA webhook with BotPenguin
      • 💳Update WA account Payment Method
      • 🦸‍♀️Assign System User to WhatsApp Account
      • 📃Getting all the necessary details from Meta Developer Dashboard
    • ⚙️WhatsApp Bot Creation with Automated onboarding
    • 🐧Migration Of Whatsapp Account from other platforms to BotPenguin.
    • ♻️Reconnect Whatsapp Bot
    • 🔏Recovering Your Restricted Meta Account
    • 💡Must know-how of BotPenguin
      • 🔤Manage & Use Custom Attributes
      • 🖥️Call external APIs in your chat flows
      • 👨‍💼Manging team roles & Users
      • 🪄Unlock BotPenguin AI
      • 🕵️‍♂️Support Agent guide
      • 📨Send WhatsApp notifications using the BotPenguin APIs
      • Chatbot User Authentication
  • ⚡Platform Updates & Info
    • 🔥What's New
    • 🐞Report a bug!
    • 🗒️Feature Requests
    • 🐧BotPenguin Roadmap
    • 🤝Connect With Us
  • 🛠️API References
    • 📄Contacts & Chats APIs
      • Get All Contacts
      • Getting Groups/Segments
      • Add WhatsApp Contact
      • Delete WhatsApp Contact
      • Website Contacts & Meta Data
    • 📄WhatsApp Cloud API
      • GET Templates List
      • POST WhatsApp Template Message
      • POST Send Message API
  • 🤝Partner Documentation
    • 🐧BotPenguin Partner Onboarding
      • Signup as a BotPenguin Partner
      • Setup your Pricing Plans
      • Connect to your Domain
      • Setup 3rd Party Integrations
        • Setup AWS SES Account
        • Setup Google reCAPTCHA
        • Setup ChatGPT Account
        • Setup Zoho Integrations
        • Setup Google OAuth App
        • Setup RazorPay Account
        • Setup Stripe Account
        • Setup Facebook App for WhatsApp & Facebook Bots
          • Create Facebook Login for Business Configuration
          • Meta System User Token
      • Setup your pricing plans (Legacy Version)
      • Setup your Pricing Plans (Latest Version)
    • 🙋‍♂️Partner FAQs
      • Onboarding
      • Affiliate Partner
      • Implementation Partner
      • Whitelabel Partner
      • WhatsApp Whitelabel Partner
      • Add-ons FAQs
      • Subscription FAQs
      • LTD FAQs
    • 📔Partner API References
      • Setting up environment
      • Get Customer
      • Create Customer
      • Update Customer
      • Delete Customer
      • Get Customer API Token
      • Get Team Members (Custom Users)
      • Get Custom User (Team Member) Token
      • Embedding the BotPenguin Inbox in 3rd Party Apps
Powered by GitBook
On this page
  • Why Use BotPenguin with Google Sheets?
  • Prerequisites:
  • Step 1 of 4: Login to BotPenguin Account and Select Application to Integrate
  • Step 2 of 4: Establish connection with your App
  • Step 3 of 4: Set up Mapping Parameters
  • Step 4 of 4: Test your Integration Set up with Data
  • FAQ's
  • Still Not Working, Let’s Troubleshoot!

Was this helpful?

  1. BotPenguin Resource Centre
  2. How BotPenguin works?
  3. 3rd Party Apps Integrations
  4. BotPenguin Integrations

Integrate BotPenguin with Google Sheets

This page contains the stepwise tutorial for the integration of Google Sheets with BotPenguin

PreviousIntegrate BotPenguin with Infobip CRMNextIntegrate BotPenguin with Google Calendar

Last updated 2 days ago

Was this helpful?

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 4: Login to BotPenguin Account and Select Application to Integrate

  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 4: Establish connection with your App

  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 4: Set up Mapping Parameters

  1. Now, you need to map parameters (fields) of Google Sheets to the user response of the BotPenguin question. In other words, you need to map the questions or custom attributes that will be saved to the Google Sheet. The fields that need to be entered are:

    1. Title: This is the title of the spreadsheet that you wish to create.

    2. Select a Default Sheet: Select in which you want the information to go to.

    3. Select a Default Sub-Sheet: Select the tab/sub-sheet in which the information will be mapped.

    4. Map Questions: Map the questions in the chatflow we wish to be stored in the spreadsheet.

    5. Custom Attributes: If the chat has custom attributes, we can utilize them to store values over in spreadsheet.

Make sure you have a empty sheet made in your google sheet account, so it can be connect to BotPenguin.

You can use the +Add Parameters button to add more fields.

For example, you select a question: Please provide your name?. Then, you map it with the parameter -Name. As a result, this mapping will enable integration to send the user's response from BotPenguin to the Google Sheet’s Name field in the leads. Similarly, in order for integration to work properly, you will require to map all other questions/ components of your Bot to Google Sheets fields.

Please note that these queries/questions options will be auto fetched from your bot chat flow, so, make sure you configure your chat flow first.

  1. If you have entered all the details correctly, you will see a notification that says, “Mapping successfully.

  1. To test the integration, proceed to install the bot. Click on the top right "Install" button and go over to W3 schools, where we can run the copied code. This will show that the code has been copied and

Your Google Sheets integration will show the message Installed in the Integration List.

Step 4 of 4: Test your Integration Set up with Data

Once you have established a connection between BotPenguin and Google Sheets, and the mapping is complete, you are ready to go for your first test lead. You can test your integration setup by creating a dummy lead on the bot. This lead should appear in your BotPenguin dashboard as well as in the Google Sheets you have integrated.


FAQ's

Here are some common FAQ regarding Google Sheets

Do I need to set up my chat flow before mapping?

Yes. The integration auto-fetches fields/questions from your chat flow. Ensure the bot is fully configured before proceeding with the mapping step

What if my bot is not reflecting changes.

If your spreadsheet does not reflect the additions done through conversation with the bot, try the following:

  1. Try to install the application on W3 schools and run there.

How can I test whether my integration is working?

After setup, run a dummy test lead through the chatbot. If configured properly, the data should appear in your Google Sheet and also reflect in your BotPenguin dashboard.

What if my test data doesn't appear in the sheet?

Check for the following:

  • Incorrect or missing field mappings

  • Mandatory fields left unmapped

  • Integration attempted on a free plan (must be on a paid plan for integration to work


Still Not Working, Let’s Troubleshoot!

If you are not getting dummy lead from your Bot to Google Sheets, it may be due to the multiple reasons:

  • Wrong Mapping Set up - Your mapping with BotPenguin Question and App parameter is either incorrect or you haven’t added any mandatory parameter.

  • Free plan- You are not subscribed to the paid plan on BotPenguin as integration works only in paid plan.

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

📒
🏃‍♂️
support@botpenguin.com