Skip to content
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.

Trigger app
Google Sheets as the trigger

Workflows fire when something happens in Google Sheets.

Action app
Jira as the action

Workflows do something in Jira, instantly.

See all 17 actions →
Both directions

Pick the way that fits your stack.

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

Google SheetsJira

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

2 Google Sheets triggers wired to 17 Jira actions. Most-used pairing: New RowAdd Comment.

JiraGoogle Sheets

Or fire it the other way around.

6 Jira triggers wired to 9 Google Sheets actions downstream.

See JiraGoogle Sheets
Popular pairings

Common Google Sheets → Jira workflows.

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

Showing 8 of 34 combinations
When new row in Google Sheets, add comment in Jira.

Fires when a new row is added to a Google Sheet (typically the first sheet tab). Common use: ingest form-fed rows into a CRM or notify on a new entry.

When new row in Google Sheets, add watcher in Jira.

Fires when a new row is added to a Google Sheet (typically the first sheet tab). Common use: ingest form-fed rows into a CRM or notify on a new entry.

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

Fires when a new row is added to a Google Sheet (typically the first sheet tab). Common use: ingest form-fed rows into a CRM or notify on a new entry.

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

Fires when a new row is added to a Google Sheet (typically the first sheet tab). Common use: ingest form-fed rows into a CRM or notify on a new entry.

When row updated in Google Sheets, add comment in Jira.

Fires when a row is updated in a Google Sheet. Useful for sync flows where the Sheet is a source-of-truth that drives downstream changes.

When row updated in Google Sheets, add watcher in Jira.

Fires when a row is updated in a Google Sheet. Useful for sync flows where the Sheet is a source-of-truth that drives downstream changes.

When row updated in Google Sheets, assign issue in Jira.

Fires when a row is updated in a Google Sheet. Useful for sync flows where the Sheet is a source-of-truth that drives downstream changes.

When row updated in Google Sheets, create issue in Jira.

Fires when a row is updated in a Google Sheet. Useful for sync flows where the Sheet is a source-of-truth that drives downstream changes.

How it works

Connect Google Sheets and Jira in five steps.

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

  1. 1
    Connect
    Authorize Google Sheets and Jira

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

  2. 2
    Trigger
    Pick a Google Sheets trigger

    Drop the Google Sheets → New Row trigger onto the canvas. Tiny Command auto-registers the webhook.

    POST /v1/webhooks/google-sheets.trigger-row-added
  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 Jira action

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

    jira.add-comment
  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 Google Sheets + Jira.

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 Google Sheets.


Wire Google Sheets to Jira in 2 minutes.

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