Messaging Automation Project.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "97312e9a",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importing the selenium libraries\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "\n",
    "# Importing the pyautogui libraries\n",
    "import pyautogui as waitTime\n",
    "import pyautogui as keyboardKeys\n",
    "\n",
    "# By to work with more recent computers\n",
    "from selenium.webdriver.common.by import By\n",
    "\n",
    "# Importing the openpyxl library to work with Excel\n",
    "from openpyxl import load_workbook\n",
    "\n",
    "# Getting the path of the file + name of the file on the computer\n",
    "contacts_file_name = \"A:\\\\Python RPA\\WhatsApp\\Contacts.xlsx\"\n",
    "contactsDataSheet = load_workbook(contacts_file_name)\n",
    "\n",
    "# Selecting the Data sheet\n",
    "selected_sheet = contactsDataSheet['Data']\n",
    "\n",
    "# Emulating the Chrome browser\n",
    "chromeBrowser = webdriver.Chrome()\n",
    "\n",
    "# Opening the web page we need to open\n",
    "chromeBrowser.get(\"https://web.whatsapp.com/\")\n",
    "\n",
    "# Wait until the ID 'side' is found\n",
    "# While the size of the list is less than 1, keep trying to log in\n",
    "while len(chromeBrowser.find_elements(By.ID, 'side')) < 1:\n",
    "    # Wait 3 seconds to see if WhatsApp Web has logged in\n",
    "    waitTime.sleep(3)\n",
    "    \n",
    "# Wait 3 seconds to give the site time to process the information \n",
    "waitTime.sleep(3)\n",
    "\n",
    "# For loop to iterate through each contact\n",
    "for row in range(2, len(selected_sheet['A']) + 1):\n",
    "    \n",
    "    # Creating the variables name and message\n",
    "    contactName = selected_sheet['A%s' % row].value\n",
    "    contactMessage = selected_sheet['B%s' % row].value\n",
    "    \n",
    "    # Search by XPATH and type the contactName in the WhatsApp Web search field\n",
    "    chromeBrowser.find_element(By.XPATH, '//*[@id=\"side\"]/div[1]/div/label/div/div[2]').send_keys(contactName)\n",
    "    \n",
    "    # Wait 3 seconds to give the site time to process the information \n",
    "    waitTime.sleep(3)\n",
    "    \n",
    "    # Press the Enter key\n",
    "    keyboardKeys.press('enter')\n",
    "    \n",
    "    # Wait 3 seconds to give the site time to process the information \n",
    "    waitTime.sleep(3)\n",
    "    \n",
    "    # Search by XPATH for the message input field and send the message\n",
    "    chromeBrowser.find_element(By.XPATH, '//*[@id=\"main\"]/footer/div[1]/div/span[2]/div/div[2]/div[1]/div/div[2]').send_keys(contactMessage)\n",
    "    \n",
    "    # Wait 3 seconds to give the site time to process the information \n",
    "    waitTime.sleep(3)\n",
    "    \n",
    "    # Press the Enter key to send the message\n",
    "    keyboardKeys.press('enter')\n",
    "    \n",
    "    # Wait 3 seconds to give the site time to process the information \n",
    "    waitTime.sleep(3)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "55a5e964",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a0093c3e",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importing the selenium libraries\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "\n",
    "# Importing the pyautogui libraries\n",
    "import pyautogui as waitTime\n",
    "import pyautogui as keyboardKeys\n",
    "\n",
    "# By to work with more recent computers\n",
    "from selenium.webdriver.common.by import By\n",
    "\n",
    "# Importing the openpyxl library to work with Excel\n",
    "from openpyxl import load_workbook\n",
    "\n",
    "# Getting the path of the file + name of the file on the computer\n",
    "contacts_file_name = \"A:\\\\Python RPA\\WhatsApp\\Contacts.xlsx\"\n",
    "contactsDataSheet = load_workbook(contacts_file_name)\n",
    "\n",
    "# Selecting the Data sheet\n",
    "selected_sheet = contactsDataSheet['Data']\n",
    "\n",
    "# Emulating the Chrome browser\n",
    "chromeBrowser = webdriver.Chrome()\n",
    "\n",
    "# Opening the web page we need to open\n",
    "chromeBrowser.get(\"https://web.whatsapp.com/\")\n",
    "\n",
    "# Wait until the ID 'side' is found\n",
    "# While the size of the list is less than 1, keep trying to log in\n",
    "while len(chromeBrowser.find_elements(By.ID, 'side')) < 1:\n",
    "    # Wait 3 seconds to see if WhatsApp Web has logged in\n",
    "    waitTime.sleep(3)\n",
    "    \n",
    "# Wait 3 seconds to give the site time to process the information \n",
    "waitTime.sleep(3)\n",
    "\n",
    "image = \"A:\\\\Python RPA\\WhatsApp\\Good_Night.jpg\"\n",
    "\n",
    "# For loop to iterate through each contact\n",
    "for row in range(2, len(selected_sheet['A']) + 1):\n",
    "    \n",
    "    # Creating the variables name and message\n",
    "    contactName = selected_sheet['A%s' % row].value\n",
    "    contactMessage = selected_sheet['B%s' % row].value\n",
    "    \n",
    "    # Search by XPATH and type the contactName in the WhatsApp Web search field\n",
    "    chromeBrowser.find_element(By.XPATH, '//*[@id=\"side\"]/div[1]/div/label/div/div[2]').send_keys(contactName)\n",
    "    \n",
    "    # Wait 3 seconds to give the site time to process the information \n",
    "    waitTime.sleep(3)\n",
    "    \n",
    "    # Press the Enter key\n",
    "    keyboardKeys.press('enter')\n",
    "    \n",
    "    # Wait 3 seconds to give the site time to process the information \n",
    "    waitTime.sleep(3)\n",
    "    \n",
    "    # CSS Selectors are used to identify elements that do not have ID or Name\n",
    "    # We are getting all the span tags with the data-icon attribute containing 'clip'\n",
    "    chromeBrowser.find_elements(By.CSS_SELECTOR, \"span[data-icon='clip']\")\n",
    "    \n",
    "    # Wait 2 seconds to give the site time to process the information \n",
    "    waitTime.sleep(2)\n",
    "    \n",
    "    # Click the clip icon\n",
    "    chromeBrowser.find_element(By.CSS_SELECTOR, \"span[data-icon='clip']\").click()\n",
    "    \n",
    "    # Click the image icon\n",
    "    # We are getting all the span tags with the input attribute containing 'file'\n",
    "    fileOptions = chromeBrowser.find_element(By.CSS_SELECTOR, \"input[type='file']\")\n",
    "    \n",
    "    # Wait 1 second to give the site time to process the information \n",
    "    waitTime.sleep(1)\n",
    "    \n",
    "    # Send the image from the computer to WhatsApp Web\n",
    "    fileOptions.send_keys(image)\n",
    "    \n",
    "    # Wait 3 seconds to give the site time to process the information \n",
    "    waitTime.sleep(3)\n",
    "    \n",
    "    # Search by XPATH for the message input field and send the message\n",
    "    chromeBrowser.find_element(By.XPATH, '//*[@id=\"app\"]/div/div/div[2]/div[2]/span/div/span/div/div/div[2]/div/div[1]/div[3]/div/div/div[