Log Jira worklogs nightly from Google Sheets with Gmail and GPT-4o-mini

Jira Daily Worklog Automation — Auto-log Time from Google Sheets to Jira Every Night

Automatically logs time to Jira every night from a Google Sheet. No manual worklog entries needed — just fill in your sheet and the workflow handles the rest at 10 PM.

Built for developers and teams who track their daily tasks in a spreadsheet and want their Jira time entries done automatically, with a clean email report.

---

How It Works

- Runs every night at 10 PM via a Schedule Trigger - Reads all rows from your Google Sheet and filters rows where status = Pending and date <= today - Loops through each pending row one at a time using splitInBatches - Builds the Jira worklog payload — normalises time format, constructs the ISO timestamp from date + startedat - Calls the Jira REST API (POST /rest/api/3/issue/ticketid/worklog) with Basic Auth - Updates the sheet row status to Completed or keeps it Pending with an error message and incremented retrycount - After all rows are processed, reads results from static data and builds a summary - GPT-4o-mini writes a friendly 2–3 sentence team update - Sends a formatted HTML email report via Gmail with success count, fail count, total time logged, and the AI summary

---

How to Use