This video is so helpful! Thank you so much for this❤
@SupremeSkeptic
4 күн бұрын
Can we also send an automatically loaded image from google sheet to whatsApp?
@sudhaannuri5222
Жыл бұрын
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.
@technologiate
Жыл бұрын
You can check this video: kzitem.info/news/bejne/k2-l0n5miot7qII
@BrettHidgcock
Ай бұрын
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
Ай бұрын
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.
@BrettHidgcock
Ай бұрын
@@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
@sunilbudke
2 ай бұрын
Good video. Thank you. 👍
@channelhijau4444
3 ай бұрын
Thank you for this video
@technologiate
3 ай бұрын
You are welcome
@am5642
Жыл бұрын
Thanks you Sir, your video was helpful.
@technologiate
Жыл бұрын
You are welcome🙂
@fajeraaa8376
Жыл бұрын
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 🙏🙏🙏
@technologiate
Жыл бұрын
Thank you. Thank you for the suggestion; I will keep that in mind.
@leroymatthews3390
Жыл бұрын
@@technologiate can u please reply
@technologiate
Жыл бұрын
@@leroymatthews3390 I replied to your comment 🙂
@avdheshk2
Ай бұрын
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
@technologiate
Жыл бұрын
*Send SMS (text message) from Google Sheets:* kzitem.info/news/bejne/k2-l0n5miot7qII
@Mmxx9
Жыл бұрын
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 ?
@technologiate
Жыл бұрын
I am not sure why you are seeing this. You can share the Google Sheet with me and I will check it.
@musical_lolu4811
11 ай бұрын
Check the spacing and the overall syntax thoroughly.
@jigneshmhatre8908
Жыл бұрын
thank you sir. its very help full for me 👍
@technologiate
Жыл бұрын
You are welcome 🙂
@alrakreugzel3664
8 ай бұрын
Thanks a lot 😊😊😊 How i could do this process using wasender app?
@technologiate
8 ай бұрын
You are welcome. I am not sure about the Wasender app.
@hadleyjonesacademy
9 ай бұрын
Thank you for this amazing video. This was really helpful!! Excellent work
@technologiate
9 ай бұрын
You are welcome
@samvan7787
Жыл бұрын
instead of sending each msg individual with each click, can it be set up to send all with a single click
@technologiate
Жыл бұрын
WhatsApp doesn't support bulk messages without API. You can not do that.
@rohithdilip5308
9 ай бұрын
Hello! Great share thank you Is there any way we can automate sending remainders with one click, please explain in detail
@reuven2k
6 ай бұрын
Works great, is there an option to send to all the lines at the same time?
@technologiate
6 ай бұрын
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.
@uploadvideo2189
Жыл бұрын
Can you post a procedure for VIBER?
@technologiate
Жыл бұрын
Hello👋, I have responded to your email 📧 with the instructions. Thank you. 🙏
@kkkrishna6210
Жыл бұрын
Brother there is a issue, i am not getting message, in text bar of whatsapp after opening whatsapp desktop.
@technologiate
Жыл бұрын
It should type the text. Could you tell me what you have in the last column?
@yogam-is-upgrading
Жыл бұрын
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.
@technologiate
Жыл бұрын
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.
@yogam-is-upgrading
Жыл бұрын
@@technologiate Thank you so much for your reply! Will update you soon! :)
@technologiate
Жыл бұрын
@@yogam-is-upgrading Sure.
@fromhome3812
Жыл бұрын
Video is amazing but how can we automate the payment reminder with due date
@shreerammahadik2124
9 ай бұрын
can we create a single 1 click button to send all the messages at once
@technologiate
9 ай бұрын
For that you will need WhatsApp API.
@RawdaFayha
28 күн бұрын
@@technologiate what does this mean exactly?
@RawdaFayha
28 күн бұрын
@@technologiatedo you have a video for that?
@peterwanzie8449
Жыл бұрын
thank you very much for the hard work. Is there a way to do this for whatsapp group instead?
@indurneuro1677
Жыл бұрын
thank you
@technologiate
Жыл бұрын
You are welcome 🙂
@raselhossain4185
10 ай бұрын
Thank you
@rakeshchandra9096
2 ай бұрын
Can you please send me code only for creating a whastapp link? I dont want to add text in the hyperlink
@technologiate
2 ай бұрын
You just need to remove this part in the formula: &text="&E2
@Jawadkhan-hs1dx
Жыл бұрын
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.
@technologiate
Жыл бұрын
It opens a new window on WhatsApp web; you can use WhatsApp desktop. Thank you.
@nguyenuctri-viendulich7418
11 ай бұрын
I made a mistake on the syntax. Thanks for your instruction
@NextGenManpowerPlacementAgency
4 ай бұрын
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
@technologiate
4 ай бұрын
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.
@NextGenManpowerPlacementAgency
4 ай бұрын
@@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 kzitem.info/news/bejne/mIBnyJ96jqyHhpw
@travelexplore4069
2 ай бұрын
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 ?
@technologiate
2 ай бұрын
Does the text contain a quotation(") mark?
@AdarshGroupOfComapny
Жыл бұрын
Can send last formula we didn't complete sir
@technologiate
Жыл бұрын
Sorry, I didn't get you.
@user-nr5bd3kn1k
Жыл бұрын
thank you for amazing course, can do include insert image too?
@technologiate
Жыл бұрын
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.
@BrettHidgcock
Ай бұрын
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
@technologiate
Ай бұрын
If the person does not have your contact saved, the link will not be blue and clickable.
@BrettHidgcock
Ай бұрын
@@technologiate is there away to do this as the text is designed to send them to join a group page? Thanks
@BrettHidgcock
Ай бұрын
@@technologiate it only allows me to turn the whole column of text into one big clickable link it seems
@msm7516
11 ай бұрын
Hi, very informative video. I have tried, in the last send option is not working...
@technologiate
11 ай бұрын
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.
@violetsarehappy2
Жыл бұрын
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&""
@technologiate
Жыл бұрын
You can put the number into new rows and drag the formula for new messages.
@bharadhwajshivarapu3314
5 ай бұрын
thankyouu❤
@technologiate
5 ай бұрын
You are welcome
@leroymatthews3390
Жыл бұрын
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?
@technologiate
Жыл бұрын
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.
@leroymatthews3390
Жыл бұрын
Tnx for replying
@leroymatthews3390
Жыл бұрын
So the number starts with +27 can that be the issue?
@leroymatthews3390
Жыл бұрын
Cause if I click on the link it takes me to my business WhatsApp but doesn't send the message
@technologiate
Жыл бұрын
@@leroymatthews3390 You can remove the '+' before the numbers. It works without it.
@amitvishwakarma5873
Жыл бұрын
Is there a limit to text and also can we attach the image into the message ?
@technologiate
Жыл бұрын
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.
@NikisLearningLounge
11 ай бұрын
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.
@technologiate
11 ай бұрын
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.
@ankiitkumarbansal4666
Жыл бұрын
Can I send attached file also
@technologiate
Жыл бұрын
I will experiment with how we can send attachments as well. Thank you.
@joshuabalderama665
9 күн бұрын
Can this apply for messenger too?
@technologiate
9 күн бұрын
It only works with WhatsApp
@user-fg7iy6iu1g
11 ай бұрын
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??
@ProspectionDZ
3 ай бұрын
thunks thunks
@technologiate
3 ай бұрын
You are welcome 😊
@AlessandroAnconetani
5 ай бұрын
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
@technologiate
5 ай бұрын
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.
@manzoorahmadthakur9648
Жыл бұрын
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
@technologiate
Жыл бұрын
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.
@manzoorahmadthakur9648
Жыл бұрын
@@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
@rpchaitanya6044
4 ай бұрын
What if we want to post in whatsapp group?
@technologiate
4 ай бұрын
It can not send messages to a group.
@thebrandwagon-zj4tj
5 ай бұрын
Hello can we use whats Api with this?? process to send message
@technologiate
5 ай бұрын
This will not work with WhatsApp API. For that, you need to develop a different system.
@thebrandwagon-zj4tj
5 ай бұрын
Can you help me to make one?@@technologiate
@dhruvshah4744
Жыл бұрын
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?
@technologiate
Жыл бұрын
You can do that, but you would need API access for that.
@madeenahardwareandplumbing
2 ай бұрын
Hibhow do i send images too with the message
@technologiate
2 ай бұрын
This process doesn't support adding images to the messages.
@devsharma5669
Жыл бұрын
Do we need whatsapp Api to send messages. Or where to get ehatsapp url. Without api cant we send mesg.
@nguyenuctri-viendulich7418
11 ай бұрын
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?
@technologiate
11 ай бұрын
Hi, there is no addional step. I think the final link contains some unnecessary space or character. Please check the syntax again and try.
@mukundkumar707
Жыл бұрын
Very very useful video ❤❤❤
@mosbahbilal16
Жыл бұрын
Hi Man! That's really useful one, is there a way to do the same but sending messge to a group chat thnks
@peterwanzie8449
Жыл бұрын
same question I had. Have you found something out there yet that does this?
@rikohadiyantoprasetio4992
8 ай бұрын
why my link is keep incorect , i already folow your formula on 4:45 ? please help me
@technologiate
8 ай бұрын
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.
@DANIELDESALESFRANCO
Жыл бұрын
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?
@technologiate
Жыл бұрын
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.
@DANIELDESALESFRANCO
Жыл бұрын
@@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
@SantoshKumar-pr1yt
Жыл бұрын
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
@technologiate
Жыл бұрын
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.
@hamad4430
6 ай бұрын
Hello is it possible to make 1 click which will send all messages at 1 time
@technologiate
6 ай бұрын
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.
@siewkhim9963
Жыл бұрын
Is there a way that you can send to 500 people at one go? Instead of clicking one by one to send?
@technologiate
Жыл бұрын
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.
@avecmouataz6667
11 ай бұрын
The formula isn't working in my Google sheet
@saravanachandrasekar8217
10 ай бұрын
This link is incorrect. Close this window and try a different link. - How to Resolve this?
@technologiate
10 ай бұрын
Hi, I have added the link for the Google sheet template in the video description. You can check that for the formulas.
@bluefeathertraining
8 ай бұрын
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".
@technologiate
8 ай бұрын
Please follow the template for the correct link. You will find the link in the video description.
@user-lt7hh5pd7r
8 ай бұрын
I want to send whatsapp message when every a new data is entered in cell. How to do that
@technologiate
8 ай бұрын
You will require WhatsApp API or any other third-party API to automate sending messages.
@hamid777-A
Жыл бұрын
Hello please How to send message to all numbers in exel table by one click ?
@technologiate
Жыл бұрын
For that you need to have API access from WhatsApp.
@Ayyappamanasu
4 ай бұрын
Hi, can you please share the method to send bulk message
@technologiate
4 ай бұрын
To send bulk messages via Google Sheets, you need WhatsApp API.
@RawdaFayha
28 күн бұрын
How pls @@technologiate?
@ginankurnia4261
Жыл бұрын
Sorry , Is there a maximum limit for the number of texts to sent?
@technologiate
Жыл бұрын
No, there is no limit.
@ginankurnia4261
Жыл бұрын
btw, thanks for the response but how do you overcome the hyperlink character limit sir?
@pravingaikwad7063
Жыл бұрын
How do I add date in massage
@technologiate
Жыл бұрын
You can a new column for date, and when you are generating the message column, join it like the other columns.
@lolilulelagaming3213
Жыл бұрын
can i send image or pdf file too or just text message ?
@technologiate
Жыл бұрын
It works for text messages only.
@user-qc6ov8xb2t
Жыл бұрын
GOOD
@chandrasekharbabudevupalli1776
Жыл бұрын
In what’s app not showing message to send what can I do
@tuhinsolitaire
2 ай бұрын
how can we attach image in it?
@technologiate
2 ай бұрын
Hi, this process doesn't support sending images with messages.
@tuhinsolitaire
2 ай бұрын
@@technologiate is there any process to do it
@hiteshgadhia4846
Жыл бұрын
Does it require API? How to get whatsapp link? Pl share
@technologiate
Жыл бұрын
It doesn't require API.
@diptanshusingh338
11 ай бұрын
Can we send images
@technologiate
11 ай бұрын
You can not send images with this method.
@PawanKalmane
Жыл бұрын
# VALUE message i am getting
@technologiate
Жыл бұрын
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.
@alhamdulillahforeverything8005
Жыл бұрын
How can i send message in any group?
@technologiate
Жыл бұрын
I will create another video soon for WhatsApp groups. Thank you.
@mishmash-cc
Жыл бұрын
@@technologiate waiting
@shintanoviaferonica2763
Жыл бұрын
@@technologiate waiting
@NK-ly3cp
Жыл бұрын
@@technologiateIs there any update on this?
@musical_lolu4811
11 ай бұрын
How to add emoji?
@technologiate
11 ай бұрын
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.
@mohamedtariq427
Жыл бұрын
How to send in group
@ajinkyaphirke7675
Жыл бұрын
I did the same, but I want to send WhatsApp messages through WhatsApp Web, not application. How can we do it?
@technologiate
Жыл бұрын
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.
@fisherescarra8456
Жыл бұрын
image?
@WorldPakistan
3 ай бұрын
Hahah way we wast time on that
@marcol4234
2 ай бұрын
This is so misleading 😂
@technologiate
2 ай бұрын
You would need to use the WhatsApp API, I guess.
@lorduzochi
2 ай бұрын
Hi, thanks for your video. Please, i am looking to automate birthday wishes for a whatsapp group. please, kindly help me out. thank you
@technologiate
2 ай бұрын
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.
@hassanrshad9562
9 ай бұрын
did not work for me WhatsApp 404 this page doesn't exist
@technologiate
9 ай бұрын
There is an error in the formula. Please look at the sample Google sheet in the video description.
Пікірлер: 176