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

Other apps that pair well with Jira.

Spreadsheets & Databases

Connect Jira to Google Sheets — start free