Question Can not upload table to google sheets

Hello. I'm trying to setup google sheets integration: oauth 2.0 completed successfully, but after trying to sync localization table there are following error:

Code (CSharp):

1. InvalidOperationException: Stack empty.
2. System.Collections.Generic.Stack`1[T].ThrowForEmptyStack () (at <e53907b070fc42a5ad424d2e589e5ab0>:0)
3. System.Collections.Generic.Stack`1[T].Pop () (at <e53907b070fc42a5ad424d2e589e5ab0>:0)
4. UnityEditor.PropertyDrawer.OnGUISafe (UnityEngine.Rect position, UnityEditor.SerializedProperty property, UnityEngine.GUIContent label) (at /home/bokken/buildslave/unity/build/Editor/Mono/ScriptAttributeGUI/PropertyDrawer.cs:24)
5. UnityEditor.PropertyHandler.OnGUI (UnityEngine.Rect position, UnityEditor.SerializedProperty property, UnityEngine.GUIContent label, System.Boolean includeChildren, UnityEngine.Rect visibleArea) (at /home/bokken/buildslave/unity/build/Editor/Mono/ScriptAttributeGUI/PropertyHandler.cs:173)
6. UnityEditor.PropertyHandler.OnGUI (UnityEngine.Rect position, UnityEditor.SerializedProperty property, UnityEngine.GUIContent label, System.Boolean includeChildren) (at /home/bokken/buildslave/unity/build/Editor/Mono/ScriptAttributeGUI/PropertyHandler.cs:134)
7. UnityEditor.EditorGUI.PropertyFieldInternal (UnityEngine.Rect position, UnityEditor.SerializedProperty property, UnityEngine.GUIContent label, System.Boolean includeChildren) (at /home/bokken/buildslave/unity/build/Editor/Mono/EditorGUI.cs:7118)
8. UnityEditor.EditorGUI.PropertyField (UnityEngine.Rect position, UnityEditor.SerializedProperty property, UnityEngine.GUIContent label, System.Boolean includeChildren) (at /home/bokken/buildslave/unity/build/Editor/Mono/EditorGUI.cs:8580)
9. UnityEditor.Localization.UI.ReorderableListExtended.DrawElement (UnityEngine.Rect rect, System.Int32 idx, System.Boolean isActive, System.Boolean isFocused) (at Library/PackageCache/com.unity.localization@1.0.5/Editor/UI/Utility/ReorderableListExtended.cs:81)
10. UnityEditorInternal.ReorderableList.DoListElements (UnityEngine.Rect listRect, UnityEngine.Rect visibleRect) (at /home/bokken/buildslave/unity/build/Editor/Mono/GUI/ReorderableList.cs:943)
11. UnityEditorInternal.ReorderableList.DoLayoutList () (at /home/bokken/buildslave/unity/build/Editor/Mono/GUI/ReorderableList.cs:723)
12. UnityEditor.Localization.UI.LocalizationTableCollectionEditor.OnInspectorGUI () (at Library/PackageCache/com.unity.localization@1.0.5/Editor/UI/Tables/LocalizationTableCollectionEditor.cs:211)
13. UnityEditor.UIElements.InspectorElement+<>c__DisplayClass59_0.<CreateIMGUIInspectorFromEditor>b__0 () (at /home/bokken/buildslave/unity/build/ModuleOverrides/com.unity.ui/Editor/Inspector/InspectorElement.cs:636)
14. UnityEngine.GUIUtility:ProcessEvent(Int32, IntPtr, Boolean&) (at /home/bokken/buildslave/unity/build/Modules/IMGUI/GUIUtility.cs:189)
15.  

Editor platform is Linux, Unity ersion is 2021.2.1f1.
Google sheets integration is still not production ready?

 

After attempt to create table, empty table is created. Mapping is not changing this behavior

 

No, before this there was no any error message. This happen after clicking "Create New Spreadsheet" button in the initial sync.

 

Already submitted: https://fogbugz.unity3d.com/default.asp?1379237_17i3vql8na4htrnq

 

Same issue after clicking "Open" CSV file.

Also, I find weird logic. Opened CSV file with row 3 with texts -> row 3 has data in unity string table collection -> Opened CSV file without row 3 -> row 3 not cleared in string table collection (only new ids added working?)

 

Ok.

Do I understand correctly that in the case of normal execution, row 4 should have been cleared (like in the last imported CSV)?

 

@karl_jones Sorry, this issue is not linked with google drive connection itself: I just misunderstood, that I have to manually add column settings, document and sheet ids into connection script. After this information was filled, connection become working perfectly, but initial error message is still appears every time I try to sync with drive

 

I submitted a bug report https://fogbugz.unity3d.com/default.asp?1380696_fq4qnedg5phpq49b

 

https://fogbugz.unity3d.com/default...5.1971544426.1637001302-1777032395.1620243037 error itself is described here, I was already submitted it