This program reads the name of the participants and marks the attendance of people present in the meeting directly into an Excel sheet with Python. The program utilizes selenium for web scraping and automation, and pyexcel for Excel sheet operations.
With the new version of chromedriver, problems with sign in may be faced. Follow the below steps for smooth run of the program:
If chrome isin't allowing to sign in then make a new gmail ID and try with that, or a different ID with which test browser has not yet been opened, or just clear all the cache of the existing ID (not reccomended).
Follow the following instructions to run the code in your local machine.
Install the web driver using Google ChromeDriver link. Unzip the file, copy the path of the folder and paste it in line 32 of the code. An example is given in the code itself.
Create an Excel workbook named Google_Attendance. Add a sheet named Attendance Sheet. Create the sheet in the following manner :
Save the sheet and place this sheet in the same directory as of the code.
The IDE in which you are running the code will ask you for your Gmail username, password and GoogleMeet link. Copy and paste the link from the meeting. And that's it. You can take attendance without much effort.
NOTE:
Keep the excel file closed while running the code.
If chrome takes time to redirect and open new link then adjust the value of sleep() functions accordingly.
Sahil Ahuja