WhatsApp bot integration with Google Sheets to send out messages [Source code + Step-by-Step Guide]

We are pleased to announce the source code release of our script designed to simplify WhatsApp integration with Google Sheets for efficient mailings. This script automatically sends text messages from specified Google Sheets cells to phone numbers also specified in the table cells. After sending the message, the script records the status of each sent message back to the table. Furthermore, if a response is received from the customer, the bot will record the first message received in a separate cell, providing a convenient way to track feedback.

Google Sheets WhatsApp Sender

This source code is open source for use in your current work or can serve as a great starting point for developing your own project. We believe it will become a powerful tool in your arsenal for implementing effective communications and marketing strategies via WhatsApp, using the power of Google Sheets to organize and automate your processes.

To use the script functionality you will need:

1. Api-token of the channel from Whapi.Cloud service;
2. Link to Google SpreadSheet, with service account access;
3. Key.js from Google Project;
4. Set the Webhook address to which the bot will send responses.

Full step-by-step instructions are available in our knowledge base: https://support.whapi.cloud/help-desk/source-code/whatsapp-api-google-sheets