Getting Started
WhatsApp Number
How To Import WhatsApp Chats
How To Add WhatsApp Number On Facebook or Instagram Page
How should I choose a phone number for WhatsApp?
PRO plan: Support export chat
Backup WhatsApp Chats
How to migrate a phone number from one BSP to another?
Steps to use phone number that has been registered with Whatsapp Business before
How do I scan the QR Code on WATI Trial?
Can you call the WhatsApp number, that's already registered to use WhatsApp Business API?
How can I create a QR Code for my WhatsApp Number?
Can I get Green Tick Verification on my Personal Number?
How To Link WhatsApp Number To Facebook Page
Display Name
Introduction
How to check any known issues with WATI?
What are the limitations of using WhatsApp Business APIs?
What kind of business will be rejected by WhatsApp?
Approve Messaging On-Behalf-Of your brand
How do I get Green Tick Verification for my business?
How long does it take to get approved for WhatsApp Business APIs?
What is the process to get approval for WhatsApp Business APIs?
Creating click to chat link
WhatsApp Manager
Everything you need to know about your WhatsApp Manager
How can I change my display name
How to access WhatsApp Manager?
How to change your phone number
Facebook Business Manager ID
Embedded Sign Up
untitled article
Can I get WhatsApp API access without Facebook Business Verification?
What are possible common errors in embedded signup flow?
Facebook Business Verification
Why is Facebook Business Verification required?
What if the 'Start Verification' button is greyed?
How to check whether your business is verified?
What are the steps to get Facebook Business Verification?
What documents are required for Facebook Business Verification?
How can I contact Facebook Team for Business Verification Issues?
How to top-up WATI credits?
Troubleshoot common errors in WATI
What's New
Released in 2020
2020.12.1 - Released on Jan 2021
2020.11.1 - Released on Dec 2020
2020.10.1 - Released on Oct 2020
2020.09.1 - Released on Sept 2020
2020.08.1 - Released on Aug 2020
2020.07.1 - Released on July 2020
2020.06.1 - Released on May 2020
2020.05.1 - Released on May 2020
2020.04.1 - Released on Apr 2020
RBI e-Mandate Latest Guidelines
Released in 2021
2021.07.1 - Released on Jan 2022
2021.06.1 - Released on Nov 2021
2021.05.2 - Released on Sep 2021
2021.05.1 - Released on July 2021
2021.04.1 - Released on May 2021
2021.03.1 - Released on Apr 2021
2021.02.1 - Released on Mar 2021
2021.01.1 - Released on Feb 2021
Our Roadmap - See What's Planned
2022.05.2 - Releasing on June 2022
2022.05.1 - Released on 18th May 2022
2022.04.2 - Released on 22nd April 2022
2022.04.1 - Released on 6th April 2022
2022.03.2 - Released on 25th Mar 2022
2022.03.1 - Released on Mar 2022
2022.01.2 - Released on Feb 2022
2022.01.1 - Released on Feb 2022
Types of Messages
Template Message
What are template formatting rules?
How to get Opt-in for WhatsApp Messaging?
What is the difference between template message and session message?
How many template messages can be submitted for WhatsApp approval?
What is the max numbers of template message submission?
What is a template message?
How to trigger a flow with template?
Could I attach a PDF or image into a template message?
Session Messages
How to use interactive messages?
Pricing
Conversation Based Pricing
WATI CRM & APIs
What is the pricing for WATI CRMs & APIs?
What are the costs for sending messages?
How much is the setup cost for WATI CRM & APIs?
WhatsApp API Gateway
What are the costs of sending Business Initiated and User Initiated Conversations?
What is Conversation Based Pricing?
What are difference between BASIC plan and PRO plan
APIs & Integrations
WhatsApp APIs
Where can I find the documentation for WhatsApp Business APIs?
Key Differences Between WATI CRM and WATI WhatsApp API Gateway
WATI APIs
Does WATI support Dialogflow Integration?
How can I send WhatsApp Message from Zoho CRM?
What if I need access to more APIs?
Are your file attachment names appearing as null or untitled?
Where can I find WATI API Documentation?
Can I send OTP on WhatsApp?
How can I add webhooks using WATI or WhatsApp API Gateway?
Integrations
Shopify
How to add/import Shopify Contacts into WATI
Shopify Integrations for Paid WATI Users
What are fixed variables for Shopify integration?
Shopify Integration for TRIAL user
Add-on: Google Sheet Automation
Integromat Integration
Add-on: Google Spreadsheet Sender
Hubspot Integration
How to use pre-defined variables in Shopify or Woocommerce?
WooCommerce Integration
WhatsApp Shop Plugin
Zoho CRM Integration
How to send template message using Zoho CRM Integration?
WhatsApp Chat Button Integration
WATI Embedded Team Inbox in Zoho
What are fixed variables for Woocomerce integration?
Zapier Integration
Where can I find the API Endpoint URL and Bearer Token?
HubSpot WhatsApp Integration: Capture New WhatsApp Contacts To HubSpot For Free
LeadSquared WhatsApp Integration: Capture All New WhatsApp Contacts To LeadSquared
Team Inbox on WATI
Team Inbox
WATI Account running Slow
How to add a tag to chat?
Copy Conversation URL
What happens if someone you blocked messages you again?
How to use quick replies/canned replies?
What features does WATI Team Inbox offer?
How to start a new Chat?
How to add contact to Favorite?
How to add custom parameters?
How to download chats from WATI?
How to search and filter chats?
Automation - Building a chatbot
Routing
Keyword Action
Flow
What features are available in advance flow builder
Advance flow builder: Update Attribute
Advance flow builder: Template
How to use Conditions for Flowbuilder
What and how to access Flow Builder?
Advance flow builder: Setup Assign Agent / Assign Team
How to use Questions for Flowbuilder
Advance flow builder: Setup Subscribe or Unsubscribe
Advance flow builder: Webhook
How to build a flow
Advanced Flow Builder: Invoke New Flow
How to create list message & message with reply button?
Advance Flow Builder: Time Delay
Flow Builder: What is a node and how many types of node?
Why is my flow not working?
Export and Import of Flows
How to collect data using Google Spreadsheets
How to update data using Google Spreadsheets
Reply Material
Default Action
Introduction
Broadcast Messaging & Templates
Broadcast
How to allow users to Opt-Out or Unsubscribe from Broadcasts?
How do I edit or delete a scheduled broadcast?
What is a Broadcast History?
What is a broadcast?
How do I add a new Broadcast?
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 can I search and filter Broadcasts?
Where can I see Broadcast Statistics?
Template Messages
How to submit template messages on WhatsApp Manager for WhatsApp API Gateway
What are the supported languages for template update?
How to avoid template message rejection?
What are the category values of Template Message?
Template Message Guidelines
How to export and import template messages from one environment to a new environment?
How to add buttons with template messages?
How do I create a Template Message?
Are non-transactional messages allowed with WhatsApp Business APIs?
What are actions in Template Messages Page?
How to setup auto recharge for broadcast credit?
How to add buttons to templates?
How do I check and add credit to send broadcast template message
Contact Management
Personalization & Account Management
Operator Management
How to view, search and delete operator?
How to force logout a specific user from all active sessions?
Detail Access Menu of each Roles
How do I add more agents to my account?
How to add team and assign operator to team?
Account & Billing
How do I unsubscribe from WATI?
How can I download the past invoices?
What are the working hours for WATI Support Team?
How can I manage the billing and payment methods?
Personalize your account
Dashboard and Reports
Mobile Apps
Mobile Apps
Get your own WATI custom subdomain
Do I have to pay additional to access WATI Mobile Apps?
What features do WATI Mobile Apps have?
What does WATI Mobile App do?
Mobile Released 2022
Mobile version 2.5.0 - Released on 15th Feb 2022
Mobile version 2.7.0 - Released on 14th Mar 2022
Mobile version 2.6.0 - Released on 23rd Feb 2022
Mobile version 2.9.0 - Released on 30th Apr 2022
Mobile version 3.1.1 - Released on 22nd June 2022
Mobile version 3.0.0 - Released on 15th May 2022
Mobile version 2.4.0 - Released on 29th Jan 2022
Mobile version 3.0.3 - Released on 22nd May 2022
Mobile version 2.7.1(hotfix) - Released 24th Mar 2022
Mobile version 2.2.0 - Released on 7th Jan 2022
Mobile version 2.8.0 - Released on 8th Apr 2022
Mobile version 2.3.0 - Released on 20th Jan 2022
Terms, Privacy & Security
- All Categories
- Automation - Building a chatbot
- Flow
- How to collect data using Google Spreadsheets
How to collect data using Google Spreadsheets
Updated
by Helpdesk
What can this do?
This is a feature within our Pro Plan add-on, which allows you to collect the data your users provide in Whatsapp and automatically feeds into Google Spreadsheets, reducing the need to manually input data. No additional installation is needed.
Why do you need it?
This feature is handy for small business teams who don’t have the budget for a separate CRM feature, or if your team spends a lot of time manually inputting data, you can capture the data you need automatically into Google Spreadsheets. Reducing both time and cost for your company.
Setting up your flow and configuring Google Spreadsheet
Create your flow:
- Go to Automation
- Flows
- + Add Flow
- Drag elements on the left to create flow
Where you slot the Google Spreadsheet button, this is when it will trigger to input the data. You can also choose to slot it after each data entry point if you wish.

Connecting to the Google Spreadsheet node:
- Hover over the edit button on the Google Spreadsheet node
- Add your Google account and allow permissions
- Select the spreadsheet you want the data to be inputted in
- Select which sheet tab of the spreadsheet for data input

If you are creating a spreadsheet for the first time, choose "insert a new row". Then, enter the variables that you wish the Google Spreadsheet to track, they should match the same as your flow variables and Google Spreadsheet column variables.

Click "save" and then remember to "save" your flow too.
Setting up the keywords: Now you need to configure the keywords for this flow so that the user can trigger the flow
- Go to Automation
- Keyword Action
- Add Keyword Action

Enter the unique keyword that you want the user to be able to trigger the flow, such as "I am a new customer", you can choose exact matching or fuzzy matching.
- Click on the next step
- Flows
- Search the name of your flow
- Tick the box of the flow and save
How to Test
Use your registered WATI account number and type in the keyword to activate the flow. Here typing "I am a new customer" will activate this flow within Whatsapp.

The data will automatically update in the selected Google Spreadsheet, as shown below:

This sheet will automatically input data whenever the user triggers the flow, you can proceed to share the spreadsheet with anyone else in your team for their viewing.