Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Export info from JIRA to GSheets giving error: (cells.go:419) googleapi: Error 503: BackendError


Hi everyone!

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!  

2 answers

0 votes
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Dec 06, 2023

Hi @Nicole Johnson

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.

Kind regards,
The Mobility Team

Hey Nicole,

I use a similar export for a report that I update daily and had issues initially with errors being thrown when using the JQL, have you by chance tried saving the JQL as a filter and using the filter as the import type vs the JQL?

I have not, can you tell me how to do that so I can try it out?(:

Sure, when you have your JQL select save as at the top to create the filter

save as jql.png

After you have your filter created in the Jira cloud for gsheets app you can change the get issues section from the JQL to the filter your have just saved.

Awesome, that seems to be working so far! Thanks so much!

It happened again.. After using the filters instead I got the same errors once everything autorefreshed last night. 

Have you attempted to remove and add the plugin into the sheet again? Does this issue persist across multiple gsheets? Do you have multiple google accounts signed in?

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.

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events