⚡ TaskVault & Team Dashboard for Google Sheets™

Automate your Task & Note Archiving, Backup your Google Keep™ Reminders, and Track Projects with an Executive Command Center in Google Sheets™!

Most to-do tools treat tasks as temporary scratchpads without permanent revision history or easy CSV exports. TaskVault turns Google Sheets™ into an automated, zero-data-loss archive vault and visual project dashboard powered directly by your Google Tasks™ and Google Keep™ ecosystem.


🌟 KEY FEATURES & HIGHLIGHTS

🛡️ 1. Zero Data Loss Backup Vault (Recycle Bin)

• Takes automatic differential snapshots of all your Google Tasks™ lists.
• Even if a task or note is completed or deleted in Google Tasks™ / Google Keep™, TaskVault safely retains it in your spreadsheet marked as "Archived".
• Never lose critical project notes, completion timestamps, or history again.

📌 2. Native Google Keep™ Reminders Sync

• Set a reminder (date/time) on any note in Google Keep™—Google automatically routes it to Google Tasks™ with a direct link back to your Keep™ note.
• TaskVault automatically captures the note, extracts the Keep™ URL, parses tags and assignees, and archives it straight into your spreadsheet.

📊 3. Executive Dashboard & Visual Command Center

• Real-Time KPI Bar: View total tasks in vault, pending items, overdue alerts, completed count, and completion rate % at a glance.
• Inline Sparkline Progress: Embedded dynamic progress bars track completion rates visually without script lag.
• Compact Project Breakdown: Clean summary tables showing open items, completed count, and completion rate per task list.

🎯 4. Interactive Focus View (Cell B13 Dropdown Filter)

• Instantly filter your dashboard view without modifying spreadsheet formulas:
  - ⚠️ Overdue Only
  - ⏳ Pending (All)
  - 🚨 Due Next 48 Hours
  - ✅ Completed
  - 📋 All Tasks
• Dynamic soft color-coded row highlighting for fast scanning.

🏷️ 5. Smart Tag & Assignee Parser

• Add #hashtags (e.g., #marketing, #sprint2) and @mentions (e.g., @alex, @sarah) anywhere in your Keep™ notes or Task titles.
• TaskVault automatically parses and organizes them into dedicated "Tags" and "Assignee" columns for easy filtering and pivot table reporting.

⏰ 6. Hands-Free 15-Minute Background Auto-Sync
• Enable the built-in time-driven trigger to keep your spreadsheet synced automatically in the background every 15 minutes.

📅 7. Historical Backlog Import
• Choose your starting baseline in history (1 Year Ago, 6 Months, Jan 1 2024, or All History) to import your entire backlog of existing tasks, Google Keep™ reminders, and Google Calendar™ events on day one.


💳 FREE TRIAL & LICENSING

• 🎁 3-Day Full Free Trial: All features (including 15-minute background auto-syncs, historical backlog imports, and smart tag parsing) are fully active for 3 days upon installation—no credit card required!
• 🔑 Simple License Key Activation: After your 3-day trial, purchase a license key to continue running automated syncs. Activate your license key in seconds via TaskVault > ⚙️ Open Sidebar.
• 🔒 Always Free Data Access: Even if your trial or license expires, viewing, filtering, and reading your existing archived tasks and dashboard data remains 100% free forever—you never lose access to your data.


🚀 QUICK START GUIDE

1. Open your Google Sheets™ spreadsheet.
2. Click Extensions > TaskVault > ⚙️ Open Sidebar.
3. Click "🚀 Initial Setup" to select your historical starting date and import your tasks.
4. Toggle ON the "Auto-Sync Trigger" to keep your sheet updated automatically every 15 minutes!



🔒 PRIVACY & SECURITY

• Direct Google-to-Google Sync: All data stays safely inside your Google Workspace™ account.
• No Third-Party Servers: TaskVault runs entirely within your Google Apps Script™ environment.
• Read/Write Access: Used strictly to fetch your Google Tasks™, Google Calendar™ reminders, and format your spreadsheet tabs.



💡 WHO IS TASKVAULT FOR?

• Executive Managers & Project Leads who need executive status visibility across multiple Google Tasks™ lists.
• Teams using Google Keep™ & Tasks™ for daily to-dos who want an immutable audit trail and historical backup.
• Power Users looking to analyze task velocity, team workloads, and task completion metrics using Google Sheets™ formulas.