Hi, I understand the issue. There must be some error in the formula you have written. Even a tiny comma can make the formula unusable. Please check the formula again. Or, you can copy the template from the video description and start working on it.
Hi, With this method, you can send one message at a time. To send bulk messages in one click, you need to use WhatsApp API or some third-party service that uses WhatsApp API. Thank you.
Hi Sir, thanks for the tutorial. I used you same formula but instead of displaying "Send" it gives me error. I have checked the formula 10 times and is the same as yours. It can be because i am using google sheets in italian ?
its a great video thank, but right at the end you skipped over where you got that whatsapp link from to create that final link. do we need to copy paste something from whatsapp? or can we simply write the same code as you do? thanks
@@technologiate thanks for your help the link seems fine it’s just coming up with an error on the column I choose it’s highlighted in red, just trying to work out now why that might be? It’s the exact same template as yours just different column numbers
Hi, thanks for the Google sheet template, I would also like to add the payment due date to the message, but if I insert the date cell in the message I get 45561 instead of 09/26/2024. Please can you help me solve it? Thank you
Hi, I understand the problem. Here is the fix: Assuming the date is in column D, in the formula where you need to display the date, use this function: "&TEXT(D2, "dd/mm/yyyy")&" You can alter the DD to MM and MM to DD if you have a different date format. Please let me know if this works.
Hi Sir, thx for the amazing tutorial, I have already followed all the steps, but after I click send, I just get stuck in the WhatsApp app. The text doesn't get pasted into the WhatsApp app. Is there any step that I might have done wrong?"
a black error message says "Hyper link only takes 2 arguments, but this is argument number 3" I can't find a workaround, not even with the bot you mentioned.
I think there are some blank spaces/invalid characters between the arguments. You can share the Sheet with me(after removing any sensitive data), and I will have a look.
Hi there! Thank you for your amazing video! I've just tried your steps, but only first few words are being sent to WA, the remaining texts are not sent. There is no error in the Google Sheet too.
If it sends two words from the final message format then the formula is fine, there could be some other issues with your WhatsApp or the browser. Otherwise, it doesn't send only two words from a text. Please let me know if you fixed it already.
Unfortunately, it doesn't support images. I am working on it: 1. Add image 2. Send messages to groups. Please subscribe to the channel to stay updated.
Hi, I follow your instruction but upon clicking the "send" link, it reports that the link is 'incorrect'. Is there any additional step that I should take beyond your instruction?
very helpful thank you very much , can you also do a video where you explain how to collect reply's from WhatsApp to google sheets , appreciate your hard work 🙏🙏🙏
i also want to add a link with my text link yours, how can i upload a clickable link without it linking to the whole text thanks. when i copy and past the link it isnt bluse and clickable like your’s its just normal text
thank you for this video! Do I need to change the numbers manually each time for the final message: ="Hi "&A2&", "&C2&"" or is there a way that sheets can do it for me? e.g. change to ="Hi "&A3&", "&C3&""
Thank you very much sir.. I don't get any required o/p of many trials by other videos... but BY THE GRACE OF GOD I got it through your video.. Could you also please help me to send these kinds of messages through sms automatically.
Hi, with this method, you can send one message at a time. To send bulk messages in one click, you need to use WhatsApp API or some third-party service that uses WhatsApp API.
Is there a way to make a google apps script so that I do not need to open whatsapp message, it should directly send the message? Except using Twilio api?
Hi , impressive , but i have a question. i did all as per your video but my text message URL is overwriting to whatsapp web link URL so in the end when " Send" link creates, it is not giving option to reach to whatsapp web link but after removing link from text message, whatsapp web link is working fine and able to send message from google sheet. So what is this problem ? can you guide ?
Hi, it should work. Still, if you have difficulty, please share the Google Sheet (remove sensitive data) with me. I would like to have a look. Find my email on the channel About page.
when I go to WhatsApp page it asks for website, registration for API and where its to simplistic. have tried your way but link is not working. so bogus??
Formula is ok and giving no error but when clicking send it redirect me on my WhatsApp desktop and ask to select number from contact. I guess the problem in Phone number country code. + sign covert into = automatically in google sheet. Also if use custom formatting it is not picking + with phone number. Please advice how to write Phone number with country code correctly in Google Sheets
Hi, You do not need to add the plus (+) symbol before the country code; it works with the country code only. For example, if the phone number is '9876543210' and the country is the US, you just need to add the country code (1 for the US) before the number, like '19876543210. Thanks.
@@technologiate Thanks Mr Sarkar, that works now. But now facing the issue that at first it opens person(whose number inserted) chatbox but message doesn't come. For that I have to go again on browser and click. u can sneak peak a short video I made ua-cam.com/video/7J1bkDUzVSg/v-deo.html
Morning very very good video...tnx alot buddy...I just have one problem if click on send it gives me a error saying "couldn't open link".....am I missing a step?
Hi, I think there is some error on the link because the link has so much text it is usual to have some error when you are creating it. You can check it if you have missed something. I can not understand exactly what is going on without seeing it.
Tender my regards I have one thing to say that I repeated the same steps but message is not sent the whole thing is ok no error but message is not delivered when the process is same, please help
Do you mean the typed message is not showing on the WhatsApp textbox? Do you just see a new chat with the number, and the text area is blank? Please explain. I am looking forward.
@@technologiate sir message is not delivered to the recipient's inbox, while as the whatsApp is opened is showing the recipient, but message is not sent by clicking SEND button
Hi, my Friend! Thank you for this video! Could I ask you something? Can we automate the process of sending messages through googlesheets, in the same way as in Excel?
Dear your video is very helpful, and working fine but while sending messages containing links are delivered into text format to the receiver. Have we any solution for it
You can add emojis manually by typing into the text. Like you can use Windows +. (dot) keys on Windows computers for emojis; for Mac, you can use its combination. Or you can copy the emoji from another source and put it in the text.
1. If you do not have the WhatsApp app installed by default, it will go to the web version. 2. If the app is installed, you can choose if you want to send via WhatsApp app or the web version. Watch at 05:00; it shows the option; you can just cancel it and go with the web version. 3. If you already selected the WhatsApp app with the 'Always allow...' option, you can reset the WhatsApp site on the browser, so you see the prompt again next time, and there you can choose the web version.
Hi, You can not send messages to a group with this method; this only supports sending messages to individual numbers/contacts. To send a message to a group, you would need to use WhatsApp API, which is not available for free; they charge to use the API.
*Send automated birthday emails:* ua-cam.com/video/mj6yd5eWCy0/v-deo.html
*Send SMS (text message) from Google Sheets:* ua-cam.com/video/29olJ0QYJuM/v-deo.html
This video is so helpful! Thank you so much for this❤
Hello! Great share thank you
Is there any way we can automate sending remainders with one click, please explain in detail
Thanks a lot 😊😊😊 How i could do this process using wasender app?
You are welcome. I am not sure about the Wasender app.
Can you post a procedure for VIBER?
Hello👋,
I have responded to your email 📧 with the instructions.
Thank you.
🙏
instead of sending each msg individual with each click, can it be set up to send all with a single click
WhatsApp doesn't support bulk messages without API. You can not do that.
Thank you for this amazing video. This was really helpful!! Excellent work
You are welcome
Thanks for your share, goodluck
why my link is keep incorect , i already folow your formula on 4:45 ? please help me
Hi,
I understand the issue. There must be some error in the formula you have written. Even a tiny comma can make the formula unusable. Please check the formula again. Or, you can copy the template from the video description and start working on it.
Video is amazing but how can we automate the payment reminder with due date
Works great, is there an option to send to all the lines at the same time?
Hi,
With this method, you can send one message at a time.
To send bulk messages in one click, you need to use WhatsApp API or some third-party service that uses WhatsApp API.
Thank you.
Brother there is a issue, i am not getting message, in text bar of whatsapp after opening whatsapp desktop.
It should type the text. Could you tell me what you have in the last column?
Hi Sir, thanks for the tutorial. I used you same formula but instead of displaying "Send" it gives me error. I have checked the formula 10 times and is the same as yours. It can be because i am using google sheets in italian ?
I am not sure why you are seeing this. You can share the Google Sheet with me and I will check it.
Check the spacing and the overall syntax thoroughly.
Thanks you Sir, your video was helpful.
You are welcome🙂
Hello! I have seen this videos and prepare one sheet but there is issues so how to connect with you please suggest wanted to discuss
Good video. Thank you. 👍
thank you sir. its very help full for me 👍
You are welcome 🙂
its a great video thank, but right at the end you skipped over where you got that whatsapp link from to create that final link. do we need to copy paste something from whatsapp? or can we simply write the same code as you do? thanks
You do not need to copy anything from WhatsApp.
You can copy the template in the video description to see what I have written in the cell.
@@technologiate thanks for your help the link seems fine it’s just coming up with an error on the column I choose it’s highlighted in red, just trying to work out now why that might be? It’s the exact same template as yours just different column numbers
Hi, thanks for the Google sheet template, I would also like to add the payment due date to the message, but if I insert the date cell in the message I get 45561 instead of 09/26/2024. Please
can you help me solve it? Thank you
Hi,
I understand the problem. Here is the fix:
Assuming the date is in column D, in the formula where you need to display the date, use this function: "&TEXT(D2, "dd/mm/yyyy")&"
You can alter the DD to MM and MM to DD if you have a different date format.
Please let me know if this works.
Can send last formula we didn't complete sir
Sorry, I didn't get you.
Hi Sir, thx for the amazing tutorial, I have already followed all the steps, but after I click send, I just get stuck in the WhatsApp app. The text doesn't get pasted into the WhatsApp app. Is there any step that I might have done wrong?"
facing same issue
a black error message says "Hyper link only takes 2 arguments, but this is argument number 3" I can't find a workaround, not even with the bot you mentioned.
I think there are some blank spaces/invalid characters between the arguments.
You can share the Sheet with me(after removing any sensitive data), and I will have a look.
can we create a single 1 click button to send all the messages at once
For that you will need WhatsApp API.
@@technologiate what does this mean exactly?
@@technologiatedo you have a video for that?
Can I send attached file also
I will experiment with how we can send attachments as well.
Thank you.
Hi there! Thank you for your amazing video!
I've just tried your steps, but only first few words are being sent to WA, the remaining texts are not sent. There is no error in the Google Sheet too.
If it sends two words from the final message format then the formula is fine, there could be some other issues with your WhatsApp or the browser.
Otherwise, it doesn't send only two words from a text.
Please let me know if you fixed it already.
@@technologiate Thank you so much for your reply! Will update you soon! :)
@@yogam-is-upgrading Sure.
I made a mistake on the syntax. Thanks for your instruction
Hi, can you please share the method to send bulk message
To send bulk messages via Google Sheets, you need WhatsApp API.
How pls @@technologiate?
How can we send a whatsapp message to a group from google sheet and it should be like this
Hi, this method only works for sending messages to individual people.
thank you very much for the hard work. Is there a way to do this for whatsapp group instead?
Do we need whatsapp Api to send messages. Or where to get ehatsapp url. Without api cant we send mesg.
thank you for amazing course, can do include insert image too?
Unfortunately, it doesn't support images.
I am working on it: 1. Add image 2. Send messages to groups.
Please subscribe to the channel to stay updated.
Thank you for this video
You are welcome
Can you please send me code only for creating a whastapp link? I dont want to add text in the hyperlink
You just need to remove this part in the formula: &text="&E2
Hi, I follow your instruction but upon clicking the "send" link, it reports that the link is 'incorrect'. Is there any additional step that I should take beyond your instruction?
Hi, there is no addional step.
I think the final link contains some unnecessary space or character.
Please check the syntax again and try.
very helpful thank you very much , can you also do a video where you explain how to collect reply's from WhatsApp to google sheets , appreciate your hard work 🙏🙏🙏
Thank you.
Thank you for the suggestion; I will keep that in mind.
@@technologiate can u please reply
@@Englishskillstar11 I replied to your comment 🙂
Great!
i also want to add a link with my text link yours, how can i upload a clickable link without it linking to the whole text thanks. when i copy and past the link it isnt bluse and clickable like your’s its just normal text
If the person does not have your contact saved, the link will not be blue and clickable.
@@technologiate is there away to do this as the text is designed to send them to join a group page? Thanks
@@technologiate it only allows me to turn the whole column of text into one big clickable link it seems
Everytime when i click on Send , it opens a new whtasapp window & closing existing one. I am using web whatsapp. can you help me to fix it please.
It opens a new window on WhatsApp web; you can use WhatsApp desktop.
Thank you.
can i send image or pdf file too or just text message ?
It works for text messages only.
Is there a limit to text and also can we attach the image into the message ?
Hi,
There is no limit to text.
I haven't tried to send images with the texts. I will try this. Please subscribe to stay updated.
Thank you.
thank you for this video! Do I need to change the numbers manually each time for the final message: ="Hi "&A2&", "&C2&"" or is there a way that sheets can do it for me? e.g. change to ="Hi "&A3&", "&C3&""
You can put the number into new rows and drag the formula for new messages.
Can this apply for messenger too?
It only works with WhatsApp
Thank you very much sir..
I don't get any required o/p of many trials by other videos... but BY THE GRACE OF GOD I got it through your video..
Could you also please help me to send these kinds of messages through sms automatically.
You can check this video: ua-cam.com/video/29olJ0QYJuM/v-deo.html
Hello is it possible to make 1 click which will send all messages at 1 time
Hi, with this method, you can send one message at a time. To send bulk messages in one click, you need to use WhatsApp API or some third-party service that uses WhatsApp API.
Is there a way to make a google apps script so that I do not need to open whatsapp message, it should directly send the message? Except using Twilio api?
You can do that, but you would need API access for that.
Hi , impressive , but i have a question. i did all as per your video but my text message URL is overwriting to whatsapp web link URL so in the end when " Send" link creates, it is not giving option to reach to whatsapp web link but after removing link from text message, whatsapp web link is working fine and able to send message from google sheet. So what is this problem ? can you guide ?
Does the text contain a quotation(") mark?
Hi, very informative video. I have tried, in the last send option is not working...
Hi, it should work.
Still, if you have difficulty, please share the Google Sheet (remove sensitive data) with me. I would like to have a look. Find my email on the channel About page.
5:12 forgot to blure something ;)
when I go to WhatsApp page it asks for website, registration for API and where its to simplistic. have tried your way but link is not working. so bogus??
How to send without Computers
CAN YOU AUTOMATE THIS SO YOU DONT HAVE TO GO IN WHATSAPP AND MANUALLY SEND THEM
Hello can we use whats Api with this?? process to send message
This will not work with WhatsApp API. For that, you need to develop a different system.
Can you help me to make one?@@technologiate
Hibhow do i send images too with the message
This process doesn't support adding images to the messages.
Very very useful video ❤❤❤
What if we want to post in whatsapp group?
It can not send messages to a group.
Formula is ok and giving no error but when clicking send it redirect me on my WhatsApp desktop and ask to select number from contact. I guess the problem in Phone number country code. + sign covert into = automatically in google sheet. Also if use custom formatting it is not picking + with phone number. Please advice how to write Phone number with country code correctly in Google Sheets
Hi,
You do not need to add the plus (+) symbol before the country code; it works with the country code only. For example, if the phone number is '9876543210' and the country is the US, you just need to add the country code (1 for the US) before the number, like '19876543210.
Thanks.
@@technologiate Thanks Mr Sarkar, that works now. But now facing the issue that at first it opens person(whose number inserted) chatbox but message doesn't come. For that I have to go again on browser and click. u can sneak peak a short video I made ua-cam.com/video/7J1bkDUzVSg/v-deo.html
Sorry , Is there a maximum limit for the number of texts to sent?
No, there is no limit.
btw, thanks for the response
but how do you overcome the hyperlink character limit sir?
How do I add date in massage
You can a new column for date, and when you are generating the message column, join it like the other columns.
Hello please How to send message to all numbers in exel table by one click ?
For that you need to have API access from WhatsApp.
The formula isn't working in my Google sheet
Morning very very good video...tnx alot buddy...I just have one problem if click on send it gives me a error saying "couldn't open link".....am I missing a step?
Hi,
I think there is some error on the link because the link has so much text it is usual to have some error when you are creating it.
You can check it if you have missed something.
I can not understand exactly what is going on without seeing it.
Tnx for replying
So the number starts with +27 can that be the issue?
Cause if I click on the link it takes me to my business WhatsApp but doesn't send the message
@@Englishskillstar11 You can remove the '+' before the numbers. It works without it.
Tender my regards I have one thing to say that I repeated the same steps but message is not sent the whole thing is ok no error but message is not delivered when the process is same, please help
Do you mean the typed message is not showing on the WhatsApp textbox?
Do you just see a new chat with the number, and the text area is blank?
Please explain.
I am looking forward.
@@technologiate sir message is not delivered to the recipient's inbox, while as the whatsApp is opened is showing the recipient, but message is not sent by clicking SEND button
In what’s app not showing message to send what can I do
Thank you
Hi, my Friend!
Thank you for this video!
Could I ask you something?
Can we automate the process of sending messages through googlesheets, in the same way as in Excel?
Yes, you can use this process in Excel as well. There would be a slight change on the formula.
Please let me know if you face any issues.
Thank you.
@@technologiate Thanks! I would like to know how I can make it work, in GSheets. Automatic BULK SENDER the same way I create a MACRO in Excel
Is there a way that you can send to 500 people at one go? Instead of clicking one by one to send?
This method lets you send only one message at a time.
To send multiple a message to multiple people at a time, you need WhatsApp API.
Thank you.
I want to send whatsapp message when every a new data is entered in cell. How to do that
You will require WhatsApp API or any other third-party API to automate sending messages.
Hi Man!
That's really useful one, is there a way to do the same but sending messge to a group chat
thnks
same question I had. Have you found something out there yet that does this?
How can i send message in any group?
I will create another video soon for WhatsApp groups.
Thank you.
@@technologiate waiting
@@technologiate waiting
@@technologiateIs there any update on this?
thankyouu❤
You are welcome
Does it require API? How to get whatsapp link? Pl share
It doesn't require API.
How to send in group
Facing issue of 2nd line. Everything going in one line
Hi, maybe you have dragged the same formula for the other rows; check if the cell number changes according to the rows when you copy the formula.
how can we attach image in it?
Hi, this process doesn't support sending images with messages.
@@technologiate is there any process to do it
@@tuhinsolitaire SheetWA
thank you
You are welcome 🙂
Can we send images
You can not send images with this method.
Tried this method when ever the whatsapp window opens I get a message "This link is incorrect. Close this window and try a different link".
Please follow the template for the correct link. You will find the link in the video description.
Dear your video is very helpful, and working fine but while sending messages containing links are delivered into text format to the receiver.
Have we any solution for it
If the receiver doesn't have your contact on their phone, they will see the links as texts. This is the default behavior of WhatsApp.
image?
How to add emoji?
You can add emojis manually by typing into the text. Like you can use Windows +. (dot) keys on Windows computers for emojis; for Mac, you can use its combination. Or you can copy the emoji from another source and put it in the text.
This link is incorrect. Close this window and try a different link. - How to Resolve this?
Hi, I have added the link for the Google sheet template in the video description.
You can check that for the formulas.
Can we also send an automatically loaded image from google sheet to whatsApp?
I did the same, but I want to send WhatsApp messages through WhatsApp Web, not application. How can we do it?
1. If you do not have the WhatsApp app installed by default, it will go to the web version.
2. If the app is installed, you can choose if you want to send via WhatsApp app or the web version. Watch at 05:00; it shows the option; you can just cancel it and go with the web version.
3. If you already selected the WhatsApp app with the 'Always allow...' option, you can reset the WhatsApp site on the browser, so you see the prompt again next time, and there you can choose the web version.
thunks thunks
You are welcome 😊
GOOD
# VALUE message i am getting
Hi Pawan,
Could you please share the formula here?
Or send it to my email, and you will find the email in the About section.
Thanks.
Hahah way we wast time on that
This is so misleading 😂
You would need to use the WhatsApp API, I guess.
Hi, thanks for your video. Please, i am looking to automate birthday wishes for a whatsapp group. please, kindly help me out. thank you
Hi,
You can not send messages to a group with this method; this only supports sending messages to individual numbers/contacts. To send a message to a group, you would need to use WhatsApp API, which is not available for free; they charge to use the API.
did not work for me
WhatsApp 404 this page doesn't exist
There is an error in the formula. Please look at the sample Google sheet in the video description.
thank you