Connect WhatsApp and Google Sheets to Collect Responses

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.

Google Sheets Operations

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

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.

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, Fetch Row and Fetch Dynamic Rows. 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.

Fetch Dynamic Rows:

To fetch specific data from a Google Sheet:

1. Open the Google Sheets Connector and select Action - Fetch Dynamic Rows.

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

3. Limit sets the maximum number of rows that the system should fetch from the specified sheet

1. To select the reference column name, reference value, choose the column name (from the Google Sheet you selected in the previous step) using the dropdown. For the value, select the value that stores the user input collected during the flow.

5. Once configured, click Save to apply the settings.

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.