How to send WhatsApp messages from excel sheet automatically via Python including image/video/audio file
Welcome to the “Automate the things with Python: WhatsApp Automation” course, in which you will learn how to automate sending messages in WhatsApp.
You must be aware that we can send a message to only 5 people at a time, and that is a tedious job if you want to send the same message to hundreds of people quite often.
Lucky you are, you have landed on this course, with this course you will be able to automate that process, you will just make an excel/CSV file, put all the contact numbers and the message, and then you will just run the python file and our code will send WhatsApp message to each person mentioned in the excel file, how cool is that?
Not only that, but you will also learn how to attach multimedia along with the text message, here in the excel sheet you will just give a path to the media file, and our code will just fetch that file and will send it along with the WhatsApp text message.
In this course first, you will learn how to automate sending messages via ADB command, then we will do this on the WhatsApp desktop application, so you don`t even need to connect your mobile to a computer and still you will be able to send WhatsApp messages to excel sheet contacts.
I will start by helping you to get your setup done, which includes Python, pip, and, PyCharm IDE installation, we will install the required python packages as and when needed.
First, we will learn about the ADB command, how to type messages, do a call, lock the phone, change brightness, etc, via ADB command. Then we will automate the process of sending messages via ADB command, and then we will remove the dependency on mobile and automate the process of sending messages via WhatsApp desktop application.
