Skip to main content

How to send notifications
Whatsapp
with your Google Sheet using Sendapp.cloud

Now you can automate Whatsapp notifications
your Appointments, Meetings, Events,
Birthday Wishes, Dates to Remember
with the Google Sheet

Download Example

Send whatsapp notifications with google sheet

  • Give your sheet a name for example: Whatsapp notifications
  • Customize the four columns as shown in the image below
  • Select column A
  • Go to the Format menu and select Number / Date and Time
  • Customize the second line as shown in the image to carry out a test.
  • Pay attention to the "Day and Time" cell must be formatted as | day / month / year - hour / minute | set the notification sending time
  • To test, we suggest you a few minutes after your current date and time.
  • Go to the Extensions menu and select Apps Script
  • Copy and paste this script into your Apps Script by deleting the existing lines
function myFunction() { var Sendapp_API = "https://app.sendapp.cloud/api/send?number=" // Account API https://sendapp.cloud/login/ for Watsapp Message // https://sendapp .live/en/whatsapp-api-for-sending-notifications-from-any-platform/ var Access_Token = '863a83xxxxxx' //replace this var Instance_ID = '61F2C8xxxxx' //replace this var values = SpreadsheetApp.getActiveSheet(). getDataRange().getValues(); for(n=1;n
  • Edit the script by pasting your Access_Token and your Whatsap API Instance_ID of Sendapp.cloud
  • You can change the 2 Timezones of your country which are now set in the script to “GMT + 1” more info on Timezone
  • Make sure you have replaced the Access_Token and Instance_ID in your Google script
  • Now we can save and run the script as shown in the image
  • After saving, press the execute button, and wait for the authorization windows to appear
  • All permissions must be given
  • Now the script needs to be authorized as you can see from the images below
  • The last step is to run the script from every minute
  • Go to Apps Script and select the Activators button from the left menu
  • Click the "Add Activator" button at the bottom right
  • From the window that appears, select the time execution in minutes as you see in the image
  • If you have configured everything as described and the date and time of the google sheet is the same as the current time, you will see send your notification from your phone Whatsapp.