Book a Demo
Try our product
How to get more Add-On Users?
Wati Pricing Update
What are Monthly Chatbot Sessions?
Wati Pricing Plans
Export Chats from Wati
What is the pricing for Wati?
Conversational Based Pricing
WhatsApp Pricing Update - New Conversation Categories
How to top-up WATI credits?
What is Conversation Based Pricing?
Estimating your conversation usage cost
How to top-up WATI credits?
Set up your WATI account
Before you sign up to WATI
Get your own WATI custom Sub-domain
What is the difference between Whatsapp Business and WATI?
Get started with WATI
Sign up and get started with WATI in 10 steps
Create your first chatbot in WATI
Connect your number in WATI
Subscribe to WATI
How to add contacts?
How to send a broadcast?
How to create a template message?
Introduction to Team Inbox
WhatsApp account profile set-up
How to add operators and create teams
Auto replies and OOO messages
Embedded Sign Up
WhatsApp Manager ID (WABA)
More from us!
Our Roadmap - See What's Planned
How to add WhatsApp number to Facebook or Instagram pages
WhatsApp Chat Button Integration
Creating click-to-chat link
How can I create a QR Code for my WhatsApp Number?
Commerce Policy Rejection (CPR)
How to subscribe to account update web-hooks?
How to appeal to facebook if Business actually follows WhatsApp Commerce policies?
What kind of business will be rejected by WhatsApp?
Migrate your phone number to WATI from another BSP
How To Import WhatsApp Chats
Backup WhatsApp Chats
How should I choose a phone number for WhatsApp?
Steps to use phone number that has been registered with Whatsapp Business before
Facebook Business Verification
Why your business can't be verified?
How can I contact Facebook Team for Business Verification Issues?
What if the 'Start Verification' button is greyed?
What documents are required for Facebook Business Verification?
What are the steps to get Facebook Business Verification?
How to check whether your business is verified?
Where to find the Facebook Business Manager ID?
Why is Facebook Business Verification required?
Green tick verification for your business
Everything you need to know about your whatsapp number
How to check whatsapp business account status?
WATI and its Features
Team Inbox on WATI
Different types of chat status in WATI
Supported media types & sizes on WATI
Copy Conversation URL
WATI Account running Slow
What happens if someone you blocked messages you again?
How to download chats from WATI?
How to search and filter chats?
How to use quick replies/canned replies?
How to add custom parameters/attributes?
How to add a tag to chat?
How to add contact to Favorite?
How to start a new Chat?
Manage your Contacts on WATI
How to delete contact attribute in bulk?
How to add an attribute in bulk to a list of contacts?
How do I search and sort contacts?
How do I remove contacts?
How can I edit a contact?
How to import contacts from Excel?
How to add attributes to a contact?
How to add a single contact?
Broadcast on WATI
How to easily broadcast to a subset of your Shopify customers on Wati?
Broadcast Sequence Sheet Add-on
Messaging limit for Click-to-WhatsApp Ads (CTWA)
How to allow users to Opt-Out or Unsubscribe from Broadcasts?
Troubleshoot common errors in WATI
How can I search and filter Broadcasts?
Where can I see Broadcast Statistics?
What is a Broadcast History?
How do I edit or delete a scheduled broadcast?
Is there a limit of broadcast messages?
How to send message to someone who is not in the Contact List?
Tips to send personalized media content broadcast to each number
Building your WATI chatbot
How to make a Backward Chatbot?
How does WATI Automation Feature work?
What is WATI Automation Feature?
How to build a Chatbot
How to use Chatbot Timer?
How to use Fallback Message
Automatic chat assignment (Round Robin assignment)
How to test a chatbot?
Why is my chatbot not working?
Advanced Chatbot Builder: Trigger Chatbot
How to create list message & message with reply button?
Advance Chatbot Builder: Time Delay
Export and Import of Chatbots
Chatbot Builder: What is a node and how many types of node?
How to collect data with Google Spreadsheets
Advance Chatbot Builder: Template
What features are available in advance chatbot builder
Advance chatbot builder: Webhook
Advance Chatbot builder: Update Attribute
Advance chatbot builder: Setup Assign User / Assign Team
Advance Chatbot Builder: Setup Subscribe or Unsubscribe
How to use Conditions for Chatbot Builder
How to use Questions for Chatbot builder?
How to build a chatbot?
What and how to access Chatbot Builder?
Mandatory fields & specifications required to be added to product items when creating catalog
How to set up a checkout flow for catalog orders using Wati Chatbot builder
How to add variants for items when Catalog created using Google Sheet
What are item variants in a catalog
How to enable Auto Checkout and collect payment for my Catalog order?
How to collect online payment for catalog orders using Razorpay payment gateway
Orders page to display Catalog orders
How to collect customer order details from Catalog orders using Google sheets
How to use Sync button for Catalog feature
How to trigger a reply message once the “View sent cart” catalog message is sent from customer
What are sets & How to create sets in your catalog
How to use Wati Chatbot builder to send Catalog Messages
How to send Catalog messages via Keyword action
How to enable Catalog feature for your Wati WhatsApp API number
Manage your Users on WATI
How to force logout a specific user from all active sessions?
How to view, search and delete users?
Detail Access Menu of each Roles
How to add team and assign user to team?
Dashboard and Reporting on WATI
Check billing record on WATI
How to check your billing history?
What should you do in case of payment failures?
How can I download the past invoices?
How do I unsubscribe from WATI?
What are the working hours for WATI Support Team?
Personalize your account on WATI
How to change my timezone in WATI?
How to change language for WATI?
How to manage notifications and sound?
Template Messages on WATI
How to use Google Drive to host media files for templates
Troubleshoot template message rejection
How to trigger a chatbot with template?
How to add buttons to templates?
Template Message Guidelines
How to get Opt-in for WhatsApp Messaging?
How to use interactive messages?
Are non-transactional messages allowed with WhatsApp Business APIs?
How to create and submit template messages in WATI?
How do I check and add credit to send broadcast template message
How to export and import template messages from one environment to a new environment?
How to add buttons with template messages?
How to avoid template message rejection?
Could I attach a PDF or image into a template message?
What are the supported languages for template update?
What is the max numbers of template message submission?
What are the category values of Template Message?
What are template formatting rules?
What is a template message?
What are actions in Template Messages Page?
What is the difference between template message and session message?
How do I increase the expiry time of chats?
WATI mobile app
WATI Mobile App (App Store / Google Play)
What does WATI Mobile App do?
Integrations and API's
Integrations on WATI
How to trigger Whatsapp Shop using Templates
Why Whatsapp Message Sender is not working?
Why Google Sheet Automation is not working?
Add-on: Google Sheet Automation
Add-on: Google Spreadsheet WhatsApp Message Sender
WhatsApp Shop Plugin
Create a contact in WATI when a new lead comes into ZOHO CRM
Assign chats in WATI based on Lead owner in Zoho CRM
Convert first time visitors to Zoho Lead/Contact using Zoho Flows
Get Notifications for new messages on WATI on Zoho CRM
How to send template message using Zoho CRM Workflow?
How to get Contact Attributes from WATI into Zoho CRM Leads/Contacts?
Why is my ZOHO integration not working?
Zoho CRM Integration
WATI Embedded Team Inbox in Zoho
How to send template message using Zoho CRM Extension?
How to Add Product Images in Abandoned Cart Message
What does COD and Abandoned Cart in analytics represent?
Why are my Cash on Delivery Messages (COD) not sending in Shopify?
How to add/import Shopify Contacts into WATI
How to create a COD (Cash on Delivery) Message Template for Shopify app
How to set up Cash on Delivery (COD) payment mode for your Shopify store
How to use pre-defined variables in Shopify?
What are fixed variables for Shopify integration?
Shopify Integration for TRIAL user
Shopify Integrations for Paid WATI Users
How to use pre-defined variables in WooCommerce?
What are fixed variables for Woocomerce integration?
Create contact in HubSpot when new user messages your WhatsApp number
HubSpot WhatsApp Integration: Capture New WhatsApp Contacts To HubSpot For Free [Deprecated]
Make.com / Integromat
WhatsApp Templates for Leadsquared
WATI LeadSquared Integration
LeadSquared WhatsApp Integration: Capture All New WhatsApp Contacts To LeadSquared
WhatsApp and Razorpay Integration
Google Calendar Integration
APIs on WATI
Are your file attachment names appearing as null or untitled?
Where can I find the WATI API Endpoint URL and Bearer Token?
What if I need access to more APIs?
Where can I find WATI API Documentation?
How can I add webhooks using WATI or WhatsApp API Gateway?
Can I send OTP on WhatsApp?
WATI App Updates (Release Notes)
Released in 2023
Mobile App - Released in 2023
Terms, Privacy & Security
Beta Testing Program
Table of Contents
Updated by Helpdesk
Watch the video here:
I. HOW TO INSTALL
- Open the browser and login into your Google account and go to the Google Spreadsheet.
- Open an existing Spreadsheet file or create a new file. After the Spreadsheet is opened, choose Add-ons --> Get add-ons as in the following image to install add-on:
- Type: “WhatsApp Message Sender WATI” to find and install add-on:
II. HOW TO USE:
- Click to Add-ons menu of Google Spreadsheet, choose WhatsApp Message Sender-->WhatsApp Schedule to open this addon:
- Select phone numbers by hold and drag mouse in Spreadsheet or type to textbox in our add-on as below example:
- Select a range of cells by inputting or by dragging the mouse: A2:A6.
- Input specific cells and separate by comma (,) eg: A2, A3, A4, A5, A6.
- Mixed: A2:A6, A7, A10.
Press OK to go to the next step.
- In this step, if you only have trial account at app.wati.io, you should choose first option and if your have your personal environment after paying for full version you should choose the 2nd option.
3.1 Using Add-ons as a trial user:
- There is 0.5$ in the wallet for each trial user and you also increase your wallet by click to “BUY CREDITS” button and you also view the message fee table by click to “About template message fee” link as below image:
- Click "Next" button for the next step.
- We choose the message template, set the value for the dynamic available such as Name, City, Role, etc... You can see an example of how we set Name available in the B2:B6 range in the spreadsheet:
- In the next step: You can preview your message before sending:
- The total number of recipients
- The content message list
- Send Now option: send your message instantly
- Schedule option: broadcast will be send at picked date (hours, minutes)
- After the sending message process is done, you will receive the notification as below image:
- "View details" button will redirect you to your account at app.wati.io, to the Broadcast section.
3.2 Using Add-ons as live user:
- Open API Docs section of your environment, and copy Access Token value into "APIKey" field, and API Endpoint value into EndPoint field.
- Press "TEST" button to make sure your values are valid and connection to your environment could be made.
- Click "Save" button to proceed to send a message. After sending the message successfully, you will receive the notification as below image: