Unlock the full potential of your Jira™ data directly in Google Sheets™. This powerful add-on provides a robust, automated, and highly customizable bridge between your Jira™ projects and your spreadsheets, which can later be connected to any visualization tool of your choice - transforming raw data into actionable insights.

Whether you're a project manager, a data analyst, or a team lead, this tool gives you complete control over what data you sync and how you measure it. Move beyond simple data dumps and create sophisticated, auto-refreshing reports with advanced metrics that matter to you.

Key Features:

- Secure & Simple Connection: Connect your Jira™ account in seconds with a secure OAuth 2.0 flow. No need to manage API tokens.

- Flexible Field Mapping: Automatically discover all available fields from your project, including custom fields. Select what you need, rename columns, and even define custom field paths.

- Advanced Data Strategies: Choose between a full data refresh on each sync or use the "Append-Only Mode" to build a historical log of all issue changes over time, complete with a clean, deduplicated sheet showing the latest status of every issue.

- Powerful Time-Based Metrics:

    1. Time in Status: Automatically calculate the total time (in seconds) an issue has spent in any workflow status you choose to track.

    2. Custom Transition Times: Define your own cycle and lead time metrics. Measure the duration between any set of "from" and "to" statuses (e.g., from "In Progress" to "Done"), and exclude statuses like "On Hold" from the calculation.

- Business Hour Calculations: Make your time-based metrics truly accurate by defining a custom working calendar. Exclude weekends, holidays, and non-working hours from all time calculations.

- Detailed Changelog Tracking: For any field, you can choose to pull a complete history of its changes, including who made the change, when it was made, and the old and new values.

- Automated Sync Scheduling: Set up your syncs to run automatically on a daily, weekly, or monthly schedule using an intuitive trigger management system.

Stop wasting time with manual exports and CSV files. Install the Jira™ Data Fetcher for Google Sheets™ add-on today and start building the automated, data-driven reports you've always wanted.

Please Note:

Jira™ and Atlassian™ are trademarks of Atlassian Pty Ltd. Google™, Google Sheets™, Google Workspace™, and Google Apps Script™ are trademarks of Google LLC. This Add-on is not created by, affiliated with, or supported by Atlassian Pty Ltd or Google LLC.