main.py

# -*- coding: utf-8 -*-
"""
Spyder Editor

This is a temporary script file.
"""

import os
import pandas as pd
import pyautogui
import time
from datetime import datetime
#print(os.getcwd())

def signIn(meeting_id,password):

    #Open's Zoom Application from the specified location
    os.system("open /Applications/zoom.us.app")
    time.sleep(3)

    #Click's join button
    joinbtn=pyautogui.locateCenterOnScreen("test.png")
    print(joinbtn)
    pyautogui.moveTo(joinbtn)
    pyautogui.click()
    time.sleep(1)

    #Type the meeting id
    meetingidbtn=pyautogui.locateCenterOnScreen("meetingid_new.png")
    pyautogui.moveTo(meetingidbtn)
    pyautogui.write(meeting_id)
    time.sleep(2)

    # #To turn off video and audio
    # mediaBtn=pyautogui.locateAllOnScreen("media.png")
    # for btn in mediaBtn:
    #     pyautogui.moveTo(btn)
    #     pyautogui.click()
    #     time.sleep(1)

    #To join
    join=pyautogui.locateCenterOnScreen("join.png")
    pyautogui.moveTo(join)
    pyautogui.click()
    time.sleep(2)

    #Enter's passcode to join meeting
    passcode=pyautogui.locateCenterOnScreen("meetingPasscode.png")
    pyautogui.moveTo(passcode)
    pyautogui.write(password)
    time.sleep(1)

    #Click's on join button
    joinmeeting=pyautogui.locateCenterOnScreen("joinmeeting.png")
    pyautogui.moveTo(joinmeeting)
    pyautogui.click()
    time.sleep(1)

df = pd.read_excel('timings.xlsx', index_col=None)

while True:
    #To get current time
    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(3)
        signIn(meeting_id, password)
        time.sleep(2)
        print('signed in')
        break