Bitacora Updater · Automation 2026
Auto-syncs Jira hours to Google Sheets.
- Role
- Founder, Engineer
- Timeline
- May 2026
- Type
- Automation
- Stack
- Python
- Jira REST API
- Google Sheets API
- Bash
- Links
Overview
Auto-syncs Jira hours to Google Sheets.
Automatically imports Jira worklogs into a Google Sheets, eliminating 30+ min/week of manual time-tracking for my weekly worklog.
What I did
The work
Fetches worklogs via Jira REST API with precise date filtering, then writes hours directly into the correct week/day cells in the sheet.
CLI flags for specific weeks, row preallocation, and future date planning: --week, --add-rows, --ensure-through.
Shell wrapper with cron-compatible Python path so it runs reliably from scheduled jobs without loading the interactive shell.
Dotfiles alias bitacora-update wired in, so it runs from anywhere.