Google Sheets Service not updating

Unity Engine
, ,
1

Hi, I have copied my settings from one working project into a new project but I can not get the new project to work.

I have Authorised the service via oAuth with the id and secret. I have allowed this and I get an ‘Authorised’ response.

However when I set up a table and add teh sheets plugin, whilst I can open the Sheed from Unity, I can not pull it or push to it.

I get the following permissions error:

GoogleApiException: Google.Apis.Requests.RequestError
The caller does not have permission [403]
Errors [
    Message[The caller does not have permission] Location[ - ] Reason[forbidden] Domain[global]
]

Google.Apis.Requests.ClientServiceRequest`1[TResponse].ParseResponse (System.Net.Http.HttpResponseMessage response) (at <20147215d023497caf9ddab1d6e6c98d>:0)
Google.Apis.Requests.ClientServiceRequest`1[TResponse].Execute () (at <20147215d023497caf9ddab1d6e6c98d>:0)
UnityEditor.Localization.Plugins.Google.GoogleSheets.SendBatchUpdateRequest (System.String spreadsheetId, Google.Apis.Sheets.v4.Data.Request[] requests) (at Library/PackageCache/com.unity.localization@1.0.5/Editor/Plugins/Google/GoogleSheets.cs:863)
UnityEditor.Localization.Plugins.Google.GoogleSheets.AddSheet (System.String title, UnityEditor.Localization.Plugins.Google.NewSheetProperties newSheetProperties) (at Library/PackageCache/com.unity.localization@1.0.5/Editor/Plugins/Google/GoogleSheets.cs:143)
UnityEditor.Localization.Plugins.Google.GoogleSheetsExtensionPropertyDrawer.DrawSheetField (UnityEditor.Localization.Plugins.Google.GoogleSheetsExtensionPropertyDrawerData data, UnityEngine.Rect& position) (at Library/PackageCache/com.unity.localization@1.0.5/Editor/Plugins/Google/GoogleSheetsExtensionPropertyDrawer.cs:220)
UnityEditor.Localization.UI.ReorderableListExtended:smile:rawElement(Rect, Int32, Boolean, Boolean)
UnityEditorInternal.ReorderableList:smile:oListElements(Rect, Rect) (at /Users/bokken/build/output/unity/unity/Editor/Mono/GUI/ReorderableList.cs:959)
UnityEditorInternal.ReorderableList:smile:oLayoutList() (at /Users/bokken/build/output/unity/unity/Editor/Mono/GUI/ReorderableList.cs:724)
UnityEngine.GUIUtility:ProcessEvent(Int32, IntPtr, Boolean&) (at /Users/bokken/build/output/unity/unity/Modules/IMGUI/GUIUtility.cs:189)

I have multiple google accounts and am wondering if this is the issue. All the accounts have access to the file I am trying to access.

2

Ah I was using teh default version of teh localization lib. 1.0.5. I manually updated to 1.4.2 and everything worked.

Thought this might be helpful.

1 Like