all credit goes to “pcurrier” who created this script …
If anyone finds it useful, I also created a “quick and dirty” implementation of the same procedure, allowing to take advantage of the possibilities offered by the “synchronous exports” do download data. Mentioned in this post: https://community.kobotoolbox.org/t/api-to-google-sheet-without-api-connector-pro/34666/10?u=tghkobo