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 and Google SheetsSee 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 →
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 Tiny Command, 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. Tiny Command 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. Tiny Command 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

Wire Jira to Google Sheets in 2 minutes.

Free tier available. No credit card. No onboarding call.

Try for freeRequest a demo