Bitacora Updater

Auto-syncs Jira hours to Google Sheets.

TimelineMay 2026

TypeAutomation

tech stack

PythonJira REST APIGoogle Sheets APIBash

what i did

Automatically imports Jira worklogs into a Google Sheets, eliminating 30+ min/week of manual time-tracking for my internship's worklog.
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.