Send automated bulk WhatsApp messages from an excel sheet | Whatsapp excel sheet | Whatsapp Message

About 

It is a python script that sends WhatsApp messages automatically from the WhatsApp web application. It can be configured to send advertising messages to customers. It read data from an excel sheet and sends a configured message to people.


Demo

  • Video clip on youtube of the script execution. Youtube

Prerequisites

In order to run the python script, your system must have the following programs/packages installed and the contact number should be saved in your phone (You can use bulk contact number saving procedure of email). There is a way without saving the contact number but has the limitation to send the attachment.

  • Python

Approach

  • User scans web QR code to log in to the WhatsApp web application.

Note: If you wish to send an image instead of text you can write attachment selection python code.

Demo

Code

# Program to send bulk customized message through WhatsApp web application
# Author @inforkgodarafrom selenium import webdriver
from selenium.webdriver.support.ui import WebDriverWait
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.common.action_chains import ActionChains
from selenium.common.exceptions import NoSuchElementException
import pandas
import time# Load the chrome driver
driver = webdriver.Chrome()
count = 0# Open WhatsApp URL in chrome browser
driver.get("https://web.whatsapp.com/")
wait = WebDriverWait(driver, 20)# Read data from excel
excel_data = pandas.read_excel('Customer bulk email data.xlsx', sheet_name='Customers')
message = excel_data['Message'][0]# Iterate excel rows till to finish
for column in excel_data['Name'].tolist():
    # Locate search box through x_path
    search_box = '//*[@id="side"]/div[1]/div/label/div/div[2]'
    person_title = wait.until(lambda driver:driver.find_element_by_xpath(search_box))    # Clear search box if any contact number is written in it
    person_title.clear()    # Send contact number in search box
    person_title.send_keys(str(excel_data['Contact'][count]))
    count = count + 1    # Wait for 3 seconds to search contact number
    time.sleep(3)    try:
        # Load error message in case unavailability of contact number
        element = driver.find_element_by_xpath('//*[@id="pane-side"]/div[1]/div/span')
    except NoSuchElementException:
        # Format the message from excel sheet
        message = message.replace('{customer_name}', column)
        person_title.send_keys(Keys.ENTER)
        actions = ActionChains(driver)
        actions.send_keys(message)
        actions.send_keys(Keys.ENTER)
        actions.perform()# Close Chrome browser
driver.quit()

Popular posts from this blog

XSS Vulnerability/Attacks

  Cross-site Scripting (XSS) is a client-side code injection attack. The attacker aims to execute malicious scripts in a web browser of the victim by including malicious code in a legitimate web page or web application. The actual attack occurs when the victim visits the web page or web application that executes the malicious code. The web page or web application becomes a vehicle to deliver the malicious script to the user’s browser. Vulnerable vehicles that are commonly used for Cross-site Scripting attacks are forums, message boards, and web pages that allow comments. A web page or web application is vulnerable to XSS if it uses unsanitized user input in the output that it generates. This user input must then be parsed by the victim’s browser. XSS attacks are possible in VBScript, ActiveX, Flash, and even CSS. However, they are most common in JavaScript, primarily because JavaScript is fundamental to most browsing experiences. What Can the Attacker Do with JavaScript? XSS vulnerabil
Read more

Python Speech To Text

About  A few lines of code written in python using libraries (SpeechRecognition, PyAudio) that convert speech to text. Prerequisites In order to run the python script, your system must have the following programs/packages installed. Python 3.6.7 SpeechRecognition 3.8.1 (Internet required to convert speech to text while execution) PyAudio Approach script.py execute in terminal. After a printed start in the terminal, you begin to speak in English and end once your sentence is completed. It will take a few minutes to convert speech to text and print it on your terminal. Code # Program to convert speech to text # Author @inforkgodara import speech_recognition as sr r = sr.Recognizer() mic = sr.Microphone() print('start') with mic as source: audio = r.listen(source) print('end')  print(r.recognize_google(audio))  
Read more