Google sheet API downloads for grouped data

[TGHKobo]

Hello,

The GSheet template indicated here might help you :

API to Google Sheet without 'API Connector Pro'

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 … …

You might have to duplicate the RGroup sheet and adapt its formula in A1 cell if you have several repeated groups.

Kind regards,
Serge