Goal: Automate the process of adding events to a Google Calendar by reading a CSV file.
CSV Format example:
"Subject","Start Date","Start Time","End Date","End Time","Description","Location" "Exercise","2024-10-14","07:00","2024-10-14","08:00","Workout","Gym"
Need:
- GCP API Auth2 permissions to access Google Calendar API setup
- store credentials.json in the same folder as this file
- calendar_events.csv to store the events in the same folder as this file
- calendar_id is the id of the calendar to add the events.
- run the script