Start free
Per-pair page

Google Sheets + Jira: bulk-import and reporting.

Sync Jira issues into Sheets for reporting and DORA metrics, or bulk-import Sheet rows as Jira issues. Useful for engineering analytics and migration workflows.

Connect Jira to Google Sheets — start free See reverse direction
Trigger app
Jira as the trigger

Workflows fire when something happens in Jira.

See all 6 triggers →
Action app
Google Sheets as the action

Workflows do something in Google Sheets, instantly.

See all 9 actions →
Connect Jira to Google Sheets — start free
Both directions

Pick the way that fits your stack.

Pair pages are mirrored. Each direction gets its own dedicated page.

Jira → Google Sheets

When something happens in Jira, do it in Google Sheets.

6 Jira triggers wired to 9 Google Sheets actions. Most-used pairing: Comment Created → Add Sheet Tab.

Google Sheets → Jira

Or fire it the other way around.

2 Google Sheets triggers wired to 17 Jira actions downstream.

See Google Sheets → Jira →
Popular pairings

Common Jira → Google Sheets workflows.

Pick a pairing to set it up in two minutes. Each one is a fully editable recipe.

Showing 9 of 54 combinations
When comment created in Jira, add sheet tab in Google Sheets.

Fires when a comment is added to a Jira issue. Used to mirror engineering discussion to Slack, feed AI summaries, or notify external requesters.

When comment created in Jira, append row in Google Sheets.

Fires when a comment is added to a Jira issue. Used to mirror engineering discussion to Slack, feed AI summaries, or notify external requesters.

When comment created in Jira, clear values in Google Sheets.

Fires when a comment is added to a Jira issue. Used to mirror engineering discussion to Slack, feed AI summaries, or notify external requesters.

When comment created in Jira, create spreadsheet in Google Sheets.

Fires when a comment is added to a Jira issue. Used to mirror engineering discussion to Slack, feed AI summaries, or notify external requesters.

When new issue in Jira, add sheet tab in Google Sheets.

Fires when a new issue is created in Jira. The standard inbound hook for routing, enrichment, auto-labeling, and SLA-aware notifications.

When new issue in Jira, append row in Google Sheets.

Fires when a new issue is created in Jira. The standard inbound hook for routing, enrichment, auto-labeling, and SLA-aware notifications.

When new issue in Jira, clear values in Google Sheets.

Fires when a new issue is created in Jira. The standard inbound hook for routing, enrichment, auto-labeling, and SLA-aware notifications.

When new issue in Jira, create spreadsheet in Google Sheets.

Fires when a new issue is created in Jira. The standard inbound hook for routing, enrichment, auto-labeling, and SLA-aware notifications.

When issue deleted in Jira, add sheet tab in Google Sheets.

Fires when an issue is deleted in Jira. Useful for audit/compliance logs and for tearing down related records in other systems.

How it works

Connect Jira and Google Sheets in five steps.

No code, no glue, no half-day setup. Each step is one click.

  1. 1
    Connect
    Authorize Jira and Google Sheets

    Open TinyCommand, authorize Jira and Google Sheets once each. Both connections are available to every workflow on your account.

  2. 2
    Trigger
    Pick a Jira trigger

    Drop the Jira → Comment Created trigger onto the canvas. TinyCommand auto-registers the webhook.

    POST /v1/webhooks/jira.trigger-comment-created
  3. 3
    Transform
    Add a filter or AI step

    Optionally add a Filter node ("subject contains URGENT") or an AI step ("classify intent") between trigger and action.

  4. 4
    Action
    Add the Google Sheets action

    Drop the Google Sheets → Add Sheet Tab action below it. Map fields from the Jira payload into the Google Sheets inputs.

    google-sheets.add-sheet
  5. 5
    Publish
    Publish and forget

    Hit Publish. TinyCommand runs it in production from second one. Watch the run-log fill up.

FAQ

Questions about Jira + Google Sheets.

How do I sync Jira issues into Google Sheets?
Scheduled: Jira Search Issues with JQL → Sheets Update Values. Use issue key as upsert column. Useful for sprint reports, velocity tracking, or roll-up dashboards.
Can I bulk-create Jira issues from Sheet rows?
Yes. Sheets row added with "Send to Jira?" toggled → Jira Create Issue with project, summary, description, type, priority from row fields. Useful for migrations or backlog imports.
How do I report on Jira DORA metrics from Sheet data?
Sync deployment frequency (PR merges), lead time (issue created → resolved), change failure rate (rollback issues). Compute pivots weekly for DORA without paying for a dedicated tool.
Can I sync Jira custom fields into Sheets?
Yes. Specify customfield_XXXXX keys in the Search Issues fields parameter. Each custom field becomes a Sheet column. Helps with engineering-specific metrics not exposed by default.
How do I avoid Sheet bloat from large Jira queries?
Filter the JQL tightly (current sprint, current quarter, specific project). Archive old Sheet rows to a "historic" tab. Or roll up into one-row-per-sprint summaries.
Can I update Jira issue status from Sheet edits?
Yes. Sheets row edit on a status column → Jira Transition Issue (using Get Transitions to find the right transition ID). Useful for bulk status changes from a planning sheet.
Related

Other apps that pair well with Jira.

+
Jira + Gmail
Email
+
Jira + Slack
Communication
+
Jira + HubSpot
CRM & Sales
+
Jira + Stripe
Payments
+
Jira + Notion
Productivity
+
Jira + Airtable
Spreadsheets & Databases
Connect Jira to Google Sheets — start free