Send WhatsApp Messages Automatically
How to automatically send WhatsApp messages every hour?
This article describes how to set up WhatsApp messages that are going to be sent automatically for rows with no values in the Message Status column (if new rows have been inserted since WhatsApp messages were last sent, or date/time values have been removed from under the Message Status column, etc.).
Step 1: Click Auto Send
In the Sheet dialog box, click on Auto Send to open the Options to Send Messages Automatically dialog box.
Step 2: Select Yes
From the Every Hour drop-down menu, select Yes.
Step 3: Click Save in Sheet dialog box
Click on Save & Close, and then click on Save in the Sheet dialog box to apply the changes.
Now, every hour Walution add-on checks for rows with no values in the Message Status column, and then sends a message for each of these rows.
In this example, three new rows with no values (9,10 & 11) have been added since the last WhatsApp messages were sent.
NOTE:
A row may not have a value in the Message Status column either because the row has been inserted since WhatsApp messages were last sent, or because the date/time value has been removed. In either case, a message is going to be sent for the row.
Messages being sent every hour does not mean they are sent on the hour; the exact time when the sending process is triggered cannot be guaranteed.
Deactivate Automatic WhatsApp Messages
To deactivate automatic WhatsApp messages, click on Auto Send in the Sheet dialog box.
In the Options to Send Messages Automatically dialog box, select No from the Every Hour drop-down menu, then click on Save & Close.
Click on Save in the Sheet dialog box to apply the changes.
Send messages on Google form submits
To find out how to set up automatic WhatsApp messages specifically for Google form submits, refer to this article.