You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I currently use Jira cloud for sheets to get information from Jira exported into Google sheets. I have a bunch of different sheets for different projects. Some sheets will update on their daily schedule just fine, but a lot of sheets will get this error in Jira Cloud for Sheets:
Last import failed with error: (cells.go:419) googleapi: Error 503: The service is currently unavailable., backendError
I can refresh the issues a time or two and the information will come over, but I need this to work everytime, or at least almost every time so I don't have to manually refresh it.
I use JQL import type with the formula as:
PROJECT IN ("X") AND ISSUETYPE IN ("Bug") AND STATUS IN ("To Do", "In review", "In Progress", "Done", "Ready for review", "Testing", "Rejected", "Blocked", "Won't do") AND REPORTER IN ("X", "Y", "Z") ORDER BY created ASC
Is there an issue with my formula, or maybe the way Each project is set up in Jira? Thank you for any help!
Atlassian transitioned Jira Cloud for Sheets to maintenance mode, with enhancements discontinued, in summer of 2022 (background here). This has resulted in many user-reported issues and increased system unreliability. The user community is full of post by users that lose connectivity, see frequent errors (503 and others), experience various data issues (duplication, missing data, etc.) If reliable exports are important to your business, we recommend to try our Google Sheet Integration add-on. It works fundamentally different by exporting directly out of Jira via API calls. It is much more reliable and used by the largest organizations. Exports can be one-time, scheduled, or real-time You can also export much richer data to create more sophisticated reports (Assets, Changelogs, Projects, Sprints, Users, etc.). Everything directly controlled within Jira. Give it a try.
The Mobility Team
I don't have multiple accounts signed in, that did happen at one point and I fixed that. I have multiple tabs on the one sheet, quite a few. I am currently changing them to refresh at different times of the day to see if that helps. They were all set to about 2 or 3 different times overnight, but I am going to change them to only have 2 refresh at the same time.