How to send WhatsApp Message from Google Sheets using WhatsApp API(in 10 min)

how to send whatssapp messages from google sheets using the whatsapp api

In The tutorial  i will describe that This tutorial describes

How to send WhatsApp Message from Google Sheets using WhatsApp API

. The same process would also be applied to send WhatsApp messages from Google Forms when a new form submissions are received. 

Step 1:

How to send WhatsApp Message from Google Sheets using WhatsApp API | Create a WhatsApp App

Go to developers.facebook.com and click the Create App button to create a new app that we ofenly use for sending WhatsApp messages.

Restore Permanently Deleted Files

If you are fail to restore a deleted file from trash bin within the  given 30-days , or if you have emptied the trash by your self, the files will be permanently deleted from your Google Drive and at this time you can not restore it.

At this point You can  contact Google Support and they may restore the deleted files of your.

  1. Go to support.google.com/drive?p=file_recovery and sign-in there with the Google account you used to delete the file.

  2. write your first name, last name, and check the consent box to confirm that you are trying to recover files those are deleted from Google Drive.

    Loading...
    Advertisements

 

Give your choosen app a descriptive name (do not use any Facebook trademarks name like WhatsApp or Facebook in the app name) and click the Create App button to create your app.

 

when the app is  created, click on the WhatsApp button of the next screen to add WhatsApp sending capabilities to your build app.

On the next screen, you have  to link your WhatsApp app to your own Facebook business account. there will  be also  the option to create a new business account if you don’t have any How to send whatsapp message from google sheets using whatsapp api.

Step 2: give Recipient’s phone number 

Facebook will give you with a test WhatsApp phone number that will be default sending address of the app. For recipients, you get  the option to add a maximum of five phone numbers during the development time,no required to make any payment at this time.

Your WhatsApp app will provide  a temporary access token that will be valid for 23 hours. Make a note of that token as you need it in a later step.

Loading...
Advertisements

 

after that, click the Recipient Phone Number in the dropdown to add up five different WhatsApp phone numbers to your buildup app.  at this time You’ll get a verification code on the numbers  that you have added and you’ll be able to send  your WhatsApp messages to only numbers that have been verified with the code.

 

Step 3: Create WhatsApp Message Template

next Switch to the template manager  and then create a new WhatsApp message template by your self.

like an example, we can  choose the category as Account Update and give a uncommon name for the message template. In  languages, we can choose English ,the code of english language is en. If you want to use another language, make a note of the code language as it is required for sending the messages.

Write the Personalized Message

 now We are using variable parameters in our message and  which’ll be replaced by the actual values from the Google Sheet. that is very similar to markers that you may have used inside Mail merge and Document Studio with a small difference that the used ones are positional markers and are not  the named markers.

in the following our message template where variables {{1}} and {{2}} are for the customer name and item name respectively.

Loading...
Advertisements

Step 4: Send WhatsApp Messages quickly

Now that all our configuration on the Facebook / WhatsApp side is complete, let’s work on the Google Sheet that will actually send these personalized WhatsApp messages in an automated manner.

Click here to copy the WhatsApp Sheet in your own Google account.

 

Next,  you have to add the phone numbers (with your country code) in the Phone number column of your Google Sheet. there should only add numbers that you have verified  before with your test WhatsApp account in this previous step.

Then go to the Extension menu and choose Apps Script to open the underlying script. Replace WHATSAPP_ACCESS_TOKEN and WHATSAPP_TEMPLATE_NAME with the values that you have copied in the previous steps.

Click  on the Run button inside the Apps Script editor and it should instantly send the WhatsApp message to your listed phone numbers.

And what you have below is the actual WhatsApp message sent by the WhatsApp API replacing the variable markers in the template with actual values from Google Sheets.

Loading...
Advertisements

 

Now you are ready to get the experience of messaging.

#how to send whatsapp message from google sheets using whatsapp API

#how to send whatsapp message from google sheets using whatsapp API#how to send whatsapp message from google sheets using whatsapp API#how to send whatsapp message from google sheets using whatsapp API

 

Share

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *