Here is the tutorial from Ana Kravitz who runs the API CONNECTOR addon for Google Sheets
To get the API URL path of your data on kobotoolbox. go to https://kc.humanitarianresponse.info/api/v1/data?format=json
and find the url path for your project in the webpage displayed.
Hope this helps.
