How To Import WhatsApp Chats
How To Add WhatsApp Number On Facebook or Instagram Page
How should I choose a phone number for WhatsApp?
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?
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
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?
2021.04.1 - Releasing 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?
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?
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 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
How to change the topic name on chat?
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
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?
What are the supported languages for template update?
How to avoid template message rejection?
What are the category values of Template Message?
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?
What are actions in Template Messages Page?
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 feature allows you to update the data through automation into Google Spreadsheets. As from time to time, you may require your customers to update their details or information.
Setting up your flow and configuring Google Spreadsheet
Create your flow elements, in this example we will ask the user to update their location.
- Go to Automation
- + Add Flow
- Drag elements on the left to create your flow
- Add Google Spreadsheet node at the entry point after last input of data
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 updated in
- Select which sheet tab of the spreadsheet for data input update
- Select Update a row
- Reference Column - input reference against the field you want to be updated
- Update in and by - the field(s) you wish to be updated
Click "Save" and 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, we will use "update location data", you can choose exact matching or fuzzy matching.
- Click on next steps
- 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 "Update location data" to activate the flow.
Google Spreadsheets before flow is triggered in Whatsapp:
Google Spreadsheets after flow is triggered in Whatsapp:
The sheet has automatically updated the location data, because it used the name and phone number to cross reference.