Good day
Were you able to resolve fix your request around linking Kobotoolbox and Google sheet sync? If yes, please can you help me out?
Hi @tomisin
Not yet. The first attempt did not go well. So I will probably see if I can find time this week to look at it and then update you on the forum.
Stephane
1 Like
Thanks.
I will follow-up up with you on that.
Kind Regards
1 Like
Hey Stephane, I was able to copy the script from the git repository to google sheet (including the form and host sections as separate html scripts. I was able to run the script and pull data with partial success.
I have attached an image above which shows that I was able to pull everything needed except for values for columns B, C, D, and E.
Something to note is that I was unsure of how to upload the blank form to google drive as the XLS data wasn’t accessible until I had at least one submission. Therefore, row 2 used to have that initial submission. If I delete the row, then a duplicate entry appears of one of the other submissions but if I leave row 2 as is, there are no issue.
1 Like
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?
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!
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
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.
