This project is a Python script that automates sending messages on WhatsApp using the Selenium web automation library and managing data with Pandas and Openpyxl. It allows you to send messages to multiple WhatsApp contacts , listed in an Excel file. The script logs the sent messages and updates the spreadsheet with the status and timestamp of each message sent.
-
Automated WhatsApp Messaging: Send messages to multiple WhatsApp contacts with automated script execution.
-
Contact List Integration: Utilize an Excel spreadsheet to manage your contact list, including phone numbers and contact names.
-
Customizable Messages: Easily customize the content of your messages for a personalized touch.
-
Message Tracking: Keep track of the status and timestamp of sent messages directly in the spreadsheet.
-
Interactive Script: The script interacts with the WhatsApp Web interface, allowing you to scan the QR code for login.
-
Error Handling: Provides basic error handling to ensure the script continues processing even if it encounters issues with individual contacts.
-
User-Friendly: Designed for ease of use, with clear instructions for setup and execution.
-
Open Source: Modify and enhance the script to suit your specific automation needs.
-
Educational Purpose: This project is intended for educational purposes to demonstrate web automation using Python and Selenium.
-
Respectful Automation: Use this script responsibly and in compliance with WhatsApp's terms of service and applicable laws.
- Clone this repository or download the script to your local machine.
- Update the
driver_path
variable in the script with the correct path to ChromeDriver. - Create an Excel spreadsheet with the following columns:
phone
: Phone numbers of the contacts you want to message.name-surname
: Name and surname of the contact.has_send
: Status of the message (leave it blank initially).sending_date
: Timestamp of when the message was sent (leave it blank initially).
- Update the
URL
variable in the script with the path to your Excel spreadsheet. - Run the script by executing the following command in your terminal:
python whatsapp_automation.py
You can customize the message you want to send by modifying the send_message function in the script. Change the message content as needed.