Unity localization and Google sheet problem

Unity Engine
, , ,
1

Hey everyone.

I’ve just started working with localization on a big project. What I want to do is to link my string table with a Google spreadsheet. In the spreadsheet, instead of having one single sheet to work on, I want to break the logic in this way:

  • One main sheet with all the columns: key, key comment, and all the languages
  • 1+ sheets for translation from English to any other language.

With that, the main sheet will be used only for visualization and, from a unity perspective, to pull string updates and push new keys.
Iusedg the QUERY function inside the main sheet to handle the linking from other sheets, but I had a problem.

If, in any case, a key in the middle of them, is deleted, nothing would shift up.

What can I do to achieve this logic? Do I have to change the spreadsheet’s shape?

2

You can link against multiple sheets, you dont need to use a single sheet. We support having a language per sheet.
You can add multiple Google Sheet extensions and configure each one for a sheet.
https://docs.unity3d.com/Packages/com.unity.localization@1.4/manual/Google-Sheets-Syncing-StringTableCollections.html