AI 助手日程管理方案全对比：Google、Outlook、Notion 与本地方案

mkdir -p ~/.config/google-calendar
cp ~/Downloads/service-account.json ~/.config/google-calendar/
chmod 600 ~/.config/google-calendar/service-account.json

#!/usr/bin/env python3
"""Google Calendar 读取 - Service Account 方式"""

import os
from datetime import datetime, timedelta
from google.oauth2 import service_account
from googleapiclient.discovery import build

# Service Account 配置
SCOPES = ['https://www.googleapis.com/auth/calendar.readonly']
SERVICE_ACCOUNT_FILE = os.path.expanduser('~/.config/google-calendar/service-account.json')
CALENDAR_ID = 'primary'  # 主日历，或共享日历的 ID

def get_today_events():
    """获取今日日程"""
    if not os.path.exists(SERVICE_ACCOUNT_FILE):
        return "   ⚠️ 未配置 Service Account"
    
    try:
        creds = service_account.Credentials.from_service_account_file(
            SERVICE_ACCOUNT_FILE, scopes=SCOPES)
        service = build('calendar', 'v3', credentials=creds)
        
        # 今天的时间范围
        now = datetime.now()
        start = now.replace(hour=0, minute=0, second=0).isoformat() + '+08:00'
        end = (now + timedelta(days=1)).replace(hour=0, minute=0, second=0).isoformat() + '+08:00'
        
        events_result = service.events().list(
            calendarId=CALENDAR_ID,
            timeMin=start,
            timeMax=end,
            singleEvents=True,
            orderBy='startTime'
        ).execute()
        
        events = events_result.get('items', [])
        
        if not events:
            return "   • 暂无日程"
        
        lines = []
        for event in events:
            start = event['start'].get('dateTime', event['start'].get('date'))
            if 'T' in start:
                time_str = start[11:16]
            else:
                time_str = '全天'
            lines.append(f"   • {time_str} {event['summary']}")
        
        return '\n'.join(lines)
        
    except Exception as e:
        return f"   ⚠️ 获取失败: {str(e)[:50]}"

if __name__ == '__main__':
    print("📅 **今日日程**")
    print(get_today_events())

cp ~/Downloads/client_secret.json ~/.config/google-calendar/
chmod 600 ~/.config/google-calendar/client_secret.json

#!/usr/bin/env python3
"""Google Tasks 读取 - OAuth 方式"""

import os
import pickle
from datetime import datetime
from google_auth_oauthlib.flow import InstalledAppFlow
from google.auth.transport.requests import Request
from googleapiclient.discovery import build

# OAuth 配置
SCOPES = ['https://www.googleapis.com/auth/tasks.readonly']
CLIENT_SECRET_FILE = os.path.expanduser('~/.config/google-calendar/client_secret.json')
TOKEN_FILE = os.path.expanduser('~/.config/google-calendar/token.json')

def get_credentials():
    """获取 OAuth 凭证，首次需要浏览器授权"""
    creds = None
    
    if os.path.exists(TOKEN_FILE):
        with open(TOKEN_FILE, 'rb') as token:
            creds = pickle.load(token)
    
    if not creds or not creds.valid:
        if creds and creds.expired and creds.refresh_token:
            creds.refresh(Request())
        else:
            if not os.path.exists(CLIENT_SECRET_FILE):
                print("❌ 未找到 client_secret.json")
                return None
            
            flow = InstalledAppFlow.from_client_secrets_file(
                CLIENT_SECRET_FILE, SCOPES)
            
            # 对于无浏览器环境，使用手动授权
            auth_url, _ = flow.authorization_url(prompt='consent')
            print(f"请访问这个 URL 授权：\n{auth_url}\n")
            code = input("输入授权码：")
            flow.fetch_token(code=code)
            creds = flow.credentials
        
        # 保存 token
        os.makedirs(os.path.dirname(TOKEN_FILE), exist_ok=True)
        with open(TOKEN_FILE, 'wb') as token:
            pickle.dump(creds, token)
    
    return creds

def get_tasks():
    """获取待办任务"""
    try:
        creds = get_credentials()
        if not creds:
            return "   ⚠️ 未授权"
        
        service = build('tasks', 'v1', credentials=creds)
        
        result = service.tasks().list(
            tasklist='@default',
            showCompleted=False,
            maxResults=10
        ).execute()
        
        tasks = result.get('items', [])
        
        if not tasks:
            return "   • 暂无任务"
        
        lines = []
        today = datetime.now().strftime('%Y-%m-%d')
        
        for task in tasks:
            title = task.get('title', '无标题')
            due = task.get('due', '')
            if due:
                due_date = due[:10]
                if due_date < today:
                    prefix = "   ⚠️ 过期: "
                elif due_date == today:
                    prefix = "   📌 今天: "
                else:
                    prefix = "   • "
            else:
                prefix = "   • "
            lines.append(f"{prefix}{title}")
        
        return '\n'.join(lines)
        
    except Exception as e:
        return f"   ⚠️ 获取失败: {str(e)[:40]}"

if __name__ == '__main__':
    print("📋 **待办任务**")
    print(get_tasks())

pip3 install --user google-auth-oauthlib google-api-python-client
python3 google_tasks.py
# 会显示授权 URL，浏览器打开授权后，复制授权码粘贴

def get_schedule_section():
    """获取日程板块"""
    # 日历使用 Service Account
    from google_calendar import get_today_events
    # 任务使用 OAuth
    from google_tasks import get_tasks
    
    lines = []
    lines.append("📅 **今日日程**")
    lines.append(get_today_events())
    lines.append("")
    lines.append("📋 **待办任务**")
    lines.append(get_tasks())
    return '\n'.join(lines)

# 从 readonly 改为完整权限
SCOPES = ['https://www.googleapis.com/auth/calendar']

SCOPES = ['https://www.googleapis.com/auth/tasks']  # 去掉 .readonly

rm ~/.config/google-calendar/token.json
python3 google_tasks.py
# 重新访问授权 URL，获取新的授权码

CLIENT_ID = '你的应用程序ID'
CLIENT_SECRET = '你的客户端密码'
TENANT_ID = 'common'  # 个人账号用 'common'

# 安装依赖
pip3 install --user msal requests

#!/usr/bin/env python3
"""Microsoft Outlook/365 日程获取"""

import os
import sys
from datetime import datetime, timedelta

sys.path.insert(0, os.path.expanduser('~/.config/outlook'))

try:
    import msal
    import requests
except ImportError:
    print("请安装依赖: pip3 install --user msal requests")
    sys.exit(1)

try:
    from config import CLIENT_ID, CLIENT_SECRET, TENANT_ID
except ImportError:
    print("请创建 ~/.config/outlook/config.py 配置文件")
    sys.exit(1)

def get_token():
    """获取访问令牌"""
    authority = f"https://login.microsoftonline.com/{TENANT_ID}"
    app = msal.ConfidentialClientApplication(
        CLIENT_ID, authority=authority, client_credential=CLIENT_SECRET
    )
    
    result = app.acquire_token_for_client(scopes=["https://graph.microsoft.com/.default"])
    
    if "access_token" in result:
        return result["access_token"]
    else:
        print(f"认证失败: {result.get('error_description')}")
        return None

def get_calendar_events():
    """获取日历事件"""
    token = get_token()
    if not token:
        return "   ⚠️ 认证失败"
    
    headers = {'Authorization': f'Bearer {token}'}
    
    now = datetime.now()
    start = now.replace(hour=0, minute=0, second=0).isoformat()
    end = (now + timedelta(days=1)).replace(hour=0, minute=0, second=0).isoformat()
    
    url = "https://graph.microsoft.com/v1.0/me/calendar/calendarView"
    params = {
        'startDateTime': start,
        'endDateTime': end,
        '$select': 'subject,start,end'
    }
    
    try:
        response = requests.get(url, headers=headers, params=params)
        events = response.json().get('value', [])
        
        if not events:
            return "   • 暂无日程"
        
        lines = []
        for event in events:
            start_time = event['start']['dateTime'][:16].replace('T', ' ')
            lines.append(f"   • {start_time} {event['subject']}")
        
        return '\n'.join(lines)
        
    except Exception as e:
        return f"   ⚠️ 获取失败: {str(e)[:40]}"

if __name__ == '__main__':
    print("📅 **今日日程**")
    print(get_calendar_events())

NOTION_TOKEN = 'secret_xxx你的token'
DATABASE_ID = 'abc123你的数据库ID'
DATE_PROPERTY = '日期'
TITLE_PROPERTY = '名称'

# 安装依赖
pip3 install --user requests

#!/usr/bin/env python3
"""Notion 日程获取"""

import os
import sys
from datetime import datetime

sys.path.insert(0, os.path.expanduser('~/.config/notion'))

try:
    import requests
except ImportError:
    print("请安装依赖: pip3 install --user requests")
    sys.exit(1)

try:
    from config import NOTION_TOKEN, DATABASE_ID, DATE_PROPERTY, TITLE_PROPERTY
except ImportError:
    print("请创建 ~/.config/notion/config.py 配置文件")
    sys.exit(1)

def get_today_schedule():
    """获取今日日程"""
    headers = {
        'Authorization': f'Bearer {NOTION_TOKEN}',
        'Notion-Version': '2022-06-28',
        'Content-Type': 'application/json'
    }
    
    today = datetime.now().strftime('%Y-%m-%d')
    
    url = f"https://api.notion.com/v1/databases/{DATABASE_ID}/query"
    data = {
        "filter": {
            "property": DATE_PROPERTY,
            "date": {"equals": today}
        },
        "sorts": [{"property": DATE_PROPERTY, "direction": "ascending"}]
    }
    
    try:
        response = requests.post(url, headers=headers, json=data)
        results = response.json().get('results', [])
        
        if not results:
            return "   • 暂无日程"
        
        lines = []
        for item in results:
            props = item['properties']
            title = props[TITLE_PROPERTY]['title'][0]['text']['content'] if props[TITLE_PROPERTY]['title'] else '无标题'
            lines.append(f"   • {title}")
        
        return '\n'.join(lines)
        
    except Exception as e:
        return f"   ⚠️ 获取失败: {str(e)[:40]}"

if __name__ == '__main__':
    print("📅 **今日日程**")
    print(get_today_schedule())

# 日程管理

## 2026-03-10
- [ ] 09:00 晨会
- [ ] 14:00 项目评审
- [ ] 20:00 健身

## 2026-03-11
- [ ] 10:00 客户电话

#!/usr/bin/env python3
"""本地 Markdown 日程读取"""

import os
import re
from datetime import datetime

def get_schedule():
    schedule_file = os.path.expanduser('~/.openclaw/schedule.md')
    
    if not os.path.exists(schedule_file):
        return "   • 未创建日程文件"
    
    today = datetime.now().strftime('%Y-%m-%d')
    
    with open(schedule_file, 'r', encoding='utf-8') as f:
        content = f.read()
    
    # 查找今天的日程
    pattern = rf'## {today}\n(.*?)(?=\n## |\Z)'
    match = re.search(pattern, content, re.DOTALL)
    
    if not match:
        return "   • 暂无今日日程"
    
    tasks = match.group(1).strip()
    lines = [line.strip() for line in tasks.split('\n') if line.strip()]
    
    return '\n'.join(lines) if lines else "   • 暂无日程"

if __name__ == '__main__':
    print("📅 **今日日程**")
    print(get_schedule())