القائمة
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.
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
Conventions for creating consistent Mermaid diagrams including decision node layout, edge ordering, and flowchart direction rules.
Generate interactive validation reports with quality scoring, missing data analysis, and type checking. Combines Pandas validation, Plotly visualization, and YAML configuration for comprehensive data quality reporting.
Class-level Hermes local configuration and setup workflows, including config audit gotchas and Windows installation.
Guide AI model selection based on task complexity, cost constraints, and latency requirements
Sub-skill of modular-architecture-documentation: 1. Module Definition Framework (+9).
Sub-skill of modular-architecture-documentation: Overview (+6).
| 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 "from:sandsig.com" --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