Authorization error seen when using Jira Cloud for Google Sheets addon - Error 400: admin_policy_enforced
Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.
Summary
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
Environment
Integration Between:
- Jira Cloud
- Google Sheets
Diagnosis
- Error snippet seen in Google sheets:
Cause
The Error 400: admin_policy_enforced means that your organization doesn't allow Jira Cloud to access Google data.
Solution
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:
- Log in to the Google Admin console.
- From the Home page, go to Security API controls.
- Under App access control, click MANAGE THIRD-PARTY APP ACCESS.
- Add a filter to find the JIRA app in the list. Enter "JIRA" in the Contains field, and click APPLY.
- Check the box for JIRA and click Change Access
- Choose the Trusted option to allow access to all Google services.
- Click CHANGE.
A Video Link has been provided to help you with the settings on Google Admin Console: link to video here