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

Send WhatsApp notifications with Google Sheets

• Go to Google Sheet https://docs.google.com/spreadsheets and log in to your account
• Create a new Sheet with the + button

• 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 perform a test.
• Please note that the "Day and Time" cell must be formatted as | day/month/year – hour/minute | set the time to send the notification
• To run tests, we suggest 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 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 Instance_ID from Whatsap APIs 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

• If you don't have an account yet Sendapp.cloud You can register and have a 7-day free trial https://sendapp.cloud/signup
• If you already have an account Sendapp.cloud you can access your login https://sendapp.cloud/login
• After logging in to the site  https://sendapp.cloud  Add a new Whatsapp Web session as shown in the image below
• Attention: the WhatsApp account of the Android or iOS phone must be in multisession mode as described in this link

• 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 Run button and wait for the authorization windows to appear.
• It is necessary to give all the authorizations

• Now you need to authorize the script as you can see from the images below

• The last step is to run the script every minute
• Go to Apps Script and select the Triggers button from the left menu

• Click the “Add Trigger” 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 everything set up as described and the date and time in the Google Sheet are the same as the current time, you will see your notification sent from your phone's WhatsApp.