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
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
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
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?
Troubleshoot common errors in WATI
Our Roadmap - See What's Planned
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
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
Types of Messages
What are template formatting rules?
How to get Opt-in for WhatsApp Messaging?
What is the difference between template message and session message?
What is the max numbers of template message submission?
What is a template message?
Could I attach a PDF or image into a template message?
How to use interactive messages?
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 are difference between BASIC plan and PRO plan
APIs & Integrations
Where can I find the documentation for WhatsApp Business APIs?
Key Differences Between WATI CRM and WATI WhatsApp API Gateway
Does WATI support Dialogflow Integration?
How can I send WhatsApp Message from Zoho CRM?
What if I need access to more APIs?
Where can I find WATI API Documentation?
Can I send OTP on WhatsApp?
How can I add webhooks using WATI or WhatsApp API Gateway?
Add-on: Google Spreadsheet Sender
What are fix variables for Shopify integration?
WhatsApp Shop Plugin
Zoho CRM Integration
WhatsApp Chat Button Integration
Shopify Integration for TRIAL user
What are fix variables for Woocomerce integration?
Team Inbox on WATI
WATI Account running Slow
How to change the topic name on 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
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
Export and Import of Flows
How to collect data using Google Spreadsheets
How to update data using Google Spreadsheets
Broadcast Messaging & Templates
How do I edit, delete or cancel 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 & SMS Fallback?
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 do I check and add credit to send broadcast template message
Personalization & Account 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
Terms, Privacy & Security
Updated by Sophia
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
- + 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
- 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.