Hello dear Kobo users,
if anyone is interested, I had created a GSheet template a while ago to automatically import Kobo data, thanks to the excellent ImportJSON library published by Brad Jasper and Trevor Lohrbeer (GitHub - bradjasper/ImportJSON: Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet).
You can make a copy of the workbook and add a trigger on the “triggerAutoRefresh” script to set-up an automatic refresh of the data.
done quickly … It can be improved … but it is very easy to use (just fill in the yellow cells) and it also works if the questionnaire has repeated groups (but you might have to adapt a formula).
KInd regards,
Serge
