automate_whatsapp.py

import pyautogui as pg
import webbrowser as web
import time
import pandas as pd

data = pd.read_csv("Attendence.csv")

data_dict = data.to_dict('list')

leads = data_dict['Mobile_No']

messages = data_dict['Message']

combo = zip(leads,messages)

first = True
for lead,message in combo:

    time.sleep(4)
    web.open("https://web.whatsapp.com/send?phone="+lead+"&text="+message)
    if first:
        time.sleep(6)
        first = False
    width, height = pg.size()
    pg.click(width / 2, height / 2)
    time.sleep(8)
    pg.press('enter')
    time.sleep(8)
    pg.hotkey('ctrl', 'w')