*Send automated birthday emails:* kzread.info/dash/bejne/n55q28ZulbqpqZM.html

*Send SMS (text message) from Google Sheets:* kzread.info/dash/bejne/ZG2jzqxpgbywpbA.html

Good video. Thank you. 👍

Thank you

Thank you for this video

@technologiate

2 ай бұрын

You are welcome

Thank you for this amazing video. This was really helpful!! Excellent work

@technologiate

8 ай бұрын

You are welcome

thank you very much for the hard work. Is there a way to do this for whatsapp group instead?

thank you

Thanks you Sir, your video was helpful.

@technologiate

Жыл бұрын

You are welcome🙂

thank you sir. its very help full for me 👍

@technologiate

Жыл бұрын

You are welcome 🙂

Hello! Great share thank you Is there any way we can automate sending remainders with one click, please explain in detail

thankyouu❤

@technologiate

4 ай бұрын

You are welcome

Very very useful video ❤❤❤

Video is amazing but how can we automate the payment reminder with due date

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 🙂

Works great, is there an option to send to all the lines at the same time?

@technologiate

5 ай бұрын

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.

thank you for amazing course, can do include insert image too?

@technologiate

11 ай бұрын

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.

Do we need whatsapp Api to send messages. Or where to get ehatsapp url. Without api cant we send mesg.

thunks thunks

@technologiate

2 ай бұрын

You are welcome 😊

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.

I made a mistake on the syntax. Thanks for your instruction

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

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

11 ай бұрын

You can check this video: kzread.info/dash/bejne/ZG2jzqxpgbywpbA.html

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?

GOOD

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

10 ай бұрын

Check the spacing and the overall syntax thoroughly.

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

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.

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

21 күн бұрын

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

21 күн бұрын

@@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

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??

instead of sending each msg individual with each click, can it be set up to send all with a single click

@technologiate

11 ай бұрын

WhatsApp doesn't support bulk messages without API. You can not do that.

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

11 ай бұрын

You can put the number into new rows and drag the formula for new messages.

Thanks a lot 😊😊😊 How i could do this process using wasender app?

@technologiate

6 ай бұрын

You are welcome. I am not sure about the Wasender app.

In what’s app not showing message to send what can I do

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.

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?

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.

can i send image or pdf file too or just text message ?

@technologiate

11 ай бұрын

It works for text messages only.

Hi, very informative video. I have tried, in the last send option is not working...

@technologiate

10 ай бұрын

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.

How to send in group

Can you post a procedure for VIBER?

@technologiate

11 ай бұрын

Hello👋, I have responded to your email 📧 with the instructions. Thank you. 🙏

The formula isn't working in my Google sheet

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

10 ай бұрын

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.

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.

Can I send attached file also

@technologiate

Жыл бұрын

I will experiment with how we can send attachments as well. Thank you.

Hi, can you please share the method to send bulk message

@technologiate

3 ай бұрын

To send bulk messages via Google Sheets, you need 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?

@technologiate

Жыл бұрын

You can do that, but you would need API access for that.

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?

Can send last formula we didn't complete sir

@technologiate

Жыл бұрын

Sorry, I didn't get you.

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.

can we create a single 1 click button to send all the messages at once

@technologiate

8 ай бұрын

For that you will need WhatsApp 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 ?

@technologiate

Ай бұрын

Does the text contain a quotation(") mark?

# 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.

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

Hello is it possible to make 1 click which will send all messages at 1 time

@technologiate

5 ай бұрын

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.

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

4 ай бұрын

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.

Does it require API? How to get whatsapp link? Pl share

@technologiate

Жыл бұрын

It doesn't require API.

image?

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.

Can you please send me code only for creating a whastapp link? I dont want to add text in the hyperlink

@technologiate

Ай бұрын

You just need to remove this part in the formula: &text="&E2

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

21 күн бұрын

If the person does not have your contact saved, the link will not be blue and clickable.

@BrettHidgcock

21 күн бұрын

@@technologiate is there away to do this as the text is designed to send them to join a group page? Thanks

@BrettHidgcock

21 күн бұрын

@@technologiate it only allows me to turn the whole column of text into one big clickable link it seems

Hello please How to send message to all numbers in exel table by one click ?

@technologiate

11 ай бұрын

For that you need to have API access from WhatsApp.

Hello can we use whats Api with this?? process to send message

@technologiate

4 ай бұрын

This will not work with WhatsApp API. For that, you need to develop a different system.

@thebrandwagon-zj4tj

4 ай бұрын

Can you help me to make one?@@technologiate

why my link is keep incorect , i already folow your formula on 4:45 ? please help me

@technologiate

7 ай бұрын

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.

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

3 ай бұрын

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

3 ай бұрын

@@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 kzread.info/dash/bejne/aX5lxM19hd28g8o.html

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

11 ай бұрын

​@@technologiateIs there any update on this?

Hibhow do i send images too with the message

@technologiate

Ай бұрын

This process doesn't support adding images to the messages.

What if we want to post in whatsapp group?

@technologiate

3 ай бұрын

It can not send messages to a group.

I want to send whatsapp message when every a new data is entered in cell. How to do that

@technologiate

7 ай бұрын

You will require WhatsApp API or any other third-party API to automate sending messages.

Can we send images

@technologiate

10 ай бұрын

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".

@technologiate

7 ай бұрын

Please follow the template for the correct link. You will find the link in the video description.

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.

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

10 ай бұрын

Hi, there is no addional step. I think the final link contains some unnecessary space or character. Please check the syntax again and try.

How to add emoji?

@technologiate

10 ай бұрын

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?

@technologiate

9 ай бұрын

Hi, I have added the link for the Google sheet template in the video description. You can check that for the formulas.

how can we attach image in it?

@technologiate

Ай бұрын

Hi, this process doesn't support sending images with messages.

@tuhinsolitaire

Ай бұрын

@@technologiate is there any process to do it

Hahah way we wast time on that

This is so misleading 😂

@technologiate

Ай бұрын

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

@technologiate

Ай бұрын

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

@technologiate

8 ай бұрын

There is an error in the formula. Please look at the sample Google sheet in the video description.

thank you

@technologiate

Жыл бұрын

You are welcome 🙂