## **I.** **HOW TO INSTALL**


1. Open the browser and login into your Google account and go to the Google Spreadsheet.

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/86421312-6d65-4c24-8476-7b3e91d77e4f/7f5d9f6a-059d-4da2-84b6-31d31a8744d5/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250520%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250520T051305Z&X-Amz-Expires=3000&X-Amz-Signature=20c0f88461d1f0ae61b6639fb2f1628af9d46648414d08754a442c1ffbeb2af0&X-Amz-SignedHeaders=host&response-content-disposition=attachment)


2. 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:

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/86421312-6d65-4c24-8476-7b3e91d77e4f/1347eeaf-cfbe-414d-b34d-82ac797cca22/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250520%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250520T051305Z&X-Amz-Expires=3000&X-Amz-Signature=5faec3141e30507d8890e20a0e5d7438d5d5eef968deb7c6c0a0552e9436008a&X-Amz-SignedHeaders=host&response-content-disposition=attachment)


3. Type: “WhatsApp Message Sender WATI” to find and install add-on:

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/86421312-6d65-4c24-8476-7b3e91d77e4f/b578fc29-b407-4e3c-b85e-b5f430044e2d/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250520%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250520T051305Z&X-Amz-Expires=3000&X-Amz-Signature=ab2ec8ed1f1268142d31f27b93a966f5b2ee4406ef3fcbf65d2c38db2b1436b2&X-Amz-SignedHeaders=host&response-content-disposition=attachment)

## **II.** **HOW TO USE:**


1. Click to Add-ons menu of Google Spreadsheet, choose WhatsApp Message Sender-->WhatsApp Schedule to open this addon:

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/86421312-6d65-4c24-8476-7b3e91d77e4f/4452e6eb-9b22-4f0e-8d9f-0140e294224b/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250520%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250520T051305Z&X-Amz-Expires=3000&X-Amz-Signature=8c3b49f057e63444a6f3f2d8635b17537c661d564003e6b4ffbee84ba6f1a2be&X-Amz-SignedHeaders=host&response-content-disposition=attachment)


2. 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**.

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/86421312-6d65-4c24-8476-7b3e91d77e4f/0a4f5ec0-124d-47d9-a797-b4ef72bf4565/5.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250520%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250520T051305Z&X-Amz-Expires=3000&X-Amz-Signature=8f809e210a109df88e23a8b675c4651be2169541e8fe2c0ab7f43b67235eea67&X-Amz-SignedHeaders=host&response-content-disposition=attachment)

Press **OK** to go to the next step.


3. In this step, if you only have trial account at [app.wati.io](https://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.

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/86421312-6d65-4c24-8476-7b3e91d77e4f/0367ebea-e8ac-42f1-9637-e833f02405fb/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250520%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250520T051305Z&X-Amz-Expires=3000&X-Amz-Signature=05623ac49a49b72d26f11bfaac371068d1df9236898e55b362ad2ba2a1ac4d6f&X-Amz-SignedHeaders=host&response-content-disposition=attachment)

**3.1** **Using Add-ons as a trial user:**

* If you don't have a trial account you can click on the “Sign Up for Free Trial” link and type your WhatsApp number, check to “I agree to [Terms & Conditions](https://www.wati.io/terms-and-conditions/) and [Privacy Policy](https://www.wati.io/privacy-policy/)” then click "Submit" button, you will receive the notification as follows: ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/86421312-6d65-4c24-8476-7b3e91d77e4f/ee66fb56-5163-42f0-9208-049dd97010f5/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250520%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250520T051305Z&X-Amz-Expires=3000&X-Amz-Signature=e61a5573d5909c329ae7b89b8dea89d8c2dcb27b91c345792ca1cdf0bc3a9631&X-Amz-SignedHeaders=host&response-content-disposition=attachment)Click to **OK** button to next step.
* 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:

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/86421312-6d65-4c24-8476-7b3e91d77e4f/2f80531c-cb1f-4689-b7b3-5b23e686a27d/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250520%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250520T051305Z&X-Amz-Expires=3000&X-Amz-Signature=88c8f5064355e52a497af81876e53e05cb5a93a16aff2e3f74c02552f1ff991c&X-Amz-SignedHeaders=host&response-content-disposition=attachment)

* 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:

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/86421312-6d65-4c24-8476-7b3e91d77e4f/45d4070c-37cc-43cd-89d3-45912baa5c27/selecting-variables.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250520%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250520T051305Z&X-Amz-Expires=3000&X-Amz-Signature=00b8e019f391edd1a365ae62fee3e3bee0c745144752d7ffeb3247989195ceca&X-Amz-SignedHeaders=host&response-content-disposition=attachment " =601x492")

* In the next step: You can preview your message before sending:

  \- The total number of recipients

  \- Cost

  \- 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:

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/86421312-6d65-4c24-8476-7b3e91d77e4f/d5b4daec-199e-4494-9e08-350c9e11bdd2/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250520%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250520T051305Z&X-Amz-Expires=3000&X-Amz-Signature=93205237bdcc7547cddfbf7f76d4e99eedf82cced85283e4216956a20419cd6d&X-Amz-SignedHeaders=host&response-content-disposition=attachment)

* "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.

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/86421312-6d65-4c24-8476-7b3e91d77e4f/0cf24354-90f8-423f-9755-6598b38ebca6/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250520%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250520T051305Z&X-Amz-Expires=3000&X-Amz-Signature=ab69e07924f398bc7610c72ce170ffc5bf354f3d3639c2563828ae437f625c78&X-Amz-SignedHeaders=host&response-content-disposition=attachment)

* Press "TEST" button to make sure your values are valid and connection to your environment could be made.

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/86421312-6d65-4c24-8476-7b3e91d77e4f/a42bae22-d60c-4bda-887e-ef5fbf1448e0/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250520%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250520T051305Z&X-Amz-Expires=3000&X-Amz-Signature=bf09aea80ce739428e8f40a2aca4146ea80c6e70378aeeeb8409cbf15e0020c8&X-Amz-SignedHeaders=host&response-content-disposition=attachment)

* Click "Save" button to proceed to send a message. After sending the message successfully, you will receive the notification as below image:

 ![](https://brainfish-storage-prod.s3.us-east-2.amazonaws.com/uploads/86421312-6d65-4c24-8476-7b3e91d77e4f/eea7e938-4950-4256-91b3-bdf28dc66a0e/migrated?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUPPN5IL3QLQZLDSU%2F20250520%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20250520T051305Z&X-Amz-Expires=3000&X-Amz-Signature=eceb97475eaf49121487a7802bd0958f74f76799ef45ea780d8b68cac0b6ed58&X-Amz-SignedHeaders=host&response-content-disposition=attachment)




Add-on: Google Spreadsheet WhatsApp Message Sender

Cloud API

Are your file attachment names appearing as null or untitled?

Where can I find the WATI API Endpoint URL and Bearer Token?

Where can I find WATI API Documentation?

How can I add webhooks using WATI or WhatsApp API Gateway?

Can I send OTP on WhatsApp?

How to track Template Messages using Webhooks

WATI APIs

Integrating WATI with Bitrix24

Integrating PayTab Payment Gateway with Wati

ActiveCampaign Integration

How to import leads and contacts from Salesforce? 

Salesforce Integration

Klaviyo Integration

Create a Contact in WATI when a new contact is created in Klaviyo

Klaviyo

Set up your payment configuration on WhatsApp

Payment

WATI LeadSquared Integration

LeadSquared WhatsApp Integration: Capture All New WhatsApp Contacts To LeadSquared

WhatsApp Templates for Leadsquared

LeadSquared

Make.com Integration (Formerly Integromat)

Make.com / Integromat

Integrating Wati with Calendly (via Pabbly)

Zapier Integration

Zapier Native Integration

Zapier Webhook Integration

Zapier

Hubspot Integration

HubSpot WhatsApp Integration: Capture New WhatsApp Contacts To HubSpot For Free [Deprecated]

Create contact in HubSpot when new user messages your WhatsApp number

Hubspot

WooCommerce Integration

What are fixed variables for Woocomerce integration?

How to use pre-defined variables in WooCommerce?

WooCommerce

WATI Embedded Team Inbox in Zoho

Zoho CRM Integration: A Step-by-Step Guide to Connecting Zoho with WATI

Why is my Zoho integration not working?

How to get Contact Attributes from WATI into Zoho CRM Leads/Contacts?

How to send template message using Zoho CRM Workflow?

Get Notifications for new messages on WATI on Zoho CRM

Convert first time visitors to Zoho Lead/Contact using Zoho Flows

Assign chats in WATI based on Lead owner in Zoho CRM

Create a contact in WATI when a new lead comes into ZOHO CRM

Zoho

WhatsApp Shop Plugin

Add-on: Google Sheet Automation

Why Google Sheet Automation is not working?

Why Whatsapp Message Sender is not working?

How to trigger Whatsapp Shop using Templates

Google Sheets

Google Calendar Integration

WhatsApp and Razorpay Integration

Measure ROI for Broadcast Campaigns

How to Integrate Shopify app to Wati paid account

Shopify Integration for TRIAL user

Variables available for Wati Shopify app integration

How to use pre-defined variables in Shopify?

How to setup Cash On Delivery Automated message in Shopify app

How to add/import Shopify Contacts into WATI

Why are my Cash on Delivery Messages (COD) not sending in Shopify?

Cash On Delivery and Abandoned Cart analytics in Shopify app

How to Add Product Images in Abandoned Cart, Cash On Delivery & Order Confirmation Messages

How to enable checkout flow for Shopify catalog orders

Additional Custom Parameters Available for Wati Shopify App Customers

Enable Support for Your Shopify Stores Third Party Checkout Providers

Overview of Optin tools available in Wati Shopify app

How to include Discount coupon in Shopify Automated messages

Shopify

How to Integrate Wati with Calendly

Wati & Eber Integration: Overview

Connecting Wati to Eber: A Step-by-Step Guide

Syncing Welcome Message & Members 

How to Send WhatsApp Reward Confirmations Using Eber and Wati

Integrating Wati with Eber

WATI Integrations

WATI Integrations and API's

How to Use a Phone Number Previously Registered With WhatsApp Business

How to Update the Connected Phone Number and Business Portfolio

How to Connect Your WhatsApp Number to Wati

Getting Free WhatsApp Business Phone Numbers from Meta

How to Reconnect your Phone Number to Wati

Understanding Your WhatsApp Phone Number Connection Status

Migrating Your WhatsApp Business Account from Another BSP to Wati

Connecting Your WhatsApp Phone Number to Facebook and Instagram

Creating a QR Code for Your WhatsApp Number

Choosing the Right Phone Number for WhatsApp

Phone Number Guide: Everything You Need To Know

Manage Multiple WhatsApp Numbers in a Single Wati Account

Connect Your Number

How to Enable Two-Factor Authentication (2FA) in Wati

Is Wati GDPR (General Data Protection Regulation) Compliant?

Wati Security and Data Management

How to Check Known Issues on Wati

Privacy & Security

General FAQs: Marketing Messages Lite (MM Lite) 

What are the most frequent problems encountered in the Embedded Signup process?

How to create or send your First Broadcast

Prerequisites before you Get Started with Wati

How to Create your First Chatbot

Creating Your Wati Account

How to Change or Update your Display Name on Wati

Guidelines to Choose your Display Name

How to Set Up or Update Your WhatsApp Account Profile

How to Change Your Timezone in Wati

How to Change the Language in Wati

Managing Notifications and Sounds in Wati

How to Configure Auto replies and OOO messages

How to Create Your First Template Message

How to Add your First Contact

Introduction to the Team Inbox

Marketing Messages Lite (MM Lite): All you need to Know

Getting Started

Steps to Complete Facebook Business Verification

How to Raise an Appeal for Account Review

How to Apply for Official WhatsApp Business Account (Blue Tick Verification)

A Deep Dive into WhatsApp Manager: What You Should Know

How to Check WhatsApp Business Account (WABA) Status

How to Access the WhatsApp Manager

WhatsApp Business Account (WABA): Everything You Need To Know

How to Find Your Facebook Business Manager ID (BMID)

How to Check If Your Business Is Verified by Facebook

Facebook Business Verification: Required Documents by Country

How to Enable the 'Start Verification' Button in Facebook Business Manager

How to Contact Facebook Team for Business Verification Issues

Reasons Why Your Business Can't be Verified

How to Increase Your WhatsApp Messaging Limit Without Meta Business Verification

Is Facebook Business Verification Required? 

Facebook Business Verification: Everything You Need To Know

Set Up Web-hooks for WhatsApp Business Account Notifications

How to Appeal if your Account is Banned due to WhatsApp Policy Violation

Why your Business Could be Rejected or Banned by WhatsApp? 

WhatsApp Commerce Policy Rejection (CPR)

Get Verified by Facebook

How to Export Chats in Wati

General FAQs: Wati 

Premium Customer Support

Basic Customer Support

Standard Customer Support

Types of Support Available at Wati 

How to Contact Wati Customer Support

Service Add-On: Premium Onboarding

Service Add-On: Technical Account Manager (TAM)

Service Add-On: Professional Services

Customer Support and Premium Services

Introducing Wati Mobile App UI 

Wati Mobile App Features: What's Included?

Wati Mobile App

How to Book a Demo with Wati

Explore Wati with a 7-Day Free Trial

How to Customize Your Wati Subdomain

How to Create WhatsApp Click-to-Chat Links

How to Scan the Wati Trial QR Code

How to Integrate WhatsApp Chat Button

Signing up for a Wati Trial

What is Wati - WhatsApp Team Inbox? 

Understanding Wati Add-Ons and Their Pricing

Understanding Wati's Pricing Structure

How to Estimate your Conversation Usage Cost

What is Conversation Based Pricing?

How to Check Credit Usage History

How to Set Up Auto Recharge for Credits 

How to Top Up or Add Credits in Wati

Understanding Wati Credits

Understanding Wati Plans

Understanding Monthly Chatbot Sessions

Understanding Automation Triggers and Their Cost

Wati Pricing: A Complete Guide

Introducing Pay-as-you-Go (PayG) Plan

Wati Vs WhatsApp Business: What's the Difference?

Wati Overview

How to Connect Multiple WhatsApp Numbers to your Wati Account

How to Connect Your WhatsApp Phone Number to Facebook and Instagram Pages

Getting Started with Rule-Based Automation in Wati

Understanding Automation Triggers in Wati

How to Create Keyword-Based Rules

How to Set Up Actions in Wati

How to Set Up Filters in Rules

How to Automatically Assign a Chat to the Last Assignee

Rule Based Automation

How to Create and Use WhatsApp Flows in Wati

Understanding Custom Attributes for WhatsApp Flows in Wati

Configuring Default Action in Wati

How to Use the Sequence Feature

Setting Up Reply Materials

What are Reply Materials?

Automation: Everything you need to know

Automating Replies with Keyword Matching

Understanding Keyword Actions

How to Set Up Keyword Actions

Setting Up Routing

How to Set Your Working Hours in Wati

Automation

How to Transcribe Audio Messages (Beta)

How to Start a New Chat

How to Add Contacts to Your Favorite List

How to Add Tags to Conversations in Wati

Shared Team Inbox