Kobotoolbox & Google sheet Sync

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.

3 Likes

Hi @mohan_n,

Thank you for adding this wonderful resource. It should benefit the entire community. Expecting the same in the upcoming days as well.

Have a great day!

Hi
This is pretty amazing and thank you so much for sharing this video.

Stephane

2 Likes

I’m not sure I fully understand how it works. I was able to get the survey pathway using this link

However, I can’t authenticate and get the error of…

{“detail”:“Authentication credentials were not provided.”}

Where do we enter authentication info?

Hi @pashches
Then it means you never followed this from the very initial process.

Stephane

There is no initial process!

There are 20 processes pasted throughout the thread, most of them are outdated and it’s not clear what the latest method is and the steps to follow through from start to finish. It’s quite confusing!

Hi @pashches

The above post should be the solution

2 Likes

this is not free …

Could you explain your point so that we get you more clearly.

1 Like

are there any free solution ?

1 Like

Hello @rahhal,

I found the following free solution, have tested it and it worked fine.
Hope that was useful.
https://github.com/pcurrier/KoboToolbox-GoogleApps-Scripts

I found this tutorial which explains step by step how to apply the previous solution:
https://www.dropbox.com/s/ctdsr55k883c5wm/Link%20your%20Kobo%20account%20to%20a%20Google%20sheet_EN_1802.pdf?dl=0

Best,

3 Likes

in this step :
When running this script for the first time, Google will ask for permission to access your spreadsheet data.

there are error :
This app isn’t verified

This app hasn’t been verified by Google yet. Only proceed if you know and trust the developer.

we must use advance
and go on

it is work
thanks

1 Like

@m.jaqmaqji i want to thank you again

1 Like

Hello, I was trying to use the API connector to get the data from my project but I keep getting a

“Request failed: Server responded with an error (404)” status. Is there anything other than the API link I got from kobo I need to do?

Thanks.

@drleandro, do you mean when you are trying to sync your data with Excel Power Query?

I am using Google Sheets with API Connecter. I got the url for my project but API connector keeps giving me that error message.

Maybe you could follow what @m.jaqmaqji has outlined in the post earlier.

It should definitely help you solve your issue.

I tried running the solution given by @m.jaqmaqji
but when i ran the final step for pulling the data, i received the following error:
image

Hi @mohan_n,
Have tried this demo https://github.com/pcurrier/KoboToolbox-GoogleApps-Scripts/blob/master/demo/Code.gs
Based on your authentication method you can choose what code in demo file to activate.

This is a working example of my test case:
image

In addition please provide more details about the error. you can share the Details of the error with us.

1 Like

Hello, sorry to bother you but i really need some help. I’m trying to sync the kobo data with Google sheets with the fork that was mentioned in the thread.

The problem is, it’s not going ahead after the CHOOSE HOST pop up window. I’ve raised the issue on GitHub as well.

I think there’s some problem in the HTML files. The call to functions in the button are not working.

Please help.