Google Workspace API 自动化脚本 - 集成 Drive、Gmail、Calendar 和 Docs

google-workspace by casper-studios/casper-marketplace

139 周安装量

10 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/casper-studios/casper-marketplace --skill google-workspace

办公软件自动化 API

🇨🇳中文介绍

Google Workspace

概述

使用 OAuth 身份验证与 Google Drive、Gmail、Calendar 和 Docs 进行交互。支持文件上传、文件夹管理、邮件搜索、日历搜索和文档操作。

快速决策树

What do you need?
│
├── Google Drive
│   ├── Search files/folders → references/drive-search.md
│   │   └── Script: scripts/gdrive_search.py
│   │
│   ├── Upload files → references/drive-upload.md
│   │   └── Script: scripts/google_drive_upload.py
│   │
│   ├── Create folder structure → references/folder-structure.md
│   │   └── Script: scripts/gdrive_folder_structure.py
│   │
│   ├── Create client folder → references/create-folder.md
│   │   └── Script: scripts/create_client_folder.py
│   │
│   └── Search transcripts → references/transcript-search.md
│       └── Script: scripts/gdrive_transcript_search.py
│
├── Gmail
│   └── Search emails → references/gmail-search.md
│       └── Script: scripts/gmail_search.py
│
└── Calendar
    └── Search meetings → references/calendar-search.md
        └── Script: scripts/google_calendar_search.py

环境设置

首次身份验证后，OAuth 凭据将存储在本地。

必需文件

client_secrets.json - 来自 Google Cloud Console

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

搜索客户文件夹

python scripts/gdrive_search.py folder "Microsoft"

python scripts/google_drive_upload.py --files *.png --folder "Clients/Acme/Assets"

python scripts/gmail_search.py --domain "microsoft.com" --days 14

python scripts/google_calendar_search.py "Microsoft" --days-back 30

权限范围	用途
`drive`	完全访问 Drive
`spreadsheets`	访问 Sheets
`documents`	访问 Docs
`gmail.readonly`	读取邮件
`calendar.readonly`	读取日历

免费 - Google Workspace API 提供慷慨的免费配额。

client_secrets.json - OAuth 应用凭据（切勿提交到 git）
mycreds.txt - 用户 OAuth 令牌（切勿提交到 git，添加到 .gitignore）
settings.yaml - PyDrive2 配置（可以提交，不含机密信息）
令牌自动刷新；如果泄露，请通过 Google 账户设置撤销
切勿在用户/机器之间共享 OAuth 凭据

可访问用户的个人 Google Drive、Gmail 和 Calendar
文件可能包含机密业务信息
邮件内容高度敏感 - 尽量减少存储
日历事件可能包含私人会议详情
共享 Drive 的访问遵循原始权限设置

请求所需的最小权限范围：
- drive - 完全访问 Drive（读/写）
- drive.readonly - 只读访问 Drive（尽可能首选）
- spreadsheets - 访问 Google Sheets
- documents - 访问 Google Docs
- gmail.readonly - 只读访问邮件
- calendar.readonly - 只读访问日历
查看/撤销访问权限：https://myaccount.google.com/permissions

OAuth 授权：用户明确授权访问权限范围
GDPR：Google Workspace 数据包含欧盟用户的个人身份信息
数据驻留：Google Workspace 可能有数据驻留要求
共享 Drive：遵守组织的共享策略
审计跟踪：Google Admin Console 跟踪 API 访问
凭据安全：安全存储 client_secrets.json，不要放在代码仓库中

问题：OAuth 令牌已过期

症状： 出现“无效凭据”或“令牌已过期或已被撤销”错误 原因： OAuth 刷新令牌已过期或已被撤销 解决方案：

删除 mycreds.txt 文件
重新运行任意脚本以触发新的 OAuth 流程
在浏览器中完成授权
新的 mycreds.txt 将自动创建

问题：文件未找到

症状： 使用有效的文件 ID 时出现“文件未找到”错误 原因： 无权访问文件、文件已删除或文件 ID 错误 解决方案：

从 Google Drive URL 验证文件 ID
检查文件共享权限
确保 OAuth 用户有权访问该文件
首先尝试直接在浏览器中访问文件

问题：配额超限

症状： 出现“用户速率限制超限”或“配额超限”错误 原因： 24 小时内 API 请求过多 解决方案：

等待 24 小时配额重置
创建一个具有新配额的新 Google Cloud 项目
在脚本中实现指数退避
减少 API 调用频率

问题：settings.yaml 缺失

症状： 出现“settings.yaml 未找到”或 PyDrive2 配置错误 原因： 缺少 PyDrive2 配置文件 解决方案：

从模板复制：cp settings.yaml.example settings.yaml
确保 settings 中 client_secrets.json 的路径正确
验证 save_credentials_backend 设置为 "file"
检查 settings.yaml 是否在脚本的工作目录中

问题：client_secrets.json 无效

症状： 出现“无效的客户端密钥”或 OAuth 配置错误 原因： OAuth 凭据文件格式错误或不正确 解决方案：

从 Google Cloud Console 重新下载
确保创建凭据时选择了“桌面应用”类型
检查 JSON 格式是否有效
验证是否为本地身份验证配置了重定向 URI

问题：权限范围访问被拒绝

症状： 出现“权限不足”错误 原因： OAuth 授权缺少所需的权限范围 解决方案：

删除 mycreds.txt 以重置 OAuth 会话
重新进行身份验证并接受所有请求的权限范围
验证 settings.yaml 中的权限范围与脚本要求匹配
检查 Google Cloud Console 中的权限范围限制

references/drive-search.md - 搜索文件和文件夹
references/drive-upload.md - 上传文件到 Drive
references/folder-structure.md - 创建文件夹层级结构
references/create-folder.md - 创建客户文件夹
references/transcript-search.md - 搜索转录文件
references/gmail-search.md - 搜索 Gmail
references/calendar-search.md - 搜索日历会议

Drive 到视频制作

技能： google-workspace → video-production 使用场景： 从 Drive 文件夹组装课程视频 流程：

在 Drive 中搜索包含课程文件的视频文件夹
通过 video-production 脚本下载视频
将视频与标题幻灯片拼接并上传最终输出

技能： google-workspace → content-generation 使用场景： 从品牌模板生成文档 流程：

从 Drive 加载模板（提案、报告格式）
通过 content-generation 生成内容
创建包含格式化内容的新 Google 文档

技能： google-workspace → transcript-search 使用场景： 从日历事件中查找会议录音 流程：

在日历中搜索与特定客户的会议
获取会议日期和标题
在 transcript-search 中搜索匹配的录音

🇺🇸English

Google Workspace

Overview

Interact with Google Drive, Gmail, Calendar, and Docs using OAuth authentication. Supports file uploads, folder management, email search, calendar search, and document operations.

Quick Decision Tree

What do you need?
│
├── Google Drive
│   ├── Search files/folders → references/drive-search.md
│   │   └── Script: scripts/gdrive_search.py
│   │
│   ├── Upload files → references/drive-upload.md
│   │   └── Script: scripts/google_drive_upload.py
│   │
│   ├── Create folder structure → references/folder-structure.md
│   │   └── Script: scripts/gdrive_folder_structure.py
│   │
│   ├── Create client folder → references/create-folder.md
│   │   └── Script: scripts/create_client_folder.py
│   │
│   └── Search transcripts → references/transcript-search.md
│       └── Script: scripts/gdrive_transcript_search.py
│
├── Gmail
│   └── Search emails → references/gmail-search.md
│       └── Script: scripts/gmail_search.py
│
└── Calendar
    └── Search meetings → references/calendar-search.md
        └── Script: scripts/google_calendar_search.py

Environment Setup

OAuth credentials are stored locally after first authentication.

Required Files

client_secrets.json - From Google Cloud Console
settings.yaml - PyDrive2 configuration
mycreds.txt - Auto-generated OAuth tokens

First-Time Setup

Go to Google Cloud Console
Enable APIs: Drive, Gmail, Calendar, Docs
Create OAuth 2.0 credentials (Desktop app)
Download as client_secrets.json
Run any script - browser opens for OAuth consent

Common Usage

Search Client Folder

python scripts/gdrive_search.py folder "Microsoft"

Upload Files

python scripts/google_drive_upload.py --files *.png --folder "Clients/Acme/Assets"

Search Emails

python scripts/gmail_search.py --domain "microsoft.com" --days 14

Search Calendar

python scripts/google_calendar_search.py "Microsoft" --days-back 30

OAuth Scopes

Scope	Purpose
`drive`	Full Drive access
`spreadsheets`	Sheets access
`documents`	Docs access
`gmail.readonly`	Read emails
`calendar.readonly`	Read calendar

Cost

Free - Google Workspace APIs have generous free quotas.

Security Notes

Credential Handling

client_secrets.json - OAuth app credentials (never commit to git)
mycreds.txt - User OAuth tokens (never commit to git, add to .gitignore)
settings.yaml - PyDrive2 config (can be committed, no secrets)
Tokens auto-refresh; revoke via Google Account settings if compromised
Never share OAuth credentials between users/machines

Data Privacy

Access to user's personal Google Drive, Gmail, and Calendar
Files may contain confidential business information
Email content is highly sensitive - minimize storage
Calendar events may contain private meeting details
Shared Drive access respects original permissions

Access Scopes

Request minimum required scopes:
- drive - Full Drive access (read/write)
- drive.readonly - Read-only Drive access (preferred when possible)
- spreadsheets - Google Sheets access
- documents - Google Docs access
- gmail.readonly - Read-only email access
- calendar.readonly - Read-only calendar access
Review/revoke access: https://myaccount.google.com/permissions

Compliance Considerations

OAuth Consent : Users explicitly consent to access scopes
GDPR : Google Workspace data contains EU user PII
Data Residency : Google Workspace may have data residency requirements
Shared Drives : Respect organizational sharing policies
Audit Trail : Google Admin Console tracks API access
Credential Security : Store client_secrets.json securely, not in repos

Troubleshooting

Common Issues

Issue: OAuth token expired

Symptoms: "Invalid credentials" or "Token has been expired or revoked" error Cause: OAuth refresh token expired or revoked Solution:

Delete mycreds.txt file
Re-run any script to trigger fresh OAuth flow
Complete the browser authorization
New mycreds.txt will be created automatically

Issue: File not found

Symptoms: "File not found" error with valid file ID Cause: No access to file, file deleted, or wrong file ID Solution:

Verify file ID from the Google Drive URL
Check file sharing permissions
Ensure OAuth user has access to the file
Try accessing file directly in browser first

Issue: Quota exceeded

Symptoms: "User rate limit exceeded" or "Quota exceeded" error Cause: Too many API requests in 24-hour period Solution:

Wait 24 hours for quota reset
Create a new Google Cloud project with fresh quota
Implement exponential backoff in scripts
Reduce frequency of API calls

Issue: settings.yaml missing

Symptoms: "settings.yaml not found" or PyDrive2 configuration error Cause: Missing PyDrive2 configuration file Solution:

Copy from template: cp settings.yaml.example settings.yaml
Ensure client_secrets.json path is correct in settings
Verify save_credentials_backend is set to "file"
Check settings.yaml is in the script's working directory

Issue: client_secrets.json invalid

Symptoms: "Invalid client secrets" or OAuth configuration error Cause: Malformed or incorrect OAuth credentials file Solution:

Re-download from Google Cloud Console
Ensure "Desktop app" type was selected when creating credentials
Check JSON format is valid
Verify redirect URIs are configured for local auth

Issue: Scope access denied

Symptoms: "Insufficient permission" error Cause: OAuth consent missing required scopes Solution:

Delete mycreds.txt to reset OAuth session
Re-authenticate and accept all requested scopes
Verify scopes in settings.yaml match script requirements
Check Google Cloud Console for scope restrictions

Resources

references/drive-search.md - Search files and folders
references/drive-upload.md - Upload files to Drive
references/folder-structure.md - Create folder hierarchies
references/create-folder.md - Create client folders
references/transcript-search.md - Search transcript files
references/gmail-search.md - Search Gmail
references/calendar-search.md - Search calendar meetings

Integration Patterns

Drive to Video Production

Skills: google-workspace → video-production Use case: Assemble course videos from Drive folder Flow:

Search Drive for video folder with lesson files
Download videos via video-production scripts
Stitch videos with title slides and upload final output

Templates to Content

Skills: google-workspace → content-generation Use case: Generate documents from branded templates Flow:

Load template from Drive (proposal, report format)
Generate content via content-generation
Create new Google Doc with formatted content

Calendar to Transcripts

Skills: google-workspace → transcript-search Use case: Find meeting recordings from calendar events Flow:

Search calendar for meetings with specific client
Get meeting dates and titles
Search transcript-search for matching recordings

Weekly Installs

103

Repository

casper-studios/…ketplace

GitHub Stars

First Seen

Feb 24, 2026

Security Audits

Gen Agent Trust HubPass SocketFail SnykWarn

Installed on

cline103

github-copilot103

codex103

kimi-cli103

gemini-cli103

cursor103

通过 LiteLLM 代理让 Claude Code 对接 GitHub Copilot 运行 | 高级变通方案指南

36,300 周安装

Google Workspace API 自动化脚本 - 集成 Drive、Gmail、Calendar 和 Docs

🇨🇳中文介绍

Google Workspace

概述

快速决策树

环境设置

必需文件

相关 Skills

首次设置

常用用法

搜索客户文件夹

上传文件

搜索邮件

搜索日历

OAuth 权限范围

成本

安全注意事项

凭据处理

数据隐私

访问权限范围

合规性考虑

故障排除

常见问题

问题：OAuth 令牌已过期

问题：文件未找到

问题：配额超限

问题：settings.yaml 缺失

问题：client_secrets.json 无效

问题：权限范围访问被拒绝

资源

集成模式

Drive 到视频制作

模板到内容

日历到转录

🇺🇸English

Google Workspace

Overview

Quick Decision Tree

Environment Setup

Required Files

First-Time Setup

Common Usage

Search Client Folder

Upload Files

Search Emails

Search Calendar

OAuth Scopes

Cost

Security Notes

Credential Handling

Data Privacy

Access Scopes

Compliance Considerations

Troubleshooting

Common Issues

Issue: OAuth token expired

Issue: File not found

Issue: Quota exceeded

Issue: settings.yaml missing

Issue: client_secrets.json invalid

Issue: Scope access denied

Resources

Integration Patterns

Drive to Video Production

Templates to Content

Calendar to Transcripts

最新 Skills