要約

When a user tries to export a list of issues in a Google sheet via JIRA Cloud for Google sheet add-on, during the auth process they get the below error

Error 400: admin_policy_enforced 

環境

Integration Between:

1. Jira Cloud
2. Google スプレッドシート

診断

• Error snippet seen in Google sheets:
  

原因

The Error 400: admin_policy_enforced means that your organization doesn't allow Jira Cloud to access Google data.

ソリューション

If you received this error message, have an administrator of your Google Workspace account follow the instructions from this article from Google's help centre: Control which third-party & internal apps access Google Workspace data.

Steps:

1. Log in to the Google Admin console.
2. From the Home page, go to   Security  API controls.
3. Under App access control, click MANAGE THIRD-PARTY APP ACCESS.
4. Add a filter to find the JIRA app in the list. Enter "JIRA" in the Contains field, and click APPLY.
5. Check the box for JIRA and click Change Access
6. Choose the Trusted option to allow access to all Google services.
7. Click CHANGE.

A Video Link has been provided to help you with the settings on Google Admin Console: link to video here