pip install pywin32 google-api-python-client google-auth-httplib2 google-auth-oauthlib

import win32com.client from datetime import datetime, timedelta import json import os from google_auth_oauthlib.flow import InstalledAppFlow from googleapiclient.discovery import build from google.oauth2.credentials import Credentials from google.auth.transport.requests import Request # ====================== # 設定 # ====================== SCOPES = ['https://www.googleapis.com/auth/calendar'] STATE_FILE = "synced_events.json" # ====================== # Outlook予定取得 # ====================== def get_outlook_events(): outlook = win32com.client.Dispatch("Outlook.Application") namespace = outlook.GetNamespace("MAPI") calendar = namespace.GetDefaultFolder(9) items = calendar.Items items.IncludeRecurrences = True items.Sort("[Start]") # V1.1 old:start = datetime_now() start = datetime.now() - timedelta(days=2) end = start + timedelta(days=30) # V1.2 start_str = start.strftime("%m/%d/%Y") end_str = end.strftime("%m/%d/%Y") restriction = f"[Start] >= '{start_str}' AND [Start] <= '{end_str}'" restricted_items = items.Restrict(restriction) events = {} for item in restricted_items: try: # v1.2 start_val = item.Start end_val = item.End if not start_val or not end_val: continue key = item.EntryID + start_val.strftime("%Y-%m-%dT%H:%M:%S") events[key] = { "title": item.Subject or "", "start": start_val.strftime("%Y-%m-%dT%H:%M:%S"), "end": end_val.strftime("%Y-%m-%dT%H:%M:%S"), "location": item.Location or "", "updated": str(item.LastModificationTime) } except Exception as e: # v1.2 print("エラー:", e) continue return events # ====================== # Google認証 # ====================== def get_google_service(): creds = None if os.path.exists("token.json"): creds = Credentials.from_authorized_user_file("token.json", SCOPES) # v1.1 if creds and creds.expired and creds.refresh_token: creds.refresh(Request()) # V1.1（自動更新） elif not creds or not creds.valid: flow = InstalledAppFlow.from_client_secrets_file("credentials.json", SCOPES) creds = flow.run_local_server(port=0) with open("token.json", "w") as f: f.write(creds.to_json()) return build("calendar", "v3", credentials=creds) # ====================== # Google操作 # ====================== def add_event(service, oid, e): body = { "summary": e["title"], "location": e["location"], "start": { "dateTime": e["start"], "timeZone": "Asia/Tokyo" }, "end": { "dateTime": e["end"], "timeZone": "Asia/Tokyo" }, "description": f"Outlook連携\nOID:{oid}", # "通知"を無しに設定 "reminders": { "useDefault": False } } created = service.events().insert(calendarId='primary', body=body).execute() return created["id"] def update_event(service, gid, oid, e): body = { "summary": e["title"], "location": e["location"], "start": { "dateTime": e["start"], "timeZone": "Asia/Tokyo" }, "end": { "dateTime": e["end"], "timeZone": "Asia/Tokyo" }, "description": f"Outlook連携\nOID:{oid}", # v1.2 "reminders": { "useDefault": False } } service.events().update(calendarId='primary', eventId=gid, body=body).execute() def delete_event(service, gid): service.events().delete(calendarId='primary', eventId=gid).execute() # ====================== # 状態管理 # ====================== def load_state(): if os.path.exists(STATE_FILE): with open(STATE_FILE, "r") as f: return json.load(f) return {} def save_state(state): with open(STATE_FILE, "w") as f: json.dump(state, f, indent=2) # ====================== # メイン # ====================== def main(): print("==== 同期開始 ====") prev_state = load_state() outlook_events = get_outlook_events() service = get_google_service() new_state = {} add_count = 0 update_count = 0 delete_count = 0 # ===== ① 追加・更新 ===== for oid, e in outlook_events.items(): if oid not in prev_state: gid = add_event(service, oid, e) add_count += 1 else: gid = prev_state[oid]["google_id"] if prev_state[oid]["updated"] != e["updated"]: update_event(service, gid, oid, e) update_count += 1 new_state[oid] = { "google_id": gid, "updated": e["updated"] } # ===== ② 削除検知 ===== for oid in prev_state: if oid not in outlook_events: gid = prev_state[oid]["google_id"] try: delete_event(service, gid) delete_count += 1 except: pass save_state(new_state) print(f"追加: {add_count}件") print(f"更新: {update_count}件") print(f"削除: {delete_count}件") print("==== 完了 ====") if __name__ == "__main__": main()

python sync_calendar.py

本ツール ➔ win32com ➔ COM ➔ Outlookアプリ

import win32com.client … outlook = win32com.client.Dispatch("Outlook.Application") …

本ツール ➔ Google API Client Library ➔ Google Calendar REST API

C:\sync\ ├ sync_calendar.py ├ credentials.json ← Google Calendarから取得 ├ token.json ← 自動生成 └ synced_events.json ← 自動生成