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.