Reading Time: 3 minutes Show
WhatsApp and Google Sheets are two significant platforms used in daily life. Ever had an instance, when you had to send a number of messages to your customers or contacts and wanted to reduce the manual effort for the same? Now, what if I tell you that you can send WhatsApp Messages from Google Sheets? Sounds interesting, right? This article will provide you with step-by-step assistance with a cost-free solution to send WhatsApp messages from Google Sheets. You can also watch the following video for the same. You can also check out the spreadsheet template below to get a hands-on experience with it. Free Google Sheet Template to Send WhatsApp Messages
How to Send WhatsApp Messages from Google Sheets:STEP1: Adding data to the spreadsheetCreate a spreadsheet with Column 1 for storing the names of the contacts and Column 2 for their respective WhatsApp Numbers. Note: Do not forget to add the country code in front of the phone numbers! (Example: +91-987654321 would be written as ‘+91-987654321 in the Column 2 cells) STEP2: Creating the WhatsApp Message to send from Google SheetsAdd the message in the next column using the following syntax: =“&A5&” Hence, the final message Syntax for the given example would be: =”Hi “&A5&”, Welcome to the Team.” Figure 2: Creating the WhatsApp Message to send from Google SheetsCopy the Syntax for the rest of the rows. STEP3: Creating WhatsApp Message LinkCreate another column for linking the messages to WhatsApp by using the HYPERLINK feature. The above syntax would enable you to send the message in cell C5 to the contact number in cell B5. =HYPERLINK(“https://api.whatsapp.com/send?phone=”&B5&”&text=”&C5,”Send“) Figure 3: Creating the WhatsApp Message Link to send from Google SheetsCopy the Syntax for other rows as well. STEP4: Click on the Send ButtonWe are almost done with the process now. All you have to do is click on the Send link displayed in column D to send WhatsApp Messages from Google Sheets. Figure 4: Sending the WhatsApp Message from Google SheetsYou will be redirected to the WhatsApp Page, where you have to click on the option Continue to Chat and select either WhatsApp Web or the WhatsApp App installed on your desktop. Press Enter and your WhatsApp message will be sent to the contact. You can send multiple messages just by clicking on the SEND link in the spreadsheet. Figure 5: Final WhatsApp Chat MessagesConclusion To send WhatsApp messages from Google Sheets can prove to be quite useful if the number of people targeted is huge and messages to be sent need to be semi-personalized. If you liked this article, you may want to check out our complete guide to Whatsapp Cloud API. See Also Want to know more about such cool hacks for Google Sheets? Look at our definitive guide on Google Sheets which covers hundreds of such topics here. Enjoy reading! Tips and Tricks: Working with Date and Time in Google Sheets: Learn how to work with dates and time in Google Sheets Slow Google Sheets? Tricks you can use to speed up your sheet: In this article, we would look at why you are facing issues with slow google sheets. We would also look at some tips you can use to make your sheets run faster. Bagaimana cara membagikan link spreadsheet?Berbagi menggunakan link:. Buka file dan klik Bagikan.. Di bagian Dapatkan link, klik Salin link.. (Opsional) Untuk mengubah izin, klik Ubah, lalu pilih Pengakses Lihat Saja, Pemberi Komentar, atau Editor.. Copy-paste link di email atau di mana pun Anda ingin membagikannya.. Bagaimana cara mengakses Google Spreadsheet?Mendapatkan Spreadsheet di perangkat Anda
Browser web apa pun—Buka sheets.google.com. Google Drive—Klik Baru. Google Spreadsheet, lalu buat dari awal atau dari template. Sebagian besar halaman Google—Di pojok kanan atas, klik Peluncur Aplikasi.
Apakah Google Spreadsheet bisa diedit semua orang?Ada dua cara membuat Google Docs bisa diedit semua orang, yaitu antar-email dengan menambahkan email orang lain ke opsi bagikan, ikon tambah orang dan membagikannya menggunakan tautan dengan mengubah perizinan tautan.
Bagaimana cara mengisi spreadsheet?Buka spreadsheet di Google Spreadsheet. Klik sel yang kosong, atau klik dua kali sel yang tidak kosong. Mulailah mengetik. Opsional: Untuk menambahkan baris lain dalam sel, tekan ⌘ + Enterpada Mac atau Ctrl + Enter pada Windows.
|