Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-451

Jira Cloud for Sheets integration fails with error GS-404

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 1.0
    • Jira Cloud for Google Sheets
    • None
    • Severity 3 - Minor

      Issue Summary

      Jira Cloud for Sheets might fail with the error Hmmm ... looks like we stumbled a bit, please try again or contact Atlassian support if the issue persists. (§GS-404).

      That happens because the integration is unable to find the target sheet.

      Steps to Reproduce

      There are no clear steps that could lead to replicating that problem that have been identified yet.

      Expected Results

      The integration will be able to load content on the sheet.

      Actual Results

      The integration simply fails to load content on the target sheet.

      Workaround

      Recreating the affected sheet normally resolves the problem i.e. open a new google sheet

       

            [API-451] Jira Cloud for Sheets integration fails with error GS-404

            Michał Paczynski added a comment - - edited

            I think we found the fix

            Step 1: Remove Atlassian app connections

            Go to: https://id.atlassian.com/manage-profile/apps

            • Remove the following apps (if present):
            • ScriptRunner for Jira Cloud
            • Jira Cloud for Sheets

            Step 2: Remove Google OAuth access

            Go to: https://myaccount.google.com/connections?filters=3,4&hl=en-GB

            • Find and remove the connection called Jira Cloud for Sheets.

            Step 3: Reopen the add-on in Google Sheets

            • Open any Google Sheet.
            • Go to Extensions > Jira Cloud for Sheets > Open.
            • When prompted, re-authorize access (you’ll see the Google OAuth window).
            • Confirm all required permissions.

            The add-on should now load correctly and be connected with a fresh token.

            Michał Paczynski added a comment - - edited I think we found the fix Step 1: Remove Atlassian app connections Go to:  https://id.atlassian.com/manage-profile/apps Remove the following apps (if present): ScriptRunner for Jira Cloud Jira Cloud for Sheets Step 2: Remove Google OAuth access Go to: https://myaccount.google.com/connections?filters=3,4&hl=en-GB Find and  remove  the connection called  Jira Cloud for Sheets . Step 3: Reopen the add-on in Google Sheets Open any Google Sheet. Go to  Extensions > Jira Cloud for Sheets > Open . When prompted,  re-authorize  access (you’ll see the Google OAuth window). Confirm all required permissions. The add-on should now load correctly and be connected with a fresh token.

            Kinga Otlik added a comment -

            Hi, this is also affecting me. Please retrieve this functionality.

            Kinga Otlik added a comment - Hi, this is also affecting me. Please retrieve this functionality.

            Muhamad Surya Iksanudin added a comment -

            i have this issue, any update for this?

            Muhamad Surya Iksanudin added a comment - i have this issue, any update for this?

            Leonardo De Almeida added a comment -

            Hello,

            This is Leonardo from Atlassian. I work on the Cloud support team.

            We have investigated that error, and we found out that the error is being thrown because Google's endpoint (responsible for retrieving the sheets' ID) simply returns a server error for some sheets.

            We performed a test with the endpoint at https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get

            We have already opened a bug on Google's issue tracker: https://issuetracker.google.com/issues/197649180?pli=1

            Leonardo De Almeida added a comment - Hello, This is Leonardo from Atlassian. I work on the Cloud support team. We have investigated that error, and we found out that the error is being thrown because Google's endpoint (responsible for retrieving the sheets' ID) simply returns a server error for some sheets. We performed a test with the endpoint at https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get We have already opened a bug on Google's issue tracker: https://issuetracker.google.com/issues/197649180?pli=1

            jan.legutko added a comment -

            Hi,

            This issue occurs in my team's sheet that we used for many months. I had to create new files with a single sheet in it as a workaround - that works.

            Funny thing is that when I create a file in which I move one sheet - things work. But when I move a few (4-5) more, things stop working in the new file.

            2 posts in Community I know this issue is reported:

            1. https://community.atlassian.com/t5/Jira-discussions/Jira-Cloud-for-Google-Sheets-not-syncing/td-p/1551325#U1777076
            2. https://community.atlassian.com/t5/Jira-questions/Jira-Google-Sheets-add-on-error/qaq-p/1772536#M495649 

             

            jan.legutko added a comment - Hi, This issue occurs in my team's sheet that we used for many months. I had to create new files with a single sheet in it as a workaround - that works. Funny thing is that when I create a file in which I move one sheet - things work. But when I move a few (4-5) more, things stop working in the new file. 2 posts in Community I know this issue is reported: https://community.atlassian.com/t5/Jira-discussions/Jira-Cloud-for-Google-Sheets-not-syncing/td-p/1551325#U1777076 https://community.atlassian.com/t5/Jira-questions/Jira-Google-Sheets-add-on-error/qaq-p/1772536#M495649    

              Unassigned Unassigned
              lalmeida@atlassian.com Leonardo De Almeida
              Affected customers:
              11 This affects my team
              Watchers:
              16 Start watching this issue

                Created:
                Updated: