March 20, 2025/
I recently came across a forum post where someone asked about creating a scheduling system using Google Sheets. As I...
This project came about because I like to create project plans starting in Excel. I was curious to see if I could put meetings on my Google Calendar. A direct link to the notebook can be found on my github.
from apiclient.discovery import build
from google_auth_oauthlib.flow import InstalledAppFlow
from httplib2 import Http
scopes = ['https://www.googleapis.com/auth/calendar']
flow = InstalledAppFlow.from_client_secrets_file("client_secret_calendar.json", scopes=scopes)
credentials = flow.run_console()
#log in and copy credentials
import pickle
pickle.dump(credentials, open("token.pkl", "wb"))
credentials = pickle.load(open("token.pkl", "rb"))
service = build("calendar", "v3", credentials=credentials,cache_discovery=False)
result = service.calendarList().list().execute()
result = service.events().list(calendarId=calendar_id).execute()
print(result['items'][0])
# The calendar you want to update may be a different index
calendar_id = result['items'][1]['id']
import pandas as pd
from datetime import datetime, timedelta
file_path = 'Filepath & File.xlsx'
df_calendar = pd.read_excel(file_path)
# df_calendar.head()
date = df_calendar['Date']
general_bucket = df_calendar['General Bucket']
start_time = df_calendar['Start Date Time']
end_time = df_calendar['End Date Time']
task = df_calendar['Task']
def create_event(start_date_time, end_date_time, event_title):
description=None
location=None
event = {
'summary': event_title,
'location': location,
'description': description,
'start': {
'dateTime': start_date_time,
'timeZone': 'America/New_York',
},
'end': {
'dateTime': end_date_time,
'timeZone': 'America/New_York',
},
}
return service.events().insert(calendarId=calendar_id, body=event,sendNotifica
import json
df_test=df_calendar[['Start Date Time','End Date Time','Task']]
df_test['Start Date Time'] = df_test['Start Date Time'].apply(lambda x: x.strftime
df_test['End Date Time'] = df_test['End Date Time'].apply(lambda x: x.strftime("%Y
start = df_test['Start Date Time']
end = df_test['End Date Time']
title = df_test['Task']
for i in range(len(df_test)) :
create_event(start[i],end[i],title[i])
print("Completed")
I recently came across a forum post where someone asked about creating a scheduling system using Google Sheets. As I...
When working with financial data, efficiency matters. Traders, analysts, and data scientists rely on various storage formats—CSV, Parquet, and SQLite—for...
Introduction Key Points To Call Out
All rights are reserved.