メニュー
DEPRECATED — superseded by gmail-extract-and-act. Extract emails from Gmail to /mnt/ace/<repo>/, archive to repos, commit, then delete. Uses archive-everything model.
デフォルトでは、最初にソースを確認する Prompt が選択されています。直接コマンドに切り替えるか、ローカルコピーをダウンロードすることもできます。
インストールを決める前に、SKILL.md と SkillsMP に表示されている付属ファイルをお読みください。
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
直接コマンドでは確認用 Prompt が省略されます。実行前にソースを確認してください。
npx skills add https://github.com/vamseeachanta/workspace-hub --skill gmail-extract-and-cleanコマンドは1行のまま表示されます。コピー前に横へスクロールして全体を確認してください。
ローカルで確認しますか？SkillsMP が現在取得できるファイルをダウンロードできます。
SKILL.md を表示中
SOC 職業分類に基づく
| name | gmail-extract-and-clean |
| description | DEPRECATED — superseded by gmail-extract-and-act. Extract emails from Gmail to /mnt/ace/<repo>/, archive to repos, commit, then delete. Uses archive-everything model. |
| version | 2.0.0 |
| status | deprecated |
| superseded_by | gmail-extract-and-act |
| deprecation_reason | Archives raw email bodies to repos. Per #2017, the new model extracts only structured data and deletes emails when topics complete (queue model, not archive model). See #2019 for consolidation plan. |
| author | vamsee |
| tags | ["email","gmail","extraction","cleanup","archive","routing","DEPRECATED"] |
| related_skills | ["gmail-multi-account","contact-manager","gmail-extract-and-act"] |
| metadata | {"hermes":{"tags":["email","gmail","extraction","cleanup"]}} |
Extract emails from Gmail into the correct /mnt/ace/<repo>/doc/email/ location, commit to the workspace-hub external repo, then optionally delete from Gmail inbox.
Gmail Inbox (3 accounts: ace, personal, skestates)
↓ extract + classify + route
/mnt/ace/<repo>/docs/email/ ← data lands here
↓ (samba share — no git here)
/mnt/local-analysis/workspace-hub/<repo>/ ← git lives here
↓ commit + push
Gmail message deleted from inbox
The /mnt/ace/ directory contains samba share copies of external_dir repos. These have NO .git directories. The actual git repos live at /mnt/local-analysis/workspace-hub/<repo>/ (which includes <repo> as a subdirectory).
Critical: Always commit via the workspace-hub path, not /mnt/ace/ path.
Email routing is defined in scripts/email/email-routing.yaml (workspace-hub repo):
rules:
"familydollar.com" → "sabithaandkrishnaestates/docs/email/tenant"
"sandsig.com" → "assethold/data/sandsig-cre-listings/email"
"github.com" → "achantas-data/docs/email/dev-notifications"
"collide.io" → DELETE # spam — just delete, don't archive
"indianstarllc.ccsend.com" → REVIEW # needs manual review
"default" → "achantas-data/docs/email/other"
Actions: <repo/path> = archive to that repo, DELETE = remove without archiving, REVIEW = flag for manual review.
cd /mnt/local-analysis/workspace-hub
uv run scripts/email/gmail-archive-extract.py --account ace --query --max 500 --delete --no-sheets
uv run scripts/email/gmail-archive-extract.py --account personal --query "from:promote.weebly.com" --max 100 --dry-run
uv run scripts/email/gmail-archive-extract.py --account ace --query "from:lng-agroup.com" --max 100
# The script writes to /mnt/ace/<repo>/ — sync to git repos:
cd /mnt/local-analysis/workspace-hub/assethold
rsync -a /mnt/ace/assethold/data/ data/
count=$(ls data/sandsig-cre-listings/email/*.md 2>/dev/null | wc -l)
git add -f data/
git commit -m "extract: ace email — $count messages archived, deleted from inbox"
git push origin main
OAuth access tokens expire every ~1 hour. The extraction script refreshes tokens on every run using the refresh_token stored at ~/.gmail-{account}/credentials.json. Client ID/secret loaded from ~/.gmail-mcp/oauth-env.json.
The script sleeps 0.15s per message. Batch processing 500 messages takes ~80-170 seconds. For large cleanup, run in batches of 100-200.
Before extracting, ensure contact CSVs are normalized:
aceengineer-admin/admin/contacts/aceengineer_normalized.csv (1,281 contacts)aceengineer-admin/admin/contacts/achantav_normalized.csv (994 contacts)sabithaandkrishnaestates/admin/contacts/skestates_contacts.csv (25 contacts)Use contact-manager skill for normalization.
Each account has different cleanup priorities:
Some domains are pure spam — safe to delete without extracting:
If emails have .xlsx attachments, the script parses them to CSV automatically:
openpyxl installed (uv pip install --system openpyxl)<repo>/spreadsheets/--no-sheets flag to skip for speed/mnt/ace/<repo>/ has no .git — always commit via /mnt/local-analysis/workspace-hub/<repo>//mnt/ace/ but you must rsync to workspace-hub for git tracking