Welcome to Sheet Sync

Sheet Sync is a Google Sheets and Excel addon that connects your spreadsheets to JIRA. Sync issues, create bulk tickets, build dashboards, and plan roadmaps — all from within your spreadsheet.

What is Sheet Sync?

Sheet Sync is a marketplace addon available for both Google Sheets and Microsoft Excel. It connects directly to your JIRA instance using your credentials, with no JIRA-side addon or admin installation required.

Key capabilities

• JIRA Issues — pull issues into your spreadsheet using JQL or saved filters, choose display columns, and keep data in sync.
• Bulk Create Issues — push rows from your spreadsheet to JIRA to create hundreds of issues in one click.
• JQL Update — update JIRA issues directly from your spreadsheet using enhanced JQL syntax.
• Dashboards & Metrics — built-in dashboards and metrics views for project tracking.
• Roadmap & Capacity Planning — plan sprints and capacity with spreadsheet-native tools.
• Pivot Tables — create pivot tables from JIRA data for advanced analysis.
• Label Management — manage JIRA labels across projects from your spreadsheet.
• Scheduled Sync — automated exports on your schedule — hourly, daily, or weekly.

Quick links

How it works

                              ┌──────────────────┐
                              │  Google          │────────────────────────────────────────┐
                              │  Apps Script     │                                        │
                              └──────────────────┘                                        │
                                       ▲                                                  ▼
                                       │
┌──────────────┐     ┌─────────────────┴┐     ┌────────────────┐     ┌────────────────────┐
│              │     │                  │     │                │     │                    │
│ Google Sheets│────►│  Sheet Sync      │────►│  Sheet Sync    │────►│  Your JIRA         │
│ or Excel     │◄────│  Addon           │◄────│  API           │◄────│  Instance          │
│              │     │                  │     │                │     │                    │
└──────────────┘     └──────────────────┘     └────────────────┘     └────────────────────┘

Sheet Sync connects directly to your JIRA instance using your username and API token. No JIRA administrator access is needed — simply install the addon from the Google or Microsoft Marketplace and start syncing.