Search Google Sheets

How to Use the “Search Google Sheets” Action in Botassium

Need to look up data from a spreadsheet—like checking stock, validating a coupon code, or fetching user records? The “Search Google Sheets” action in Botassium allows you to connect to your Google account and run real-time searches inside your sheets based on incoming data from WhatsApp conversations.

This guide explains how to configure the search and use the result dynamically in your automation.

What is the “Search Google Sheets” Action?

The Search Google Sheets node is an action that allows you to query a specific Google Sheet and retrieve matching data based on a condition you define.

It’s useful for:

• Validating user-submitted data (e.g., coupon codes, email addresses, booking IDs)

• Searching a database of users, orders, or inventory

• Integrating Google Sheets as a lightweight backend for quick lookups

⚠️ This action requires a one-time authentication. Use the authentication link in the node to connect your Google account before using this feature.

How It Works

1. Select a Document

Choose from your connected Google Sheets. Once authenticated, your document list will be available in the dropdown.

2. Select a Sheet (Page)

After selecting a document, pick the specific sheet (tab) where the data is stored.

3. Enter a Search Query

Define the query logic used to search the sheet.
Example:

You can use dynamic variables from earlier in the flow to make your query specific to each user.

4. Set Result Variable Name

Choose a variable name to hold the search result.
Example: sheet_data, user_row, or matched_entry
You’ll be able to reference this variable in later messages, conditions, or logic steps.

5. Test the Connection (Optional)

Once everything is set, test the action by running a query. If successful, you’ll see a preview of the matched row and value structure.

Outputs: Success and Failure

This node offers two logic paths:

• On Success: The search returned a match. You can continue the flow using the result.

• On Failure: No match found, or an error occurred. You can handle this with fallback replies, error notifications, or alternative flows.

Example Use Case

You’re running a WhatsApp campaign for an event and want to check if the user is on the guest list:

1. User sends their email

2. Add a Search Google Sheets node

   • Document: Event Check-In

   • Sheet: Guests

   • Query: @user_email

   • Result Variable: guest_info

3. On Success → Send a reply: "You're confirmed! See you at the event."

4. On Failure → Send a reply: "We couldn't find you on the list. Please check your spelling or contact support."

The Search Google Sheets action is available in all WhatsApp automation flows, and is especially useful for data validation, real-time customer lookups, inventory checks, appointment verification, and low-code integrations with your Google-based systems.