Send WhatsApp Message from Google Sheets | Google Sheets WhatsApp Integration
Vložit
- čas přidán 5. 09. 2024
- In this video, you'll learn Google Sheets and WhatsApp integration, where you can send bulk messages from Google Sheets to WhatsApp with the help of Pabbly Connect.
⚡ Not just the above software, one can integrate any software quickly with Pabbly Connect and automate marketing, sales, payments, or any business processes in minutes without needing any programming skills.
_________________________________________________________________________
🔗 Links You Need:
Pabbly Connect Website: www.pabbly.com...
Pricing Details: www.pabbly.com...
Workflow Link: connect.pabbly...
_________________________________________________________________________
Pabbly Connect makes it easy to integrate and automate any software, marketing, sales, payments, or business processes quickly, without the need for any programming knowledge.
Benefits of Pabbly Connect:
1. Automation: Save time, money, and resources by automating tasks.
2. Integration: Connect various web services to create efficient workflows.
3. Security: Enjoy industry-standard security for your data.
4. Scalability: Easily add new applications and services to your workflow.
5. Cost-effective: Choose from plans suitable for different business sizes, with no charges for internal tasks.
Unlike other integration tools, Pabbly Connect offers absolutely no charges for internal tasks such as mathematical operations, spreadsheet functions, time zone conversions and more. Additionally, you can create unlimited automation workflows for your business without any restrictions.
-----------------------------------------------------------------------------------------------------
Additional Resources:
📢 All Integrations: www.pabbly.com...
❓Talk to our team at: support@pabbly.com
❓Ask your queries in Pabbly Forum: forum.pabbly.com/
📘Join Facebook Group : / pabbly.connect
Disclaimer: All Names, Mobile Numbers, and Emails used in the video are just for demo purposes. This is an educational video showing how to automate and integrate multiple platforms.
Basically it's a good video. Even the basics are explained which is basically good for beginners like me who don't know even the basics. 👍
Glad you enjoyed it!
😊
Yeah basically he got the basics
Easy best explanation very clear understanding
Thank you sir
You are most welcome
Great tool sir kindly start affiliate program for your product
Thank you @Aurangabad_Property...We're already running an affiliate program. You can check it here - www.pabbly.com/affiliates/
A very good teacher..clear explaination..good job
Glad you liked it!
Nice presentation. But I do not know how many tried first and then gave feedback. I tried multiple times and at all times the value that is generating in Iterator is not condensed.
Please post support questions here so that the team can review your workflow once - forum.pabbly.com/
I already Try this. Awesome Result, easy to install and used. Are there any API for WA, Telegram Chat alternatif (CHAT API) for indonesia users
Yes, WA API and Telegram are available inside Pabbly Connect.
Please check these videos -
1) Google Sheets to Telegram - czcams.com/video/cDjYm5BVcQg/video.html
2) Razorpay to WA API - czcams.com/video/4mk2nL4u-7U/video.html
I hope this information helps.
Thank You
@@Pabbly do you have for excel to whatsapp? or telegram to whatsapp?
@@happypeople9728 We do not have MS Excel Integration. We have Google Sheets integration for now. Although we keep on updating integrations every once in a while. So better to check it again later in few months.
Sir.. Can we use this to send bulk watsapp messages to 3000 plus contacts in Address book created through Visual Basics, (Used in Restaurant to enter the details of customers called, billing etc)..Please Reply
If you can import that through CSV file in your google sheet you can do it.
www.pabbly.com/out/signup-for-free - Do signup here for the forever FREE account of Pabbly Connect and start automation. You will get 100 tasks every month in the FREE account of Pabbly Connect.
SIr, Please try if you can asnwer this question. is it possible to send images ( multiple) or jpg files through this technic or any other workflow ?
You can ask your technical questions on our forum at
forum.pabbly.com/
Hi, great application, but if the phone numbers are not saved, the following operation cannot be done, is there a way to do this operation without saving the phone numbers
Hi, thanks for your feedback. Please provide more details on your concern at our technical support forum forum.pabbly.com. Our experts are ready to assist. You can also email us at support@pabbly.com. Thanks for choosing Pabbly Connect!
great video, i have one question? can sent whats app msg as a workflow method? or sequence based method
Hey, hope you are doing well.
You just need to create workflow once and turn workflow "On". Pabbly Connect will automatically send the WhatsApp message.
Thank you.
Suppose I made all the setting then on everyday I need to update the text, is it possible that everyday on the same schedule time the messages will deliver even the test already changed???
You can ask your technical questions on our forum at
forum.pabbly.com/
Hi thanks for this. Can we use this feature on Whatsapp Business app (IPhone) and if we need to pay for this?
You can use this for any WhatsApp Business number.
Here is the link of official WhatsApp API - developers.facebook.com/docs/whatsapp/pricing/
Hi! thanks for the info. Why I don't find WhatsApp on the app browser to connect?
We do this integration using Whatsapp APIs. For integration, you need to use Whatsapp api on connect app browser named Chat API, WA API, Whatsrise, WATI.
When I did that save thing my number and message weren't there random text like error and I didn't have name in the excel sheet is that a reason
Please post your support questions here so that our team can review your workflow once - forum.pabbly.com/
I am creating the workflow for regular intervals that is after every 7 days. But I don't find the option to select the day of the week or date. Is there something amiss? Can you please help me with this
You use the delay module for this use case.
It was a Good explaination. You might create a separate video for the second part may individual meassge. its confused.
You can contact our support team here for further assistance - forum.pabbly.com/
Very Helpful
Glad to hear that
Hi, is it possible do the same thing with WA Web Plus instead of Chat API? Thanks
This integration is not available at the moment. However, we've shared your suggestion with the team.
Please submit your integration request here - pabbly.hellonext.co/
Thank you
Whatsapp introduced limitations to prevent spam messaging. If I send multiple identical messages, don't I run the risk of my number getting blocked by whatsapp?
Google Sheets has the limit of adding 100 rows per 100 seconds per user. Also, Chat API highly recommended that you do not send bulk messages. It is very likely that you will be banned by the Whatsapp anti-spam system. So try to work according to the application (Google Sheet & Chat API) parameters after reading their documentation carefully.
Thank You
If you are interested in Whatsapp automation marketing, we are here. Send Bulk SMS, up to 100,000+ per day and easily reach thousands of potential customers. View my profile to learn more.
hi there, isn't that Whatapps has a 24 hour rule, that you cannot simply blast a message to your customers without them initiated a conversation with you? And if business would like to initiate a conversation, u have to follow a certain message template that is approved by Whatapps? Is this still doable now?
If you want to send message on WhatsApp you need to summit template for approval to them once template is approved you can send message to user.
www.pabbly.com/out/signup-for-free - Do signup here for the forever FREE account of Pabbly Connect and start automation. You will get 100 tasks every month in the FREE account of Pabbly Connect.
If you are interested in Whatsapp automation marketing, we are here. Send Bulk SMS, up to 100,000+ per day and easily reach thousands of potential customers. View my profile to learn more.
I think Whatsapp Broadcast message is more simple then this process & can send a message to multiple people in one go.. Any good reason to use this process via Pabbly?
No, WhatsApp broadcast message is sent only to those people whose contact number you have saved in your phone and not to unknown people. With Pabbly Connect, you can send message to any number without saving it.
@@Pabbly Can I Send bulk watsaap msg let's say 50000+
Thank you for this amazing video , can we add a video to the text message ?
Yes you can !
www.pabbly.com/out/signup-for-free - Do signup here for the forever FREE account of Pabbly Connect and start automation. You will get 100 tasks every month in the FREE account of Pabbly Connect.
@@Pabbly how to add a picture and send for multiple in WhatsApp
While sending message, Getting error "need uid and type parameters in application/X-www-form-urlencoded" please help.
Can you try using 360Dialog it is an Officially API of WhatsApp. hub.360dialog.com/
How to integrate Chat API with pabbly?
Do we have to install Chat API software or extension?
Instead of Chat API you can use 360dialog.
forms.pabbly.com/form/share/kaw1-474992
I have data with me and I want to send the message in WA.. if I send msg on amost 2k data base will not it will block my whatsapp account.. right..?
Google Sheets has the limit of adding 100 rows per 100 seconds per user. Also, Chat API highly recommended that you do not send bulk messages. It is very likely that you will be banned by the Whatsapp anti-spam system. So try to work according to the application (Google Sheet & Chat API) parameters after reading their documentation carefully.
Thank You
Great tips and tricks sir, we can set remember
Yes, thanks
@@Pabbly how to do it,tell me
Can we send WhatsApp msg from Google Sheet to WhatsApp when particular condition will be satisfied ?
Pls reply 🙏
If yes, How ?
Pls make a video on this 🙏
Yes that should be possible. For more information, please contact our team at admin@pabbly.com
@@Pabbly ok, Thanks
Hi sir thankyou for this,. Can we control sending FROM number to TO number, because I have 4 sales team from different department, i want customer replies to particular salesman
You can ask your technical questions on our forum at
forum.pabbly.com/
If you are interested in Whatsapp automation marketing, we are here. Send Bulk SMS, up to 100,000+ per day and easily reach thousands of potential customers. View my profile to learn more.
Kindly tell about Privacy issue what data is saved by pabbly?
All your data is safe with Pabbly Connect.
when did it show add new connection n existing connection I tried a lot when clicked on google sheet it showed authenticates google
sheet account each time n shows plz authorize this app
Hello,
The “authorization is required” error arises when you are logged into multiple Google accounts in the same window while setting up the Google Sheets add-on. To avoid this error, create your workflow in the incognito window or if you are creating it in a normal window, please make sure that you are logged into a single Google account only.
I hope this information helps.
Thank You :)
@@Pabbly ohhh
Do signup here for the forever free account of Pabbly Connect and start automation. You will get 100 tasks every month in the free Pabbly Connect account - www.pabbly.com/out/signup-for-free
I love your explanation, long process though
Glad it was helpful!
Hello sir, is that any problem for HP laptop ?
Hello,
There is no such problem.
There is a problem in pabbly connect "some error". please provide me the solution.
@Sajjan Kr. (Bihar)
What is the error?
I'm facing the same problem..not saving..because range is not mentioned
Please post support questions here so that the team can review your workflow once - forum.pabbly.com/
Hi can we send images through pabbly
Hello,
Please watch this video: czcams.com/video/Kljlvaiy9Sk/video.html
Can we do an automated msgs to a group of people based on certain conditions using this tool? if the condition is true the msg will sent otherwise no. Like if you know the automated email campaigns
let me know if that is possible with this tool
and also one more question - can we send these msgs using WhatsApp Business account
Yes, you can send the message on the basis of conditions by using our Router feature.
Also, you can ask your technical questions on our forum at
forum.pabbly.com/
If you are interested in Whatsapp automation marketing, we are here. Send Bulk SMS, up to 100,000+ per day and easily reach thousands of potential customers. View my profile to learn more.
hello i have pabbly connect and i automated my video lessons with activecampaign . my subscriber get daily one email lesson though automated email . so my question is that possible to integrate pabbly and watsap as same as like pabbly with email ? and if its possible then please tell me how ?
Yes, it is possible.
Add the Chat API action after your email action.
Here, you can choose any event according to your usecase like - Send Message, Send File and more.
Please check this video - czcams.com/video/EEcZkDgivkE/video.html
I hope this information helps.
Thank You
@@Pabbly thanks for reply .
is that possible,anyone from your team can help me for doing all this integration properly ?
Yes, Please post support questions here so that the team can review your workflow once - forum.pabbly.com/
Thanks
@@Pranay_Pawar10 Yes, you can talk to our team at admin@pabbly.com
can you please tell me what is the alternative to Chat API as it has become deprecated?
please tell me other than whatsapp api
Hello,
You can use WhatsApp Cloud API, 360Dialog, WATI, DoubleTick, Interakt or any other official WhatsApp API service.
Hello!! I have done the same as explained in the video and I have also purchased Chat API and integrated it but when I am trying to save and send request I am getting " You have reached your development limit" and my messages are not being sent on WhatsApp. So what is this issue?? I have even paid for Chat API
Can you please post your question on forum.pabbly.com ? Our Technical team will be helping you out with this problem.
I'm unable to add Google sheet the page loads for a longer time and the browser crashes
Tried in different devices
Please post support questions here so that the team can review your workflow once - forum.pabbly.com/
When I add the range it doesn't work, how can I chat with customer support?
Please write us at forum.pabbly.com
Do we need to save the numbers in the phone to send whatsapp message ? Or we can send message without saving the number
You can send message without saving the number
@@Pabbly do we need to buy pabbly subscription to send bulk message?
You can signup here for the forever free account of Pabbly Connect and start automation. You will get 100 tasks every month in the free Pabbly Connect account - accounts.pabbly.com/signup/
@@Pabbly what do you mean by free task? Does it mean i can send unlimited messages 100 times a month? Or it means something else ?
Hi, Chat API does not come up as an option. Which other platform can I use?
Hello,
You can use WhatsApp Cloud API.
Can we configure bot for auto response for Whatsapp API
Yes, you can use Pabbly Connect to configure a bot for auto responses for Whatsapp API. If you encounter any technical issues, please visit our forum at forum.pabbly.com or email us at support@pabbly.com. Also, sign up for a free trial to further explore Pabbly Connect.
Yes, you certainly can configure a bot for auto-response on WhatsApp API using Pabbly Connect. We also offer support services for any technical issues. Feel free to contact us at support@pabbly.com or visit forum.pabbly.com. Remember to sign up for a free trial to explore more features!
Nice I video but a small suggestion please hide the contact numbers in your presentation
Ok thank you
What is the maximum limit of sending messages to the contacts. I have millions of contact numbers. What will be the best way for me to have this?
You can use this same workflow.
Do signup here for the forever free account of Pabbly Connect and start automation. You will get 100 tasks every month in the free Pabbly Connect account - www.pabbly.com/out/signup-for-free
i have a google sheet that has a timestamp column , i want to send a message to consarned person on that time and data who can i do this please make a video about this
Sure, We will soon create a video on this topic.
I have to send video to those contacts which are available in my .vcf file.how can I do
You can Import them in Google Sheets and then send in Google Sheets.
is bulk iwhatsapp image sending on pabbly free? or have charges
Hello,
Please watch this video for task consumption related information - czcams.com/video/YxK95UMwTD8/video.html
How to obtain chat api URL and taken- not able figure out. Please help
Please watch this video - czcams.com/video/uvkcUEp21cc/video.html
Dear sir it’s huge request from your customer that make an video on
Shopify abandonment car recovery automation video
Plz suggest and help we have mailed many time to team
so it’s help all the e-com community.
Thanks
We will try
It is difficult to understand your strong Indian accent, especially when you speak so fast. i could not understand what MODE you said we should be using. I had to slow down the playback speed to finally hear that you said "incognito mode". For those of us who don't use incognito mode it would have helped it you explained how to switch to incognito mode. It would also help if you explained about Pabbly as to how much it costs to send messages. I assume a free account has limits?
Hello,
Thank you for the feedback.
We will work around Pabbly Connect Video and improvise it.
Also there is no such limitation in Pabbly Connect Free Account only it limits to number of task.
Array are not selected the values what should i do ?
Now, it automatically detects the array value just click on the Save & Send Test Request button.
Hello, I checked the pricing, what does 100 Tasks/Operations mean?
Check this video.
czcams.com/video/YxK95UMwTD8/video.html
complicated... Not at all user friendly...
We need to pay ChatAPI in order to get the URL link and token?
Yes, you will be needing to get Chat API application as well for this.
Do signup here for the forever free account of Pabbly Connect and start automation. You will get 100 tasks every month in the free Pabbly Connect account - www.pabbly.com/out/signup-for-free
Sir..
Any app like ChatApi for whatsapp ?
Yes, WAapi, Gupshup etc.
I am Govt School teacher..
I have to send students marks to their parents Whatsapp.
But ChatApi costly app.
Any free app like ChatApi.
Do you have google sheet to google voice
No, Can you please write to us here: pabbly.hellonext.co/b/Integration-Request
Man you said basically 500 times in 1 minutes
Thanks for your feedback. We shall improve this.
www.pabbly.com/out/signup-for-free - Do signup here for the forever FREE account of Pabbly Connect and start automation. You will get 100 tasks every month in the FREE account of Pabbly Connect.
what is the max number messages , whats app can send with pabbly
There is no limit in Pabbly Connect.
Do signup here for the forever free account of Pabbly Connect and start automation. You will get 100 tasks every month in the free Pabbly Connect account - www.pabbly.com/out/signup-for-free
Can you help me please with this issue, every time i input the range of the spreadsheet it says not matched result
You can ask your technical questions on our forum at
forum.pabbly.com/
It showed me the individual data without using json extractor. Is it ok ?
Yes
We've updated our iterator feature so it works without the JSON extractor.
Did you guys come up with Whatsapp API automation yet..
If you are interested in Whatsapp automation marketing, we are here. Send Bulk SMS, up to 100,000+ per day and easily reach thousands of potential customers. View my profile to learn more.
Hey,
Yes Please check this integration: www.pabbly.com/connect/integrations/whatsapp-cloud-api/
Is it possible to send a hyperlink inside the messages?
Yes, it is possible.
THIS IS HOW TO SEND INDIVIDUAL MESSAGES BUT HOW ABOUT THE SENDING THE MESSAGES TO THE GROUP???
Hello,
Please refer this video to send WhatsApp messages to the group - czcams.com/video/_wHBWZt-TBs/video.html
Thank You
How can we schedule them to be sent periodically over time?
You can use "At Regular Interval" option of scheduler to send messages at particular time.
i have set up work flow but only one message is sent to one person
You can ask your technical questions on our forum at
forum.pabbly.com/
how to bulk message like send message to multiple recipient
You can ask your technical questions on our forum at
forum.pabbly.com/
Hello , while we copy data from google sheet , script error is coming
Please post support questions here so that the team can review your workflow once - forum.pabbly.com/
How much bulk message has to be send, by which our Whatsapp can't be block.
Google Sheets has the limit of adding 100 rows per 100 seconds per user. Also, Chat API highly recommended that you do not send bulk messages. It is very likely that you will be banned by the Whatsapp anti-spam system. So try to work according to the application (Google Sheet & Chat API) parameters after reading their documentation carefully.
Thank You
Hello sir,
do we can sent images + messages to 500+ contacts at a time ?
We recommend signing up here for the free account and explore the application yourself - accounts.pabbly.com/signup/
Can we send images instead of text messages?
Yes we can do it with Pabbly Connect.
www.pabbly.com/out/signup-for-free - Do signup here for the forever FREE account of Pabbly Connect and start automation. You will get 100 tasks every month in the FREE account of Pabbly Connect.
Can i send imagens using this tool?
Yes you can send Images using Pabbly Connect.
www.pabbly.com/out/signup-for-free - Do signup here for the forever FREE account of Pabbly Connect and start automation. You will get 100 tasks every month in the FREE account of Pabbly Connect.
Is it possible ti liked an image to massive messages?
Yes, you can do it with this automation.
www.pabbly.com/out/signup-for-free - Do signup here for the forever FREE account of Pabbly Connect and start automation. You will get 100 tasks every month in the FREE account of Pabbly Connect.
Can we send the same message upto 1000 contacts?
Yes
@@Pabbly what is daily limit. Hope whts app didn't block us due to his spaming policy
Google Sheets has the limit of adding 100 rows per 100 seconds per user. Also, Chat API highly recommended that you do not send bulk messages. It is very likely that you will be banned by the Whatsapp anti-spam system. So try to work according to the application (Google Sheet & Chat API) parameters after reading their documentation carefully.
Thank You
If you are interested in Whatsapp automation marketing, we are here. Send Bulk SMS, up to 100,000+ per day and easily reach thousands of potential customers. View my profile to learn more.
We need to take chat api subcription?? how do we do that?
Please visit Chat API official website to purchase a subscription.
Not working with new interface
You can ask your technical questions on our forum at
forum.pabbly.com/
In this is chat UPI paid version or free?
Paid account
This process is so complicated could you please suggest in simple format
Please post support questions here so that the team can assist you - forum.pabbly.com/
Thanks!
chat api is not appering to me why?
Hello,
Instead of Chat API you can use Official WhatsApp APIs like WhatsApp Cloud API, Interakt, WATI,
360Dialog, AiSensy, DoubleTick etc.
Sir, I am unable to send bulk WhatsApp messages in just a one click, so please suggest me how it works.
Please post support questions here so that the the team can review your workflow once - forum.pabbly.com/
Thanks!
If you are interested in Whatsapp automation marketing, we are here. Send Bulk SMS, up to 100,000+ per day and easily reach thousands of potential customers. View my profile to learn more.
What to do if range is not mentioned
Please post support questions here so that the team can review your workflow once - forum.pabbly.com/
Can we add pictures too?
Yes
Sir any website though
Can you please explain?
Sir,
I want to share google Forms with my students. How to do ?
Hello,
Please check this video - czcams.com/video/V14wncZRpuU/video.html
I hope it will help you.
Work in phone or laptop
Pabbly Connect works in Laptop.
www.pabbly.com/out/signup-for-free - Do signup here for the forever FREE account of Pabbly Connect and start automation. You will get 100 tasks every month in the FREE account of Pabbly Connect.
Is there chance to ban the WhatsApp contact by using such integration ?
Yes if try to send spam messages then your number can get banned.
Do signup here for the forever free account of Pabbly Connect and start automation. You will get 100 tasks every month in the free Pabbly Connect account - accounts.pabbly.com/signup/
does whatsapp block the message
Hello Jayashree,
Please ref this document: developers.facebook.com/docs/whatsapp/messaging-limits
I send The message for one student But i don't know how to send for all student
Please post support questions here so that the team can review your workflow once - forum.pabbly.com/
Thanks!
Can we send pdf, audio and video to unlimited contacts at a time...
Google Sheets has the limit of adding 100 rows per 100 seconds per user. Also, Chat API highly recommended that you do not send bulk messages. It is very likely that you will be banned by the Whatsapp anti-spam system. So try to work according to the application (Google Sheet & Chat API) parameters after reading their documentation carefully.
Thank You
@@Pabbly thank you
The number will not banned?
If you try to send spam messages, then it will be blocked.
Do signup here for the forever free account of Pabbly Connect and start automation. You will get 100 tasks every month in the free Pabbly Connect account - accounts.pabbly.com/signup/
can i send image instead of text message ?
Yes, it is possible. For your usecase, there is just a small action needed in this workflow after the Chat API -> Send Message action.
After the Chat API action click on the + icon and choose again Chat API app and select the "Send File" event from the drop-down. With this action, you can send images to Whatsapp by adding image links.
You can also refer this video for sending images - czcams.com/video/EEcZkDgivkE/video.html
I hope this information helps.
Thanks..
I tried it but not able to send can you explain me one more time
Please post support questions here so that the the team can review your workflow once - forum.pabbly.com/
Nice but please tell can WhatsApp ban my account sending more messages
If you can use Official API of WhatsApp to send message it will decrease the changes of your number getting blocked.
Get Official WhatsApp API from here: forms.pabbly.com/form/share/kaw1-474992
Thanks, But do i have to do the same process for all people i have in the csv file you explained how to extract the data for Amy then you sent the message but that lead to sending the message to only Amy not all the people like you mentioned in the beginning of the video you said that i can send bulk messages.
You can contact our support team here for further assistance - forum.pabbly.com/
Can we use the same 10000+ customers in single shot
Hello,
Yes, you can do that with Pabbly Connect.
Is there any solution to send image instead of text?
Yes
Please check this video - czcams.com/video/EEcZkDgivkE/video.html
how did you get that link from WhatsApp in the last portion
Which portion?
How to send in only a group
Hello,
Please check this video to send messages in WhatsApp group
Link - czcams.com/video/mYWgKkGqBOI/video.html
Further you can signup here for the forever free account of Pabbly Connect and can start automation - www.pabbly.com/out/signup-for-free
But can we change the logo and name
Can you please elaborate your question?
@@Pabbly
Sir I am sending bulk transactional sms. So when customer receive the sms in whatsapp. The customer should recognise just by looking of the "Logo and the Name. Because when we send it goes like spam that's what my doubt sir like how to add a logo or change it something like that sir.
Hey,
You can purchase 360dialog API for sending WhatsApp messages from you can change your logo and name for the account.
Here is the form link for 360dialog API at discounted price: forms.pabbly.com/form/share/kaw1-474992
How to Send in bulk (let say 50+ Mobile numbers)
Mostly Videos show how to send in one contact
In this video we have sent Whatsapp messages to about 20 contacts. If you want to send the message on 50+ numbers plz add them in Google Send it will send automatically.
If you are interested in Whatsapp automation marketing, we are here. Send Bulk SMS, up to 100,000+ per day and easily reach thousands of potential customers. View my profile to learn more.