Skip to content
← Projects

ServiceLive2026.05.04 ~

jira-weekly-mail

Gemini sums up the Jira issues you worked on this week and sends them as a weekly report email.

About

A Google Apps Script generator I built to automate the weekly chore of turning Jira issues into a status report email.
Enter your name, team, and Jira details to generate two script files in the browser, paste them into Apps Script, and an HTML report goes out every week with no server.

Features

  • Automatic issue collectionPulls this week's assigned issues with JQL and sorts them into done, in progress, and planned.
  • Gemini work summarySummarizes the week's work, and the email still goes out if the summary fails.
  • Email without a serverSends HTML email through Apps Script's MailApp, with no separate server.
  • Generated in the browserEverything you enter is processed only in the browser and isn't stored on a server.
  • Report previewSee what the email will look like before you generate the script.
  • Test send and triggerSend a test to yourself first, then let a trigger run it automatically every Friday.

Tech stack

  • React
  • TypeScript
  • Vite
  • Tailwind CSS
  • Google Apps Script