Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you will find the site temporarily inaccessible. Thanks for your patience. Read more.

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

Jira x Google Sheets suddenly getting rate limited everywhere

Jeremy Benson December 17, 2024

Starting yesterday I'm suddenly getting rate limited in google sheets using Jira integration for google sheets. This hasn't happened before and I haven't added new jira function calls recently. Did something change recently? 

The errors are pretty hard to clear because even after a few minutes it doesn't retry and I have to adjust some part of the function like arbitrarily changing the limit param just to get it to actually try again. This is breaking a whole bunch of dashboards and reports that are really useful to my teams, and advice appreciated. I'd rather not have to write a new API integration and start using regular databases to do all of this. 

2 answers

1 vote
MobilityStream
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.
December 17, 2024

Hi @Jeremy Benson ,

 

I'm not sure if you are using our Google Sheets Integration for Jira add-on or Atlassian's Jira Cloud for Google Sheets.

If you are using Google Sheets Integration, here is an article on how to determine if this is the problem and request an increase in quota with Google:

https://docs.mobilitystream.com/gsi/google-api-quota-limits

If you are using Jira Cloud for Google Sheets, you can scroll down to the resolution section and request an increase in quota, that should solve the problem for that tool as well.

 

Kind regards,

The Mobility Team

 

 

0 votes
MobilityStream
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.
December 17, 2024

@Jeremy Benson ,

 

We just heard some rumblings about the quota issue. If you are using Atlassian Jira Cloud for Google Sheets, the below change might be the culprit: 

https://community.atlassian.com/t5/Jira-articles/Announcement-Important-Update-in-Jira-Cloud-for-Google-Sheets/ba-p/2873565?utm_campaign=subscription_search_blog_comment&utm_content=topic&utm_medium=email&utm_source=atlcomm

Unfortunately, we can't help you much further with this. You might want to contact Atlassian Support.

 

Another alternative would be to try our Google Sheets Integration add-on. It works differently and is more robust for large and reoccurring exports. Unless you update thousands of issues every day & everything is set to real-time, you won't hit the quota.

 

Best regards,

The Mobility Team

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events