zenith-finance-gsheets-sync
Installation
SKILL.md
Zenith Finance → Google Sheets Sync
Automatically syncs Zenith Finance data (Ledger.md and Transactions.md) to a Google Spreadsheet for dashboard visualization and historical tracking.
Trigger
- User mentions "sync zenith to sheets", "google sheets zenith", "export finance to sheets"
- After any Zenith Finance transaction update (can be called automatically)
- Manual sync request
Prerequisites\n1. Google Workspace OAuth setup completed (google-workspace skill authenticated) with scope including https://www.googleapis.com/auth/drive\n2. Google Sheets API and Google Drive API enabled in Google Cloud project\n3. Zenith Finance data files exist:\n - ~/Documents/Obsidian/Notes/Finance/Ledger.md\n - ~/Documents/Obsidian/Notes/Finance/Transactions.md\n4. Optional but recommended: Download a copy of the Google Sheet for manual verification if needed (as user did with /Users/adityahimawan/Downloads/Zenith Finance Dashboard (4).xlsx)\n
Storage
- Spreadsheet ID stored at:
~/.hermes/zenith_spreadsheet_id.txt - If no ID exists, creates new spreadsheet named "Zenith Finance Dashboard"