BizMagnets Docs
API DocsStatusVisit our websiteRaise Ticket
  • Welcome to BizMagnets
  • SET-UP BIZMAGNETS ACCOUNT
    • Create an account in BizMagnets
    • Requirements to get started with your own number
    • Activate WhatsApp Business API on your own number
    • Migration
  • WHATSAPP CHANNEL
    • Creating WhatsApp Channel
    • Meta Business Verification
    • Required Documents for Facebook Business Verification
    • Drive traffic to your WhatsApp number using Quick Links
    • Display Name
      • Display Name Rejection and Appeal
    • How to change your Display Name
    • Facebook Business Verification Grayed Out, Not Visible or Disabled
    • Messaging Limits & Quality Ratings
    • WhatsApp Business API Errors
    • Business Phone Numbers
    • Support with Meta
    • WhatsApp Chat Widget
    • Supported Media Types
    • Unsupported Messages
    • FAQs
  • BLUE TICK VERIFICATION
    • WhatsApp Blue Tick Verification
    • How to Apply for Blue Tick Verification?
    • What if Your Application Gets Rejected?
    • FAQs
  • Conversation
    • Initiate Conversation
    • Sales Inbox
  • Support Inbox
  • FAQs
  • Contacts
    • Add Contact
    • Export Contacts
    • Contact Deletion
    • Contact Management
    • Opt-in Management
    • Community
      • New Community
      • Existing Community
    • Companies
  • TEMPLATE
    • BizMagnets Template Messages
    • Template Categories
    • Create and Edit Template
    • Carousel Marketing Templates
    • Product Marketing Templates
    • Coupon Marketing Template
    • Limited Time Offer Templates
    • Order Details Template
    • Authentication Template
    • FAQs
  • BOT FLOWS
    • Things to Know Before Building Your First Bot
    • BizMagnets Chatbot
    • Chatbot Flows and Analytics
    • Creating Flow in BizMagnets
    • Send Card
      • Text
      • Media
      • Template
      • CTA URL
      • Flow
      • Location
      • Payments
      • Voice
    • Ask Questions
      • Text
      • Button Option
      • List Option
      • Address
      • Flow
      • Keywords
      • Location
      • Current Location
      • Number
      • Mail
      • Date
      • Link
      • File
    • Logic
      • Condition
      • Delay
      • Variables
      • Switch
      • Jump To
      • Replace Text
      • Check Geofence
    • Integrations
      • Connect Your System with the WhatsApp Chat Bot Using API
      • Send Your WhatsApp Data to Zoho CRM Using Chatbot
      • Send Payment Links via WhatsApp Chatbot Using Razorpay Integration
      • Connect WhatsApp and Google Sheets to Collect Responses
      • Connect Shopify and WhatsApp to Collect Orders via Chatbot
      • Send your WhatsApp data to Sangam CRM using Chatbot
      • Send your WhatsApp data to WooCommerce using Chatbot
      • Connect ChatGPT with WhatsApp in BizMagnets Chatbot
      • Send Your WhatsApp Data to Zoho Bigin Using Chatbot
      • Send Your WhatsApp Data to HubSpot Using Chatbot
      • Send Payment Links via WhatsApp Chatbot Using Cashfree Integration
      • Send Payment Links via WhatsApp Chatbot with Telr Integration
    • Catalogue
      • Send Products
    • Actions
      • Assign Conversation
      • Set Tag
      • Remove Tag
      • Update Chat Status
      • Update Contact Fields
      • Trigger Sequence
      • Add Notes
    • Ticketing
      • Tickets
      • Create Ticket
      • Ticket Media
      • Get Tickets
    • Appointments
      • Appointment Flow
      • Appointment Confirmation
      • Set Members
    • Set Up Default Bot
    • Bot Management
    • FAQs
  • CAMPAIGN
    • BizMagnets Campaign
    • Campaign set up
    • Check and Test the Campaign
    • Campaign Analytics and Report
    • FAQs
  • WHATSAPP DRIP CAMPAIGN
    • Understanding Drip Marketing
    • Basics of Drip Campaign
    • Create New Drip Campaign
    • Drip Campaign Message Management
    • Campaign Management Options
    • Drip Campaign Analytics
    • FAQs
  • CTWA
    • CTWA in BizMagnets
    • Create your Ad Campaign
    • FAQs
  • INTEGRATION
    • E-commerce Platforms
      • Shopify
        • Workflows for Shopify
      • WooCommerce
        • Workflows for WooCommerce
      • WooCommerce Cart Abandonment Recovery
    • Shipping and Logistics
      • ShipRocket
        • ShipRocket Workflows
    • Payment Gateways
      • Razorpay
        • Razorpay Workflows
      • Cashfree
        • Workflows for Cashfree
      • Stripe
        • Stripe Workflows
    • Marketing and Engagement Platforms
      • Facebook Leads
        • Send Automated WhatsApp Messages to Facebook Leads
      • WebEngage
    • Additional Integrations
      • Zoho Books
        • Zoho Books Notifications
        • Workflow for Zoho Books
      • Generic Webhooks
        • Generic Webhook Workflows
        • Connect Wix Using Generic Webhook
        • Connect Zoho Desk Using Generic Webhook
        • Connect Your Google Form Using Generic Webhook
        • Connect Contact Form 7 Using Generic Webhook
      • Calendly
        • Workflows for Calendly
      • Pabbly
    • FAQs
  • APPOINTMENTS
    • BizMagnets Appointment
    • Appointment Booking
    • Appointment Template Configuration
    • FAQs
  • TICKETING
    • BizMagnets Ticketing
    • Ticket Fields
    • SLA Policies
    • Configuration
    • FAQs
  • Field Force Tracking
    • Field Force Tracking in BizMagnets
    • Add Geofence
    • Geofence Report
  • PRICING
    • Conversation Pricing
    • Message Credits
    • Billing & Subscriptions
  • COMMERCE
    • Facebook Catalogue
    • Orders
    • Payments
      • Sending Payment Links
      • Tracking Payments
      • FAQs
  • WHATSAPP OTP
    • WhatsApp OTP Configuration
    • OTP Authentication
  • API DOCUMENTS
    • Authentication
    • Channel
    • Untitled
    • API Docs
  • ADDITIONAL DETAILS
    • Members
      • Teams
      • Roles
      • FAQs
    • Exploring Message Delivery Challenges on WhatsApp
    • New Per-user Messaging Limits on WhatsApp
    • Automations
      • Chat Inbox Assignment
      • Chat Inbox Configuration
    • Quick Replies
    • Tags
    • API Keys
    • Biz Catalogues
    • Custom Fields
    • Frequently Asked Questions
  • ANALYTICS
    • Dashboard
    • Conversation Report
    • View Insights
    • Failed Messages
  • Group 1
    • Knowledge Base
Powered by GitBook
On this page
  • Overview
  • Google Sheets Operations
  • Connect your Google Sheets
  • Using the Google Sheets Connector
  • Add New Row:
  • Update Existing Row:
  • Fetch Row:
  1. BOT FLOWS
  2. Integrations

Connect WhatsApp and Google Sheets to Collect Responses

Easily manage customer data with our Google Sheets connector by integrating your chat flow.

PreviousSend Payment Links via WhatsApp Chatbot Using Razorpay IntegrationNextConnect Shopify and WhatsApp to Collect Orders via Chatbot

Last updated 7 months ago

This guide will show you how to seamlessly connect your chat interface with Google Sheets for efficient data storage and management.

Overview

Leverage our Google Sheets connector to streamline the process of storing and managing customer data from your chat flow. Follow this guide to ensure smooth integration between your conversational interface and Google Sheets.

Before starting, ensure your spreadsheet is set up with the necessary sheet and defined columns.

Google Sheets Operations

Here's a summary of the operations you can perform with the Google Sheet connector.

Operation
Description

Add New Row

Add a Row to the Google Sheet.

Update Existing Row

Update Rows in a Sheet using a Reference Column.

Fetch the Row Value

Fetch Row in a Sheet using a reference column.

Connect your Google Sheets

  1. To begin, navigate to the Integrations section and click on Google Sheets.

  1. To connect your Google account, click on 'Add New Connection' and provide a name for the connection.

  1. When prompted, sign in to your Google account using the email that has owner access to the Google Sheet.

It's recommended to establish the Google Sheets connector at the beginning of the workflow to ensure all necessary details are collected efficiently.

Using the Google Sheets Connector

Add New Row:

  1. Once the connection is established, navigate to the 'Select Existing Connection' tab. The connection you just created will appear at the top, followed by any previously established connections.

  1. Select your connection, and it will direct you to select the action out of three listed - Add New Row, Update Existing Row and Fetch Row. Select 'Add New Row'

  1. From the dropdown, select the spreadsheet where you want to store the data. Next, pick the specific sheet within that spreadsheet where the data will be added.

  1. To add row values, first, select the column name (from the sheet you chose in the previous step) from the dropdown menu. For the value, choose the corresponding variable that holds the user input.

    For instance, if the sheet has two columns—Name and Phone —you will map the variables to these columns to push the data for both fields into the selected sheet.

  1. Click 'Save'. Once the bot is triggered and the customer responds, their data is captured in the Google Sheet.

Update Existing Row:

This action allows you to modify existing data in a specific row.

  1. Open the Google Sheets Connector, select Action - Update Existing Row.

  2. From the dropdown, select the spreadsheet and specific sheet where you want to update the data.

  1. For row values, select the column name (from the previously selected sheet) from the dropdown and map it to the variable containing the original value.

To update the row, select the same column name and provide the new variable that holds the updated information.

For example, if you need to update the Name column, select that column and input the new value.

  1. After the bot is triggered and the customer responds, their updated data will be reflected in the Google Sheet.

Fetch Row:

To fetch specific data from a Google Sheet:

  1. Open the Google Sheets Connector and select Action - Fetch Row Value.

  2. Select the spreadsheet and the desired sheet from the dropdown list where you want to pull the data.

  1. To reference row values, choose the column name from the sheet and select the variable that stores the value from the user.

For fetching row values, choose the column and the corresponding variable you want to retrieve.

You'll have two conditions after each action to handle the chat flow: On Success and On Fail Condition.

By integrating the Google Sheets connector into your chat flow, managing and retrieving customer data becomes easy and efficient. Whether you're fetching, updating, or adding new data, this seamless process enhances your workflow and supports data-driven decision-making.