This program reads the name of the participants and marks the attendance of people present in the meeting directly in the excel sheet with python. The program is made using web scraping and automation using selenium and pyexcel.
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.
Install this package by typing the following code in terminal :
pip install selenium
Install this package by typing the following code in terminal :
pip install openpyxl
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 id, 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.