Hi,
Well, we all know Zoom is a video conferencing app which allows us to attend/conduct meetings. And because of this pandemic situation, the usage of these video conferencing apps also increased drastically and even for school kids this became a new normal and sometimes these continuous online classes becomes cumbersome.
ย ย ย And today we gonna learn how to automate zoom such that it automatically logs into one's meetings/classes on time.
For this, we need
Behind the scenes:
- An infinite loop keeps checking the current time of the system using "datetime.now" funtion.
- The zoom app is opened using "os.startfile()" funtion as soon as current time matches the time mentioned in "timings.xlsx".
- "pyautogui.locateOnScreen()" function locates the image of join button on the screen and returns the position.
- "pyautogui.locateCenterOnScreen()" function locates the center of the first found instance of the image on the screen.
- "pyautogui.moveTo()" moves the cursor to that location.
- "pyautogui.click()" performs a click operation.
- The meeting Id and Passcode are entered using the "pyautogui.write()" command.
Steps for Automating:
1. import necessary modules
import os
import pandas as pd
import pyautogui
import time
from datetime import datetime
os - Provides a way of using operating system dependent functionality.
pandas - Allows us to store and manipulate tabular data in rows and columns of variables.
pyautogui - A module which helps to control the mouse and keyboard, and other GUI automation tasks.
2. Open's zoom application from the specified location
os.startfile(" ")
3. To click join button
joinbtn=pyautogui.locateCenterOnScreen("")
pyautogui.moveTo(joinbtn)
pyautogui.click()
4. Similarly, like join button we have to take screenshot of every button to click or to locate
meetingidbtn=pyautogui.locateCenterOnScreen("")
pyautogui.moveTo(meetingidbtn)
pyautogui.write(meeting_id)
5. To enter passcode
passcode=pyautogui.locateCenterOnScreen("")
pyautogui.moveTo(passcode)
pyautogui.write(password)
6. Create an excel file and add all meeting details like "Timings", "Meeting id" and "Password"
7. Now import that excel file using pandas
df = pd.read_excel('',index=False)
8. Now we will write while loop to constantly check for the current time and compare the timings in excel file
while True:
now = datetime.now().strftime("%H:%M")
if now in str(df['Timings']):
mylist=df["Timings"]
mylist=[i.strftime("%H:%M") for i in mylist]
c= [i for i in range(len(mylist)) if mylist[i]==now]
row = df.loc[c]
meeting_id = str(row.iloc[0,1])
password= str(row.iloc[0,2])
time.sleep(5)
signIn(meeting_id, password)
time.sleep(2)
print('signed in')
break
Check out my GitHub repo to get code and assets for buttons
Source code for Automation
import os
import pandas as pd
import pyautogui
import time
from datetime import datetime
def signIn(meeting_id,password):
os.startfile("")
time.sleep(3)
joinbtn=pyautogui.locateCenterOnScreen("")
pyautogui.moveTo(joinbtn)
pyautogui.click()
time.sleep(1)
meetingidbtn=pyautogui.locateCenterOnScreen("")
pyautogui.moveTo(meetingidbtn)
pyautogui.write(meeting_id)
time.sleep(2)
mediaBtn=pyautogui.locateAllOnScreen("")
for btn in mediaBtn:
pyautogui.moveTo(btn)
pyautogui.click()
time.sleep(1)
join=pyautogui.locateCenterOnScreen("")
pyautogui.moveTo(join)
pyautogui.click()
time.sleep(2)
passcode=pyautogui.locateCenterOnScreen("")
pyautogui.moveTo(passcode)
pyautogui.write(password)
time.sleep(1)
joinmeeting=pyautogui.locateCenterOnScreen("")
pyautogui.moveTo(joinmeeting)
pyautogui.click()
time.sleep(1)
df = pd.read_excel('',index=False)
while True:
now = datetime.now().strftime("%H:%M")
if now in str(df['Timings']):
mylist=df["Timings"]
mylist=[i.strftime("%H:%M") for i in mylist]
c= [i for i in range(len(mylist)) if mylist[i]==now]
row = df.loc[c]
meeting_id = str(row.iloc[0,1])
password= str(row.iloc[0,2])
time.sleep(5)
signIn(meeting_id, password)
time.sleep(2)
print('signed in')
break
Demo video:
If you like my content, please consider supporting me
