How to Schedule a Jira Export to Google Sheets

Start with a report-shaped JQL query

Use the narrowest query that answers the reporting question. Include a stable project or team boundary, explicit statuses, and an ORDER BY clause so refreshes are predictable.

Test the JQL in Jira first. A scheduled export should automate a known-good query, not hide an uncertain one.

Choose columns before scheduling

1. Add the identifiers people use to verify a row: issue key, summary, status, assignee, and updated date.
2. Add only the custom fields needed by the report.
3. Keep the issue key as the stable row identity if the sheet may later feed an update workflow.

Run one manual refresh and check field formatting, permissions, and the expected issue count.

Set a useful cadence

Hourly works for operational queues, daily for team reporting, and weekly for planning snapshots. Schedule the report only after the manual result is correct, then keep formulas and dashboards on separate tabs so refreshes cannot overwrite them.