Please note that this Google Spreadsheets feature is an add-on to the regular plan and is charged separately.


:::info
Please note that this Google Spreadsheets feature is an add-on to the regular plan and is charged separately.

:::

## **What is this about?**

This is a feature within our Pro Plan add-on, which allows user to collect the data your users provide on WhatsApp and automatically feed it into Google Spreadsheets. This way, used doesn't need enter data manually. User doesn't need any additional installation for this.

## **How can it be useful?**

This feature is useful for small business teams that don't have the budget for a standalone CRM feature, or if a team spends a lot of time manually filling data. With this feature, a team can capture the information it needs automatically in Google Spreadsheets. This way, both time and costs for the company will be reduced.

### How to connect to the Google Spreadsheet node:


1. Add Google Spreadsheet node to the chatbot by clicking on its icon on the left panel inside the chatbot

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/8ce9edeb-6728-4e9a-aea1-2080a897fd28/daf81cdb-d097-4609-9029-04b9c58462e6/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250705%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250705T184324Z&X-Amz-Expires=3000&X-Amz-Signature=8d8205eee2d8d3bfab3463e43d81b556a996e1b7392e9d787a25e739ffd58e1c&X-Amz-SignedHeaders=host&response-content-disposition=attachment)


1. Click **⋮** icon and choose "Edit"
2. Connect your google account
3. Choose a spreadsheet you intend to collect data into
4. Choose a precise sheet you intend to collect data into
5. Choose an option to insert new data gathered from WATI:

* Insert a new row - choose this if spreadsheet is empty (but this is not required, new rows can be inserted even if spreadsheet is not empty), then enter variables that will become columns in sheet, make sure they're in sync with variables in the chatbot itself.

   ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/8ce9edeb-6728-4e9a-aea1-2080a897fd28/087214cb-4ec0-478d-873a-92f6af427754/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250705%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250705T184324Z&X-Amz-Expires=3000&X-Amz-Signature=a9b76dce4d03d7ed5703ac073fe73e3f1c7425944a2aeed700460c43df8b01d8&X-Amz-SignedHeaders=host&response-content-disposition=attachment)
* Update a row - choose this if there is some data in sheet already, reference column means the column that already exists in the sheet and update in and by means the value user wants to update.

### Example:

User has a sheet with a column named equipment that he wished to be updated. Then, he needs to set up his settings like that:

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/8ce9edeb-6728-4e9a-aea1-2080a897fd28/1eca7ff8-a588-4c7d-b5d2-0ecac73ec923/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250705%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250705T184324Z&X-Amz-Expires=3000&X-Amz-Signature=72b4023ad1d451d59c996945fb3ed39d9c99b63c003c9e5183a3acbe39f6cce2&X-Amz-SignedHeaders=host&response-content-disposition=attachment)

The existing data user wishes to overwrite should be one of the rows filled in equipment column. For example, "no equipment". It will look like this:

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/8ce9edeb-6728-4e9a-aea1-2080a897fd28/f07f3a0e-6bfa-4402-a335-3c56328baebf/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250705%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250705T184324Z&X-Amz-Expires=3000&X-Amz-Signature=e1762f1243f3ed63babcd382c64b655b39c19cae22c5028977240e387bfed85a&X-Amz-SignedHeaders=host&response-content-disposition=attachment)

So all already existing results in your sheet that has "no equipment" value will be overwritten by the newer data.

When all fields are configured to user's desire, click "Save".

## **How does this work exactly?**

Where does new data in case of both options (Insert a new row and Update a row) comes from? It is collected from the recipients replies to buttons or list node. To learn more about them, look [here](https://wati.brainfish.ai/articles/how-to-create-list-message-message-with-reply-button-pwFO4MWMjW).

So the new data is filling spreadsheets from the responses to the buttons/list nodes which has their @value configured correctly.

Example of a working chatbot to gather data:

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/8ce9edeb-6728-4e9a-aea1-2080a897fd28/de870be1-8d79-4631-9e11-f79b2501c8e7/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250705%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250705T184324Z&X-Amz-Expires=3000&X-Amz-Signature=4f16d5112da1e1baaabd6eada921e4a1544337ee4de7e0a6fdc177dcacbcee02&X-Amz-SignedHeaders=host&response-content-disposition=attachment)

In this case Buttons node is used to collect data into google spreadsheets. In its settings value is set up to @equipment, so everything could work in cohesion with the settings of Google Spreadsheet node.

## **How to test it ?**

User can send configured chatbot directly to client through team inbox or set up an automation keyword so for example: when client will write user "I need help with my equipment", [keyword](https://wati.brainfish.ai/articles/how-do-i-add-a-keyword-action-rUWoeLnhi3) **equipment** will be trigger which will result in this chatbot being executed.

The data will be automatically updated in the selected Google Spreadsheet.

In this sheet you will automatically enter the data each time the user activates the chatbot, you can proceed to share the spreadsheet with anyone else in your team to view it.

How to collect data with Google sheets in Chatbots

Triggering the AI Support Agent (KnowBot) from a Chatbot flow

AI Support Agent (KnowBot)

AI Support Agent (KnowBot) Advanced Settings (Rules)

​AI Support Agent (KnowBot)

Whatsapp Flows

Custom Attributes for Whatsapp Flows

Understanding Built-In Automation Rules: Out of Office (OOO) and Welcome Message 

How to create a Rule for keywords

How to create an automation rule?

Learn more about Triggers

Learn more about Actions in Rules

Learn more about Filters in Rules

How to Automatically Assign a Chat to the Last Assignee

Rule-based Automation

CTWA Feature Highlights on WATI

Crash course in CTWA - all you need to know to get started!

Are your CTWA ads giving you good conversions? Track this in Wati with 4 easy steps

Wati and Google CTM Ads

General FAQs: CTWA

Click To Whatsapp Ads

How to manage notifications and sound?

How to change language for WATI?

How to change my timezone in WATI?

Personalize your account

How to add team and assign user to team?

Detail Access Menu of each Roles

How to view, search and delete users?

How to force logout a specific user from all active sessions?

Manage your Users

How to add a single contact?

How to add attributes to a contact?

How to import contacts to Wati?

How can I edit a contact?

How do I remove contacts?

How do I search and sort contacts?

How to add an attribute in bulk to a list of contacts?

How to delete contact attribute in bulk?

Manage your Contacts

Introduction to Team Inbox Analytics

Overview section

Team Inbox scheduled report

Operator Performance chart

Analytics and Reporting

How to enable Catalog feature for your Wati WhatsApp API number

How to send Catalog messages via Keyword action

How to use Wati Chatbot builder to send Catalog Messages

What are sets & How to create sets in your catalog

How to trigger a reply message once the “View sent cart” catalog message is sent from customer

How to use Sync button for Catalog feature

How to collect customer order details from Catalog orders using Google sheets

Orders page to display Catalog orders

How to collect online payment for catalog orders using Razorpay payment gateway

How to enable Auto Checkout and collect payment for my Catalog order?

What are item variants in a catalog

How to add variants for items when Catalog created using Google Sheet

How to set up a checkout flow for catalog orders using Wati Chatbot builder

Mandatory fields & specifications required to be added to product items when creating catalog

Catalog

How Long until My Template is Approved?

How do I increase the expiry time of chats?

What is the difference between template message and session message?

What are actions in Template Messages Page?

What is a template message?

What are template formatting rules?

Template Category Guidelines

What is the max numbers of template message submission?

What are the supported languages for template update?

Could I attach a PDF or image into a template message?

How to avoid template message rejection?

How to add buttons with template messages?

How to export and import template messages from one environment to a new environment?

How do I check and add credit to send broadcast template message

How to create and submit template messages in WATI?

Are non-transactional messages allowed with WhatsApp Business APIs?

How to use interactive messages?

How to get Opt-in for WhatsApp Messaging?

Template Message Guidelines

How to add buttons to templates?

How to trigger a chatbot with template?

Troubleshoot template message rejection

How to create a carousel template

What are limited time offer templates?

Understanding Meta’s Latest Updates on Template Approval

Template Messages

What and how to add a Default Action?

Setting working hours

Default Action

What is a Reply Material?

How do I add a Reply Material?

How to use the Sequence feature?

Reply Material

What and how to access Chatbot Builder?

How to build a chatbot?

How to use Questions for Chatbot builder?

How to use Conditions for Chatbot Builder

Advance Chatbot Builder: Setup Subscribe or Unsubscribe

Advance chatbot builder: Setup Assign User / Assign Team

Advance Chatbot builder: Update Attribute

Advance chatbot builder: Webhook

What features are available in advance chatbot builder

Advance Chatbot Builder: Template

Chatbot Builder: What is a node and how many types of node?

Export and Import of Chatbots

Advance Chatbot Builder: Time Delay

How to create list message & message with reply button?

Advanced Chatbot Builder: Trigger Chatbot

Why is my chatbot not working?

How to test a chatbot?

Automatic chat assignment (Round Robin assignment)

How to use Fallback Message

How to use Chatbot Timer?

How to build a Chatbot

Steps to trigger a chatbot in Wati

How to Trigger a Chatbot Using Rules

Chatbot

How do I add a Keyword Action?

What is Keyword Action?

Keyword Action

Routing

What is WATI Automation Feature?

How does WATI Automation Feature work?

How to make a Backward Chatbot?

Automation

Building your WATI chatbot

Tips to send personalized media content broadcast to each number

How to send message to someone who is not in the Contact List?

Is there a limit of broadcast messages?

How do I edit or delete a scheduled broadcast?

What is a Broadcast History?

Where can I see Broadcast Statistics?

How can I search and filter Broadcasts?

How to Troubleshoot Common Errors? 

How to allow users to Opt-Out or Unsubscribe from Broadcasts?

Messaging limit for Click-to-WhatsApp Ads (CTWA)

How to easily broadcast to a subset of your Shopify customers on Wati?

How can I send catalog messages?

How can I use coupon codes?

"Message Undeliverable" when sending template messages

How can I enable click tracking for my templates?

Why is Meta/Wati restricting my messages?

General FAQs: Broadcasts

How to Use Predefined Segments in Broadcast Campaigns

Broadcast

How to add contact to Favorite?

How to add a tag to chat?

How to use quick replies/canned replies?

How to search and filter chats?

How to download chats from WATI?

What happens if someone you blocked messages you again?

WATI Account running Slow

Copy Conversation URL

Supported media types & sizes on WATI

Understanding Different Chat Statuses

Multi-channel Team Inbox

Phone number masking in Team Inbox

How to add custom parameters/attributes?

How to start a new Chat?

How to Transcribe Audio Messages (Beta)

Team Inbox

Export Chats from Wati

WATI and its Features

How to Contact WATI Customer Support Team

Standard Customer Support

Basic Customer Support

Premium Customer Support

Types of Support Available at WATI

Service Add-On: Premium Onboarding Assistance

Service Add-On: Technical Account Manager (TAM)

Service Add-On: Professional Services

Customer Support and Premium Services 

Auto replies and OOO messages

Get started with WATI

How to add operators and create teams

WhatsApp account profile set-up

Introduction to Team Inbox

How to create a template message?

How to send a broadcast?

Overview

How to add contacts?

Create your first chatbot in WATI

Connect your number in WATI

Get Started with WATI in 10 steps

What is the difference between Whatsapp Business and WATI?

Get your own WATI custom Sub-domain

Creating click-to-chat link

How do I scan the QR Code on WATI Trial?

WhatsApp Chat Button Integration

Backup WhatsApp Chats

How To Import WhatsApp Chats

Explore our Free trial

Book a demo with WATI Team

Try our product

General FAQs: Marketing Messages Lite (MM Lite) 

Migrating from On-Premise WhatsApp Business API to WhatsApp Cloud API

How to Apply for Official WhatsApp Business Account (Blue Tick Verification)

How to access WhatsApp Manager?

Everything you need to know about your WhatsApp Manager

How to check WhatsApp Business Account (WABA) Status?

WhatsApp Manager ID (WABA)

Set up your WATI account