# DocuTrack HR

> DocuTrack HR is an enterprise Google Sheets™ add-on that automates employee visa, passport, work permit, teacher license, and 90-day report expiration tracking with zero external database storage and automated Gmail notifications.

DocuTrack HR transforms standard Google Sheets into automated compliance management systems for international schools, universities, embassies, multinational corporations, and non-profits. It operates entirely on-device via Google Apps Script within the user's Google Workspace domain.

## Key Capabilities & Features
- [Automated Daily Expiry Sweeps](https://docutrackhr.sethideclercq.com/#features): Automatically scans document expiration dates every morning at 8:00 AM, calculating days remaining and updating live color-coded status badges (VALID, APPROACHING, URGENT, EXPIRED).
- [Configurable Milestone Alerts](https://docutrackhr.sethideclercq.com/#workspace): Custom notification triggers at 90, 60, 30, and 7 days prior to document expiration.
- [Executive Monday HR Digest](https://docutrackhr.sethideclercq.com/#simulator): Generates an automated, executive summary email every Monday at 8:00 AM consolidating expiring documents across all tracked sheets.
- [Zero External Database Privacy Architecture](https://docutrackhr.sethideclercq.com/privacy): 100% Google Drive & Google Apps Script execution. Employee PII, names, email addresses, and expiration dates never touch third-party servers.
- [Batch Processing Engine](https://docutrackhr.sethideclercq.com/support): Large roster continuation queue capable of processing 500+ employee records within Google Apps Script runtime constraints.
- [White-Label Gmail Notifications](https://docutrackhr.sethideclercq.com/#simulator): Dispatches personalized HTML notifications directly from the organization's verified Gmail account, customizable with institution logos and custom sign-offs.

## Pricing & Tiers
- [Lite Edition ($0 Forever Free)](https://workspace.google.com/marketplace/app/docutrack_hr/254037023018): 1 tracked spreadsheet, core document tracking (Visa, 90-Day, Passport, Teacher License), automated 8:00 AM daily checks, weekly Monday digest, and 60-day audit log.
- [Professional (PRO) Annual License ($49/year)](https://buy.stripe.com/eVqdR8dtxavN48VcuP5gc01): Best value (save 20%, approx. $4.08/mo). Unlimited tracked sheets, unlimited custom document categories, sub-second reactive live sync, white-label email customization, priority background batch processing, and multi-language support.
- [Professional (PRO) Monthly License ($4.99/month)](https://buy.stripe.com/bJe5kCahlavNbBn3Yj5gc00): Flexible month-to-month PRO subscription with identical feature set. Cancel anytime.

## Documentation & Guides
- [Onboarding & Setup Masterclass](https://docutrackhr.sethideclercq.com/onboarding): Detailed column mapping instructions, designating blank status columns, and configuring email triggers.
- [Support & Knowledge Base](https://docutrackhr.sethideclercq.com/support): Troubleshooting guide, Google quota limits, large roster batch processing, and Google Sheets filter behavior.
- [Privacy Policy & Data Protection](https://docutrackhr.sethideclercq.com/privacy): Full disclosure of OAuth permissions (`spreadsheets.currentonly`, `send_mail`, `scriptapp`), Google API Limited Use compliance, and instant cloud license erasure.
- [Terms of Service](https://docutrackhr.sethideclercq.com/terms): Software licensing terms, 14-day refund policy, and intellectual property notice.
- [Google Workspace Marketplace Listing](https://workspace.google.com/marketplace/app/docutrack_hr/254037023018): Official Google-verified marketplace listing for individual or domain-wide administrative installation.

## Extended Knowledge Base
- [Full LLM Knowledge Document](https://docutrackhr.sethideclercq.com/llms-full.txt): Comprehensive technical specifications, edge-case answers, and prompt context for AI search agents and retrieval engines.