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.
Go to support.google.com/drive?p=file_recovery and sign-in there with the Google account you used to delete the file.
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.
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.
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.
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.
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
