Infinite Campus selenium scraper for courses and grades to a linked Google Sheet. Created for Uncommon Hacks 2021.
- selenium
- gspread
- oauth2client
- In secret-template.json, replace all lines with relevant info.
- Rename the file to secret.json
- Go to console.cloud.google.com in your browser using your desire Google Account.
- Create NEW PROJECT. Give it whatever name you like. Click CREATE.
- Once the project has been created, via the search bar, enable the Google Drive API and Google Sheets API for this project.
- In the credentials tab, click CREATE CREDENTIALS. Click Service Account and give it whatever name you like. Click CONTINUTE and DONE.
- For this new service account, click on the pen and click ADD KEY > CREATE NEW KEY > JSON. Save this file in the folder as this app.
- Rename this file to "creds.json"
- In Google Drive, create and title a new Google Sheet. You will need this name later.
- Open creds.json and copy the "client_email" value and share your Sheet with this email.
- Refer to this website.