Google sheet API downloads for grouped data

[PrashanthSJ]

Hi, greetings!
Can anyone help me in providing solution to get the Grouped Data in Google Spreadsheets with Parent ID and Index number as it is downloaded in CSV or Excel file in Kobo collect Data–>> Downloads section.

I have a data set where in we are looking for a number of persons trained and their basic details such as name, age, contact details, etc. Under repeated group for each training conducted.

I tried several ways, somehow the data spread vertically only in columns in Gsheet when refreshed with API connectors. But, I need it in two different sheets one for main data and the second sheet with grouped responses with Parent ID .

Kindly help me.

[Kal_Lam]

Welcome to the community, @PrashanthSJ! Have you tried this with Excel Power Query?

[PrashanthSJ]

Hi @Kal_Lam Thank you for quick response. I haven’t tried with Excel Power Query. Basically, I need it in Google spreadsheet as I wanted to link the data with Google Data Studio for visualising.

[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