How to WhatsApp From Google Sheets
Learn how to create WhatsApp links directly from Google Sheets, ensuring your phone numbers are formatted correctly to avoid errors. This tutorial covers the necessary steps to hyperlink WhatsApp numbers efficiently.
You have a bunch of WhatsApp numbers, you want to connect these through Google Sheets. I will show you how to create this link, which is a WhatsApp main link that will direct you directly to WhatsApp from Google Sheets just on a click. But you'll run into some problems, I'm going to show you those problems right away. Okay, so first off, we have some WhatsApp numbers, it may be that you've put them into different formats. If you have this plus sign or even hyphens, it won't work. I'll show you how. We're going to use hyperlink as the formula . We're going to surround with quotes HTTPS colon backslash backslash WA dot ME. And now we're going to use a slash and end those quotes. What we can do then is use an ampersand and select the cell that we want to add that number to. If we end the parentheses, we can see here that it looks like whatsapp, or wa.
me, slash and it has pluses here. This will not work. I'll show you, it'll have a 404 error . But let's make it work. We need to delete the plus sign, any hyphens, and any spaces. So we can select all of our numbers, hit command F, select the three dots. And here we will find a plus sign and replace it with nothing. We'll select the search, the specific range . And just in case it's a formula , we'll also replace all here. There we've replaced all of the pluses. Now we need to put a space and replace it with nothing. Replace all . And now a hyphen. Do a hyphen and replace it with nothing. Don't even put a space here. Replace all we need to make sure this Is what we're looking for. Let's make sure we have these selected. This is what we want to replace.
We've placed it. Good. If you have a single quotation as well, we can replace that. Done. And now we should be able to select that. And there we go. It'll open WhatsApp. And now this hyperlink . We can copy paste all the way down. And now we have hyperlinks to all of these WhatsApp members. If you want to get more out of Google sheets than you ever have before, consider subscribing here on YouTube to better sheets.