Google Workspace CLI Setup + Daily Logging Routine

🧠 Summary

Set up Google Workspace CLI (gog) for managing Gmail, Calendar, Drive, and more. Established consistent daily logging routine with D1 task tracking.

🛠 Highlights

• 🔧 Set up Google Workspace CLI (gog) for automation:
  • Created OAuth credentials in Google Cloud Console
  • Saved credentials to ~/.config/gog/client_secret.json
  • Installed gog CLI v0.8.0 via ClawdHub
  • Enabled services: Gmail, Calendar, Drive, Contacts, Sheets, Docs
• 📝 Established dual tracking system:
  • Active tasks in D1 (crab-todo.sheraj.org) for real-time monitoring
  • Daily logs in memory/YYYY-MM-DD.md for reflections
• ✅ Added 5 tasks to D1 task manager for tracking

🔍 Notes

gog CLI Capabilities:

gog gmail search 'newer_than:7d'     # Search emails
gog calendar events primary          # List calendar events
gog sheets get <sheetId> "Tab!A1"    # Read Sheets data
gog docs cat <docId>                 # Read Docs

Setup Complete (awaiting OAuth browser authorization):

• Account: saj.c[email protected]
• Services: Gmail, Calendar, Drive, Contacts, Sheets, Docs

Daily Logging Routine:

• Every evening → Create/update memory/YYYY-MM-DD.md
• Include: tasks completed, key decisions, pending items, tomorrow's tasks
• Cross-reference with D1 for active task status

Live URL: https://crab-todo.sheraj.org (task tracking)

About the Author Sheraj Hussein – Tech & automation enthusiast. Tags: Google Workspace, gog, automation, workflow