Skip to main content

WABB integration with Google Sheet

Updated this week

Integrating WABB with Google Sheets enables you to seamlessly automate the flow of data between your WhatsApp conversations and spreadsheets. This is particularly useful for businesses that want to automatically record user information, retrieve records during conversations, or update existing entries without manual effort.

For example, you can:

  • Automatically log user inquiries or responses in a Google Sheet

  • Fetch data (like order status or appointment details) from a sheet and send it directly in a WhatsApp chat

  • Update existing customer records when details change

This guide walks you through how to configure this integration and use it effectively in your WABB flows.

What You Can Do with This Integration

WABB's Google Sheets integration supports three core operations:

  1. Insert a New Row – Add a new entry in your Google Sheet from WhatsApp input

  2. Get Data from the Sheet – Search the sheet using a reference and retrieve related data

  3. Update Existing Data – Find a row based on a reference and update specific columns

Prerequisites

Before you start:

  • Create a Google Sheet with column headers such as Name, Email, Phone, etc.

  • Design your WABB flow to capture user inputs and store them in variables or user fields (these will be used to interact with the sheet)

How to Set Up the Integration in WABB

Step 1: Add the Integration Block

  1. In your WABB flow, click on the “+” icon to add a new block

  2. Select the “Integration” block and connect it to the previous message/input block where you've collected user data

  3. Click on the Integration block and choose “Add Google Sheet”

You’ll be prompted to:

  • Connect your Google Account

  • Grant access to WABB

  • Select the Google Sheet and the specific sheet tab (if your spreadsheet has more than one sheet)

Once connected, you’ll see a dropdown labeled “Action to Perform”.

Understanding and Using the Three Actions

1. Get Data from the Sheet

When to Use It:

Use this when you need to retrieve data from a specific row in your sheet based on a unique identifier (like phone number or order ID) provided by the user.

What is a Reference Column?

The Reference Column is the column in your Google Sheet used to identify the row you want to fetch data from. This column should contain unique values (e.g., phone numbers, emails, customer IDs).

For example:

If column A contains phone numbers and you want to fetch the name and order status for a specific phone number, column A becomes the Reference Column.

Steps to Configure:

  1. In the Integration block, set the Action to Perform as “Get data from the sheet”

2. Select the Reference Column from the dropdown (e.g., "Phone Number")

3. Enter the reference value, typically as a variable like {Phone} that you’ve collected earlier in the flow

4. In the Get row values section:

  • Choose which columns you want to fetch (e.g., “Customer Name”, “Order Status”)

  • For each, assign a WABB user field or variable to store the value, you need to click on the dropdown option and list of user field or variable will appear to choose from. (e.g., {CustomerName}, {Orderid})

5. You can repeat this step using “Add row value” if you want to retrieve multiple columns

Example:

Your Google Sheet has:

  • Column A: Phone Number

  • Column B: Customer Name

  • Column C: Order Status

In your flow, you collected a phone number in {Phone}. You configure:

  • Reference Column: Phone Number

  • Reference Value: {Phone}

  • Get row values:

    • Customer Name → {CustomerName}

    • Order Status → {OrderStatus}

Now you can use {CustomerName} and {OrderStatus} in your WhatsApp message block to respond dynamically.

2. Insert a New Row in the Sheet

When to Use It:

Use this when you want to store new data into a Google Sheet (e.g., capturing new leads, survey responses, registrations, etc.)

Steps to Configure:

  1. Set the Action to Perform as “Insert a new row”

  2. In the New row value section, click on “+ Add Row Value”

3. For each entry:

  • Select the Google Sheet column name where data should be added (e.g., "Email")

  • Enter the value manually or select User Field/Variable by clicking on “{}” option in the text box. (e.g., {Email})

Repeat this step for each additional column you want to populate.

Example:

You want to store the user's name, email, and phone number.

  • Google Sheet columns: Name, Email, Phone

  • WABB user fields: {Name}, {Email}, {Phone}

You configure:

  • Column: Name → Value: {Name}

  • Column: Email → Value: {Email}

  • Column: Phone → Value: {Phone}

Once the flow reaches this block, a new row will be created with the captured user details.

3. Update Data in the Sheet

When to Use It:

Use this action when you want to modify an existing record in your Google Sheet — such as updating order status, changing contact preferences, or logging the latest user activity.

Reference Column in Update:

The Reference Column is used to locate the exact row you want to update. It works the same way as in the Get action — this should be a column with unique identifiers, like Email or Phone Number.

Steps to Configure:

  1. Set the Action to Perform as “Update data from the sheet”

  2. Select the Reference Column (e.g., "Email")

3. Provide the reference value using a variable like {Phone} or a static value

4. Under the “Update in and by” section:

  • Select the column you want to update (e.g., "Status")

  • Enter the value manually or select User Field/Variable by clicking on “{}” option in the text box. (e.g., {Email})

Repeat the process using “+ Add more” if you want to update multiple columns in the same row.

Example:

Let’s say your sheet includes:

  • Column A: Email

  • Column B: Customer Name

  • Column C: Status

You want to update the Status column for the row where Email = {Email}.

Configuration:

  • Reference Column: Email

  • Reference Value: {Email}

  • Update in: Status → By: {NewStatus}

When the user completes an action (e.g., confirms an order), the system will update their status in your sheet automatically.

By integrating Google Sheets with WABB, you can create a fully automated workflow that interacts with live data. Whether you're capturing leads, providing personalized support, or managing operations, this integration ensures your Google Sheet becomes a dynamic backend for your WhatsApp automation — with zero manual effort.

Use it to:

  • Automatically store user inputs

  • Instantly fetch key details and reply in chat

  • Keep records up to date — all in real-time

Did this answer your question?