Remember that time you realized it was possible to refresh your Jira data in Google sheets with just one click? What if we told you that you can now get the latest data with no clicks at all?! Zero! Nada!
We're happy to announce that you can now schedule all data refreshes ahead of time. Whether it's for your every day standup, weekly check-in, or monthly reviews, you can always be assured that your charts, graphs, and reports are up-to-date.
To schedule a data refresh, open the Jira Cloud for Google Sheets add-on, click “Refresh Jira Data,” and click “Edit” to select how often you would like your data automatically updated. You will be prompted to authenticate with Google in order to allow the integration to refresh your data while you are offline.
Hover over the “Last updated” and “Scheduled update” section to get exact timestamps:
It’s important to note a couple of things:
There’s currently a distinction between importing and refreshing Jira data - an import will completely replace the previous sheet, whereas a refresh will only overwrite the affected columns.
You can only schedule refreshes for up to three months at once. We will always tell you when your next schedule is, until the end of the three-month period.
If you’re scheduling a refresh for a custom function, we won’t be able to display a timestamp for when the data was last updated.
You can now export filters and searches directly from Jira to Google Sheets. You can find the Google Sheets icon as a new option next to the share and export buttons on the issues search page:
Kindly try out this feature and let us know what you think by answering the following questions:
What were your impressions of the feature?
How can we improve the feature?
What do you use the feature for?
If you have any additional feedback, we’d love to talk to you! Feel free to book a 30-minute chat via this link. Cheers!
Learn how to use two new reports for next-gen projects in Jira Cloud: Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events