Try our product
Set up your WATI account
Before you sign up to WATI
Migrate your phone number to WATI from another BSP
How To Import WhatsApp Chats
Backup WhatsApp Chats
Get your own WATI custom Sub-domain
Green Tick Verification for your business
How should I choose a phone number for WhatsApp?
What are the limitations of using WATI / WhatsApp APIs
Steps to use phone number that has been registered with Whatsapp Business before
Get started with WATI
Embedded Sign Up
Facebook Business Verification
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?
WhatsApp Manager ID (WABA)
How to check WhatsApp Business Account (WABA) Status?
Everything you need to know about your WhatsApp Manager
How to access WhatsApp Manager?
More from us!
Our Roadmap - See What's Planned
How To Link WhatsApp Number To Facebook Page
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)
PRO plan: Support export chat
What are difference between WATI Standard and Pro plan
Key Differences Between WATI CRM and WhatsApp API Gateway
What is the pricing for WATI CRMs & APIs?
Conversational Based Pricing
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?
What features does WATI Team Inbox offer?
Building your WATI chatbot
Assign chats to your agents in Round Robin style
How to test a flow?
Why is my flow not working?
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
Flow Builder: What is a node and how many types of node?
How to collect data with Google Spreadsheets
Advance flow builder: Template
What features are available in advance flow builder
Advance flow builder: Webhook
Advance flow builder: Update Attribute
Advance flow builder: Setup Assign User / Assign Team
Advance flow builder: Setup Subscribe or Unsubscribe
How to use Conditions for Flowbuilder
How to use Questions for Flow builder
How to build a flow
What and how to access Flow Builder?
Broadcast 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?
How do I add a new 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
Template Messages on WATI
How to use Google Drive to host media files for templates
Troubleshoot template message rejection
How to trigger a flow 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 submit template messages on WhatsApp Manager?
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?
How do I create a Template Message?
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?
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?
Manage your Operators on WATI
How to force logout a specific user from all active sessions?
How to view, search and delete operator?
Detail Access Menu of each Roles
How to add team and assign operator to team?
How do I add more agents to my account?
Dashboard and Reporting on WATI
Payments on WATI
What should you do in case of payment failures?
How can I download the past invoices?
How can I manage the billing and payment methods?
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?
How can I update my WhatsApp Profile Picture & add business details?
How to collect customer order details from Catalog cart messages in a Google Sheet
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 Flow builder to send Catalog Messages
How to send Catalog messages via Keyword action
How to enable WhatsApp Catalog feature for your WATI number
WATI Mobile App (App Store / Google Play)
WATI App Updates (Release Notes)
Released in 2022
2022.09.1 - Released on Dec 2022
2022.07.2 - Released on Oct 2022
2022.07.1 - Released on Sept 2022
2022.06.2 - Released on Aug 2022
2022.06.1 - Released on July 2022
2022.05.2 - Released 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.1 - Released on Mar 2022
2022.01.2 - Released on Feb 2022
2022.01.1 - Released on Feb 2022
2022.03.2 - Released on 25th Mar 2022
Mobile App - Released 2022
Mobile version 3.2.0 - Released on 4th December 2022
Mobile version 3.1.1 - Released on 22nd June 2022
Mobile version 3.0.3 - Released on 22nd May 2022
Mobile version 3.0.0 - Released on 15th May 2022
Mobile version 2.9.0 - Released on 30th Apr 2022
Mobile version 2.8.0 - Released on 8th Apr 2022
Mobile version 2.7.1(hotfix) - Released 24th Mar 2022
Mobile version 2.7.0 - Released on 14th Mar 2022
Mobile version 2.6.0 - Released on 23rd Feb 2022
Mobile version 2.5.0 - Released on 15th Feb 2022
Mobile version 2.4.0 - Released on 29th Jan 2022
Mobile version 2.3.0 - Released on 20th Jan 2022
Mobile version 2.2.0 - Released on 7th Jan 2022
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
Released in 2020
2021.07.1 - Released on Dec 2021
RBI e-Mandate Latest Guidelines
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
3.1.0 Released on Mar 2023
2.11.0 - Released on Jan 2023
2.12.0 - Released on Feb 2023
Terms, Privacy & Security
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
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) Template
How to set up Cash on Delivery (COD) in Shopify
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?
Table of Contents
- All Categories
- Integrations and API's
- Integrations on WATI
- Google Sheets
- Add-on: Google Spreadsheet WhatsApp Message Sender
Add-on: Google Spreadsheet WhatsApp Message Sender
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: