Scheduling WhatsApp messages through Google Sheets is a unique feature that helps businesses and companies ease their communications. This article will aim to explain the steps needed to locate the WhatsApp Newsletter sheet and to set it up so that messages can be automatically scheduled. Lastly, it will show you how to set up your gateway settings for better functionality.
1. Locating the WhatsApp Newsletter Sheet File
In order to be able to schedule messages, one must first locate the WhatsApp newsletter sheet. You can locate the WhatsApp Newsletter Sheet as follows:
Open Drive, type in the address bar of your browser. Type “drive.google.com”
The WhatsApp Newsletter Sheet also has a folder icon which will help in the quick location of the file in Google Drive.
If a link to the sheet is known, one can also simply type it in their browser and access the sheet directly.
2. Steps to Configure the Google Sheet File
We can now use the WhatsApp newsletter sheet to schedule messages.
Click on “Templates” tab on the sheet. In this section, you will be able to set up all the required details for sending out messages that have been pre-programmed.
Input has been made ready for verification by submitting the mobile number and it is advisable to verify the setup prior to sending bulk messages.
An individual’s username and password can be entered in the respective fields as these are necessary credentials for the system to enable reporting to Google Sheets -> send to WhatsApp Gateway -> send messages.
3. Checking the Gateway Configuration
For now, let us consider that you will be working with receiving messages from the WhatsApp Gateway with the following manual testing method:
Say you work on the newsletter sheet in WhatsApp, find “Manual Test” and select it.
When pressed, a link will be created. Press the link if you wish to initiate the test.
If all goes according to plan, the statement “Success” should be displayed on the page. Which confirms that everything has been set up correctly. You should receive a confirmation from the system confirming your configuration setup via SMS to the mobile number that you submitted.
4. Online reports of messages
Reports can work as a backup for any potential issues with proper verification checking if messages are sent out as intended or not.
Click the WhatsApp Create Newsletter Sheet on the Check Online Reports button. Look for the “Check Online Reports” button and press it.
You will be provided with a link, simply type in your username, and passcode. This will allow for easy access to your online report.
The reports received online enable you to track all your scheduled messages. You may supervise delivery, performance and any issues that may arise.
Key Results
Use this article to accomplish the following objectives:
Check the setup of the Gateway:
The WhatsApp Gateway must be set up correctly; otherwise, sent messages may not be scheduled.
Schedule messages on WhatsApp:
Design Google Sheets for scheduling and testing of WhatsApp templates. This is very useful for scaling communications effectively.
Conclusion:
Sending WhatsApp templates from Google Sheets is effortless. It also simplifies the communication process with large groups. Make sure to follow these procedures for the configuration of your WhatsApp Gateway and rest assured that your scheduled messages will be delivered without any difficulty. It is an excellent time-saver whether for customer communications, business marketing, or managing other communications.
