Skip to content

Releases: Nitish36/Issue-Tracker-Jira

v1.0 – Automated Jira Issue Tracker

13 May 08:59
@Nitish36 Nitish36
v1.0
d6756cb
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Choose a tag to compare

View all tags
v1.0 – Automated Jira Issue Tracker Latest
Latest

Initial stable release of the Jira Issue Tracker project. This version automates the process of tracking IT issues via Jira, integrating with Google Sheets and Smartsheet to enable reporting and dashboarding.

✨ Key Features:

  • Automatically fetches new Jira issues or updates to existing ones.
  • Pushes data to Google Sheets using Python and GitHub Actions.
  • Triggers daily at 9:00 AM IST or on issue creation/update.
  • Seamlessly integrates Google Sheets with Smartsheet via Data Shuttle.
  • Control Center in Smartsheet auto-generates project sheets based on new issues.
  • Real-time Rollup and Dashboard updates based on sheet entries.

📊 Dashboards include:

  • Issue status breakdown
  • Open vs. Closed count
  • Priority-wise filtering
  • SLA tracking & resolution duration

🔐 Secrets used:

  • JIRA_SECRET – API Key for Jira
  • GSHEET_SECRET – API Key for Google Sheets

🔗 Blog post: Medium Article

📂 GitHub Workflow:

  • main.py contains the core Python script.
  • .github/workflows/issue_tracker.yml handles automation via GitHub Actions.
Assets 2
Loading