Hello everybody, I have open-sourced my Gradle pl...

# feed

[litrik]

Hello everybody,

I have open-sourced my Gradle plugin that allows you to export/convert the strings in a Google Sheet into resource files for Android and Kotlin Multiplatform apps.
https://github.com/litrik/gsheet-resources

[Stefan Oltmann]

"Crowdin hates this trick." 😉

Sometimes it’s really just the small things. 😄
Thanks for sharing! 🙂

[אליהו הדס]

It’s really well thought out :) I’m still a bit worried that it might be quite fragile — does it rely on scraping?

[litrik]

It uses the standard Google Sheet function to export any public sheet as a CSV file:

"<https://docs.google.com/spreadsheets/d/${sheetId}/export?format=csv&gid=${tabId}>"

[אליהו הדס]

Ah, that’s great — I don’t know Google Sheets export function :) I’m going to use it!

[litrik]

I've been using this code internally for several years (for multiple apps/customers). The CSV export of Google Sheets has been very stable over all these years.

[אליהו הדס]

Thanks for open-sourcing it!

[David]

Did something similar a many year back but a command line utility. Maybe it can give some inspiration on how to handle quantitive strings as well. 🙂

[Benni H.]

Super cool @litrik!
I implemented basically the same thing at my job as well for internal use 😁
Have you managed find or think about a way to support plurals as well?

[litrik]

I typically define my plurals in a separate resource file and point to the strings in the generated resources.
So, assuming strings_generated.xml contains strings like event_days_left_one and event_days_left_other (generated from the Google Sheet), I would add the following to the main strings.xml to define the plurals:

<plurals name="event_days_left">
    <item quantity="one">@string/event_days_left_one</item>
    <item quantity="other">@string/event_days_left_other</item>
</plurals>

Maybe I can implement something similar to what @David did in the tool he mentioned above.

[litrik]

@Benni H. I've added support for plurals in a new 0.4.0 release. See https://github.com/litrik/gsheet-resources/tree/v0.4.0?tab=readme-ov-file#plurals

[Benni H.]

Very nice (and fast) 😁

[litrik]

After reading my own explanation how I was doing plurals, I realized that it can be automated (as long as you follow a few rules for the IDs). 🤷