Articles on: Integrations

How to Integrate WANotifier with Google Sheets™?

The WANotifier add-on for Google Sheets™ turns your spreadsheet into a WhatsApp automation tool. When rows are added or changed, it can send WhatsApp template messages or add and update contacts in WANotifier. Use it to welcome new leads, confirm orders, send an update when a status column changes, or keep your contact list in sync. It also works with Google Forms™: every form response that lands in your sheet can trigger an automation.


This guide walks you through installing the add-on, connecting your account, and creating your first automation.


What you can automate


Each automation has these parts:


  • Automation type: what it does. Choose Add / update contact or Send message template (via Notification).
  • When: the event that starts it. Choose from New row added, Row updated, or Column updated.
  • Only if (optional): conditions the row must match, e.g. Status is Paid.
  • Contact details or Recipient details + Notification: the contact fields or the message to send, with your sheet's columns mapped to them.


Before you start


1. Add column headers in row 1. The add-on identifies columns by their header name, e.g. Name, Phone, Order ID. Moving or inserting columns later won't break anything.


2. To send messages, create a Transactional Notification in WANotifier. You can skip this if you only want to add or update contacts. Go to Notifications → Add New and:


  • Give it a name (e.g. "Order confirmation from Google Sheets").
  • Select type as Transaction / Integration / API.
  • Select trigger as API request to a Webhook URL.
  • Pick the message template you want to send.
  • Keep Webhook Request Data as Default.
  • Save.


This is the same kind of notification used with our Zapier, Make, Pabbly and n8n integrations. See how to create a Transactional Notification for details.


Step 1. Install the add-on


  1. Open your Google Sheets™ spreadsheet.
  2. Go to Extensions → Add-ons → Get add-ons.
  3. Search for WANotifier and click Install.
  4. Allow the permissions Google asks for. The add-on only accesses the spreadsheet you use it in.


Once installed, open it any time from Extensions → WANotifier: WhatsApp Automation for Sheets™ → Open WANotifier.


Step 2. Connect your WANotifier account


  1. In the WANotifier sidebar, paste your API key. You can create a new key from the Integrations → API Integration → API Keys page in your WANotifier account.
  2. Click Connect.


The connection is saved per spreadsheet. Everyone who edits the sheet sees the same connection, but nobody can view the API key. To check the connection or disconnect, click the settings icon at the top right of the sidebar.


Step 3. Create an automation


Click + New in the sidebar, give the automation a name, and pick the Automation type. Each part of the form appears once the one before it is filled in.


When


  • Sheet: the tab to watch. Click the refresh icon if you just added columns or tabs.
  • Trigger:
    • New row added: runs when a new row is complete, i.e. when it has the WhatsApp number and every column used in your template variables. A row typed cell by cell runs once, when the last of these is filled. Pasted rows and Google Forms™ responses run right away.
    • Row updated: runs when any cell in a row is edited. Add a condition to avoid extra runs.
    • Column updated: runs when a cell in the columns you pick changes to a new value. Clearing a cell doesn't run it. For example, watch the Status column and add a condition Status is Shipped.


Only if (optional)


Click + Add condition to only run for matching rows. Pick a column, an operator (is, is not, contains, does not contain, is empty, is not empty, is greater than, is less than) and a value. With more than one condition, choose whether all or any must match. Text comparisons ignore upper and lower case.


To make New row added wait for another column, add a condition like Status is not empty.


Contact details (Add / update contact)


Creates the contact in WANotifier, or updates it if the WhatsApp number already exists.


  • WhatsApp Number (required): usually your phone column, e.g. {{Phone}}. Must include the country code.
  • First Name and Last Name (optional).
  • Status: Subscribed (broadcasts go to this contact) or Unsubscribed (skipped in broadcasts). Defaults to Subscribed.
  • Tags and Lists (optional): tick the ones to add the contact to.
  • Attributes (optional): click + Add attribute, pick a custom attribute and map a value to it, e.g. {{City}}.
  • Replace Tags, Lists & Attributes: Yes replaces the contact's current tags, lists and attributes with the ones you set here. No adds them to what the contact already has, and only updates the attributes you set. Defaults to Yes.


Recipient details and Notification (Send message template)


  • Recipient WhatsApp Number (required, with country code), plus Recipient First Name and Recipient Last Name (optional).
  • Select Notification (required): pick the Transactional Notification you created. Click the refresh icon if you just created it.
  • Map template variables (all required): one field for each variable in your message template. This covers every variable type a template can have: the header text variable, the header image, video or document URL, all body variables, and button variables (dynamic URL or coupon code).


Mapping your columns


To fill a field with data from the row, click the {} merge tag button next to it and pick a column. You can mix columns with your own text, e.g. Order #{{Order ID}}. Besides your columns, you can also use Row details such as the row number, sheet name, and the old and new value of a changed cell.


The Save button turns on once everything required is filled in.


Managing automations


  • Use the switch next to an automation to turn it on or off.
  • Click an automation to edit or delete it.
  • Needs attention means a column the automation uses was renamed or deleted, or its sheet was deleted. Rows are skipped, not sent with blank values, until you fix it.
  • Click Activity to see the latest results: each message sent, each contact saved, and anything skipped or failed, with the reason.


Using it with Google Forms™


  1. In Google Forms™, open Responses → Link to Sheets and link the form to your spreadsheet.
  2. In the sidebar, create an automation on the Form Responses tab with the trigger New row added.


Each response runs the automation right away. Your form questions become the column headers you map from. If respondents can edit their answers, an edited response runs the automation again.


Working with your team


  • Everyone with edit access to the sheet sees the same connection and automations. To open the sidebar, each person needs the add-on installed.
  • Edits by anyone trigger the automations, including people who don't have the add-on.
  • Automations run from the Google account of the person who turned on the first one. You can see whose account in Settings. If that person loses access to the sheet, another editor can click Run from my account in Settings.


Tips and limitations


  • Phone numbers must include the country code, e.g. +919876543210 or 919876543210. Spaces, dashes and brackets are removed automatically.
  • Header media (image, video, document URLs) must be public URLs that WhatsApp's servers can open. Sharing links from Google Drive™ or Dropbox won't work.
  • Values are sent as you see them in the sheet, so dates and numbers keep their formatting.
  • Rows added by other apps don't trigger automations. Google Sheets™ only runs add-on triggers for edits made in the sheet itself and for Google Forms™ responses. Rows written by tools like Zapier, Make, a CRM sync, scripts, or formulas (including IMPORTRANGE) are not detected. If another tool adds the rows, add a WANotifier step to that tool's workflow instead using our Zapier, Make, Pabbly or n8n integrations.
  • Copies start fresh. If you use File → Make a copy, the copy is disconnected and its automations are off.
  • Header renames: if you rename a column header, update the automations that use it.


That's it! Your spreadsheet can now send WhatsApp messages and keep your contacts up to date on its own. If you run into any issues or need help setting up an automation, our support team is always happy to help, just reach out from your dashboard.


Google Sheets™, Google Forms™ and Google Drive™ are trademarks of Google LLC. WhatsApp is a trademark of WhatsApp LLC.

Updated on: 12/11/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!