Kobotoolbox & Google sheet Sync

ti_saigon · August 11, 2016, 10:50am

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

Tino_Kreutzer · August 13, 2016, 9:58pm

Hi,
There’s a small script for that, which just uses our API and GoogleSpreadsheets code. See https://github.com/kobotoolbox/kobocat-googleapps-scripts

Tino

···

On Thu, Aug 11, 2016 at 12:50 PM ti saigon tisa...@gmail.com wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

ti_saigon · August 14, 2016, 12:30am

Thanks Tino,
Do you know, how often sync/update data between Google sheet and Kobotoolbox? Ex: 2x/ hour or xxx/day

Thanks

···

On Sunday, August 14, 2016 at 4:58:20 AM UTC+7, Tino Kreutzer wrote:

Hi,
There’s a small script for that, which just uses our API and GoogleSpreadsheets code. See https://github.com/kobotoolbox/kobocat-googleapps-scripts

Tino

On Thu, Aug 11, 2016 at 12:50 PM ti saigon tis...@gmail.com wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

Tino_Kreutzer · August 14, 2016, 10:54am

Hi Ti,
It’s updated when you click the button after following the instructions. If you have suggestions on how to improve it or the documentation, please feel free to edit it - it’s open source code!

Tino

···

On Sun, Aug 14, 2016 at 2:30 AM, ti saigon tisa...@gmail.com wrote:

Thanks Tino,
Do you know, how often sync/update data between Google sheet and Kobotoolbox? Ex: 2x/ hour or xxx/day

Thanks

On Sunday, August 14, 2016 at 4:58:20 AM UTC+7, Tino Kreutzer wrote:

Hi,
There’s a small script for that, which just uses our API and GoogleSpreadsheets code. See https://github.com/kobotoolbox/kobocat-googleapps-scripts

Tino

On Thu, Aug 11, 2016 at 12:50 PM ti saigon tis...@gmail.com wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

ti_saigon · August 15, 2016, 3:24am

Thánks Tino,
I see.

Do you known other not free solution, can i pay for this.

Thanks

···

On Sunday, August 14, 2016 at 5:54:54 PM UTC+7, Tino Kreutzer wrote:

Hi Ti,
It’s updated when you click the button after following the instructions. If you have suggestions on how to improve it or the documentation, please feel free to edit it - it’s open source code!

Tino

On Sun, Aug 14, 2016 at 2:30 AM, ti saigon tis...@gmail.com wrote:

Thanks Tino,
Do you know, how often sync/update data between Google sheet and Kobotoolbox? Ex: 2x/ hour or xxx/day

Thanks

On Sunday, August 14, 2016 at 4:58:20 AM UTC+7, Tino Kreutzer wrote:

Hi,
There’s a small script for that, which just uses our API and GoogleSpreadsheets code. See https://github.com/kobotoolbox/kobocat-googleapps-scripts

Tino

On Thu, Aug 11, 2016 at 12:50 PM ti saigon tis...@gmail.com wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

Pandu_Setia_Wibawa · September 20, 2016, 8:35am

Hi, Tino,

Thanks for your info,
I have a question in step of sync it

In point 6 and 7. that “6 .Select your kobocat form which updates this sheet” and “7. Click ‘Submit’ and ‘OK’ to the popup”

can you help me how to doing that step

Thank you

···

On Sunday, August 14, 2016 at 4:58:20 AM UTC+7, Tino Kreutzer wrote:

Hi,
There’s a small script for that, which just uses our API and GoogleSpreadsheets code. See https://github.com/kobotoolbox/kobocat-googleapps-scripts

Tino

On Thu, Aug 11, 2016 at 12:50 PM ti saigon tis...@gmail.com wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

Pierre_Grandidier · September 21, 2016, 6:30pm

HI,

thanks for this great initiative.

I am also stuck after “5. Click ‘OK’ to the popup”…

Nothing happens and I do not get any possibility to Select my kobocat form which updates this sheet.

Do you have any clue?

Thanks!

···

Le mardi 20 septembre 2016 10:35:32 UTC+2, Pandu Setia Wibawa a écrit :

Hi, Tino,

Thanks for your info,
I have a question in step of sync it

In point 6 and 7. that “6 .Select your kobocat form which updates this sheet” and “7. Click ‘Submit’ and ‘OK’ to the popup”

can you help me how to doing that step

Thank you

On Sunday, August 14, 2016 at 4:58:20 AM UTC+7, Tino Kreutzer wrote:

Hi,
There’s a small script for that, which just uses our API and GoogleSpreadsheets code. See https://github.com/kobotoolbox/kobocat-googleapps-scripts

Tino

On Thu, Aug 11, 2016 at 12:50 PM ti saigon tis...@gmail.com wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

Mgri · October 5, 2016, 1:47pm

This could be a great tool but I am also stuck at point 5. I don’t get the option to choose a form. The script asks for my API code each time.

Any help would be appreciated.

Thank you.

···

On Wednesday, September 21, 2016 at 1:30:31 PM UTC-5, Pierre Grandidier wrote:

HI,

thanks for this great initiative.

I am also stuck after “5. Click ‘OK’ to the popup”…

Nothing happens and I do not get any possibility to Select my kobocat form which updates this sheet.

Do you have any clue?

Thanks!

Le mardi 20 septembre 2016 10:35:32 UTC+2, Pandu Setia Wibawa a écrit :

Hi, Tino,

Thanks for your info,
I have a question in step of sync it

In point 6 and 7. that “6 .Select your kobocat form which updates this sheet” and “7. Click ‘Submit’ and ‘OK’ to the popup”

can you help me how to doing that step

Thank you

On Sunday, August 14, 2016 at 4:58:20 AM UTC+7, Tino Kreutzer wrote:

Hi,
There’s a small script for that, which just uses our API and GoogleSpreadsheets code. See https://github.com/kobotoolbox/kobocat-googleapps-scripts

Tino

On Thu, Aug 11, 2016 at 12:50 PM ti saigon tis...@gmail.com wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

Mgri · October 5, 2016, 10:01pm

Quick update which might be helpful. I was able to use the execution transcript to determine that the code was getting hung at line 121

var kobocat_username = kobocat_users[0][“username”];

I replaced the “kobocat_users[0][“username”]” with ‘USERNAME’ and the code is working.

Hopefully others will find the same resolution.

Thanks.

···

On Wednesday, October 5, 2016 at 8:47:10 AM UTC-5, mgr...@aloterrallc.com wrote:

This could be a great tool but I am also stuck at point 5. I don’t get the option to choose a form. The script asks for my API code each time.

Any help would be appreciated.

Thank you.

On Wednesday, September 21, 2016 at 1:30:31 PM UTC-5, Pierre Grandidier wrote:

HI,

thanks for this great initiative.

I am also stuck after “5. Click ‘OK’ to the popup”…

Nothing happens and I do not get any possibility to Select my kobocat form which updates this sheet.

Do you have any clue?

Thanks!

Le mardi 20 septembre 2016 10:35:32 UTC+2, Pandu Setia Wibawa a écrit :

Hi, Tino,

Thanks for your info,
I have a question in step of sync it

In point 6 and 7. that “6 .Select your kobocat form which updates this sheet” and “7. Click ‘Submit’ and ‘OK’ to the popup”

can you help me how to doing that step

Thank you

On Sunday, August 14, 2016 at 4:58:20 AM UTC+7, Tino Kreutzer wrote:

Hi,
There’s a small script for that, which just uses our API and GoogleSpreadsheets code. See https://github.com/kobotoolbox/kobocat-googleapps-scripts

Tino

On Thu, Aug 11, 2016 at 12:50 PM ti saigon tis...@gmail.com wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

Pierre_Grandidier · October 19, 2016, 10:18am

Hi,

thanks for the update.

I have tried to implement your input but on my side I am still stuck at step 5.

No matter if I click on “set-up” or “import data”, the script keeps on asking my API and informs me that it is saved. But it never pops up with my list of forms…

Any clue to solve this?

This is a very important feature!

Thanks to all !

···

Le jeudi 6 octobre 2016 00:01:33 UTC+2, mgr...@aloterrallc.com a écrit :

Quick update which might be helpful. I was able to use the execution transcript to determine that the code was getting hung at line 121

var kobocat_username = kobocat_users[0][“username”];

I replaced the “kobocat_users[0][“username”]” with ‘USERNAME’ and the code is working.

Hopefully others will find the same resolution.

Thanks.

On Wednesday, October 5, 2016 at 8:47:10 AM UTC-5, mgr...@aloterrallc.com wrote:

This could be a great tool but I am also stuck at point 5. I don’t get the option to choose a form. The script asks for my API code each time.

Any help would be appreciated.

Thank you.

On Wednesday, September 21, 2016 at 1:30:31 PM UTC-5, Pierre Grandidier wrote:

HI,

thanks for this great initiative.

I am also stuck after “5. Click ‘OK’ to the popup”…

Nothing happens and I do not get any possibility to Select my kobocat form which updates this sheet.

Do you have any clue?

Thanks!

Le mardi 20 septembre 2016 10:35:32 UTC+2, Pandu Setia Wibawa a écrit :

Hi, Tino,

Thanks for your info,
I have a question in step of sync it

In point 6 and 7. that “6 .Select your kobocat form which updates this sheet” and “7. Click ‘Submit’ and ‘OK’ to the popup”

can you help me how to doing that step

Thank you

On Sunday, August 14, 2016 at 4:58:20 AM UTC+7, Tino Kreutzer wrote:

Hi,
There’s a small script for that, which just uses our API and GoogleSpreadsheets code. See https://github.com/kobotoolbox/kobocat-googleapps-scripts

Tino

On Thu, Aug 11, 2016 at 12:50 PM ti saigon tis...@gmail.com wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

Steve_DiPangrazio · April 18, 2017, 3:05pm

Like the others, I am stuck at the point that it asks for my API token after going “Update from kobocat” → “Setup.” After entering it, I am not prompted to select the form I would like to use. Am I doing something wrong/is there anything I can do manually to connect it to the right form?

Perhaps separately, the execution hints also say that the UiApp API is deprecated.

Thanks!

···

On Thursday, August 11, 2016 at 6:50:05 AM UTC-4, ti saigon wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

Johnny_Knox · April 19, 2017, 7:23am

I agree. This is why I have asked about Zapier updates so that Zapier can do the leg work of updating content in whatever service we use. Does anyone know of a way to use Zapier with Kobo?

···

On Thursday, August 11, 2016 at 5:20:05 PM UTC+6:30, ti saigon wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

Pho · April 25, 2017, 5:00pm

Like others here, I also had problems with the project that Tino linked, so I ended up having to write my own. You can find it here: GitHub - pcurrier/KoboToolbox-GoogleApps-Scripts: Google apps scripts for copying data between KoboToolbox survey and Google sheet. It can pull data from kobo into a google sheet, and can also push from a google sheet back to the kobo server. It supports basic and token authentication (haven’t been able to get OAuth2 working yet).

The code is working for the projects I personally deal with, but I have not tested it exhaustively on a wide range of different surveys. You should consider this project experimental, and do your own testing.

If you have problems feel free to open an issue in github.

···

On Tuesday, April 18, 2017 at 11:05:27 AM UTC-4, Steve Dipangrazio wrote:

Like the others, I am stuck at the point that it asks for my API token after going “Update from kobocat” → “Setup.” After entering it, I am not prompted to select the form I would like to use. Am I doing something wrong/is there anything I can do manually to connect it to the right form?

Perhaps separately, the execution hints also say that the UiApp API is deprecated.

Thanks!

On Thursday, August 11, 2016 at 6:50:05 AM UTC-4, ti saigon wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

Nicolas_LC · May 18, 2017, 10:48am

Hi, I was able to make it work by editing rows 188&119

var kobocat_users = JSON.parse(UrlFetchApp.fetch(‘KoBoCAT REST API’,getUrlFetchOptions()).getContentText());

var kobocat_username = ‘’;

hope that works… best

···

El martes, 18 de abril de 2017, 12:05:27 (UTC-3), Steve Dipangrazio escribió:

Like the others, I am stuck at the point that it asks for my API token after going “Update from kobocat” → “Setup.” After entering it, I am not prompted to select the form I would like to use. Am I doing something wrong/is there anything I can do manually to connect it to the right form?

Perhaps separately, the execution hints also say that the UiApp API is deprecated.

Thanks!

On Thursday, August 11, 2016 at 6:50:05 AM UTC-4, ti saigon wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

Steve_DiPangrazio · May 18, 2017, 1:29pm

I’ll give that a try. Thanks!

···

On Thu, May 18, 2017 at 6:48 AM, Nicolas LC loboco...@gmail.com wrote:

Hi, I was able to make it work by editing rows 188&119

var kobocat_users = JSON.parse(UrlFetchApp.fetch(‘https://kc.kobotoolbox.org/api/v1/’,getUrlFetchOptions()).getContentText());

var kobocat_username = ‘’;

hope that works… best

El martes, 18 de abril de 2017, 12:05:27 (UTC-3), Steve Dipangrazio escribió:

Like the others, I am stuck at the point that it asks for my API token after going “Update from kobocat” → “Setup.” After entering it, I am not prompted to select the form I would like to use. Am I doing something wrong/is there anything I can do manually to connect it to the right form?

Perhaps separately, the execution hints also say that the UiApp API is deprecated.

Thanks!

On Thursday, August 11, 2016 at 6:50:05 AM UTC-4, ti saigon wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

–

You received this message because you are subscribed to a topic in the Google Groups “Kobo Users” group.

To unsubscribe from this topic, visit https://groups.google.com/d/topic/kobo-users/sb49VqS-84A/unsubscribe.

To unsubscribe from this group and all its topics, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

Alexandra · May 25, 2017, 1:58pm

I made it work with your way! thanks a million for that!
Something maybe useful I found out is that it doesn’t shows the questions that are in a nested group. I solved it using only 1-level grouping but if anyone has any good idea it’s more than welcome

···

On Tuesday, 25 April 2017 20:00:13 UTC+3, pho...@gmail.com wrote:

Like others here, I also had problems with the project that Tino linked, so I ended up having to write my own. You can find it here: https://github.com/pcurrier/KoboToolbox-GoogleApps-Scripts. It can pull data from kobo into a google sheet, and can also push from a google sheet back to the kobo server. It supports basic and token authentication (haven’t been able to get OAuth2 working yet).

The code is working for the projects I personally deal with, but I have not tested it exhaustively on a wide range of different surveys. You should consider this project experimental, and do your own testing.

If you have problems feel free to open an issue in github.

On Tuesday, April 18, 2017 at 11:05:27 AM UTC-4, Steve Dipangrazio wrote:

Like the others, I am stuck at the point that it asks for my API token after going “Update from kobocat” → “Setup.” After entering it, I am not prompted to select the form I would like to use. Am I doing something wrong/is there anything I can do manually to connect it to the right form?

Perhaps separately, the execution hints also say that the UiApp API is deprecated.

Thanks!

On Thursday, August 11, 2016 at 6:50:05 AM UTC-4, ti saigon wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

Derek_Caelin · June 20, 2017, 2:48pm

I was freezing on step 5 as well, but after deleting all of my unused forms until I got down to 2 or 3, I was able to select my desired form.

···

On Saturday, August 13, 2016 at 5:58:20 PM UTC-4, Tino Kreutzer wrote:

Hi,
There’s a small script for that, which just uses our API and GoogleSpreadsheets code. See https://github.com/kobotoolbox/kobocat-googleapps-scripts

Tino

On Thu, Aug 11, 2016 at 12:50 PM ti saigon tis...@gmail.com wrote:

Dear friends,
i want to sync data from Kobotoolbox to Google sheet.

Do you have tool or addon do it?

Thank you much

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

aqhoan · August 28, 2017, 10:06am

Dear All,

I tested Kobotoolbox sync with google sheet and it was worked, but Manually,

I mean((You must click on the Kobotoolbox button and then click on the entry then “Select the survey(s) to import” then choose “Import data into which sheet?” finally “Import survey data” for update the data from Kobo to excel sheet)).

But, I need automatically, do you have any ways

Pierre_Grandidier · August 28, 2017, 1:15pm

Dear Ahmed,
I am glad that the Kobo-GSheet synch is working on your side. It is also working for me.

You can easily set up some automated time based triggers on any Google script. I have set up mine to update every 5 minutes.

Please follow this link which describes it well:

I hope this helps!

Pierre

···

Le lundi 28 août 2017 12:06:59 UTC+2, Ahmed Hassan a écrit :

Dear All,

I tested Kobotoolbox sync with google sheet and it was worked, but Manually,

I mean((You must click on the Kobotoolbox button and then click on the entry then “Select the survey(s) to import” then choose “Import data into which sheet?” finally “Import survey data” for update the data from Kobo to excel sheet)).

But, I need automatically, do you have any ways

Dohukd · August 30, 2017, 8:46am

Hello Pierre,

I try it, but I don’t know how to chose the forms form kobo to update the data to sheet,
for Example , I have form from Kobo the name is : Assessment GB and I have other, in google sheet I have Assessment_GB_2017 with other sheet , so, How I can automatically update the data from Assessment GB to Assessment_GB_2017.

please see the attache

Best,
Ahmed

···

On Monday, August 28, 2017 at 4:15:16 PM UTC+3, Pierre Grandidier wrote:

Dear Ahmed,
I am glad that the Kobo-GSheet synch is working on your side. It is also working for me.

You can easily set up some automated time based triggers on any Google script. I have set up mine to update every 5 minutes.

Please follow this link which describes it well:

https://www.quora.com/How-can-I-periodically-run-a-Google-Script-on-a-Spreadsheet

I hope this helps!

Pierre

Le lundi 28 août 2017 12:06:59 UTC+2, Ahmed Hassan a écrit :

Dear All,

I tested Kobotoolbox sync with google sheet and it was worked, but Manually,

I mean((You must click on the Kobotoolbox button and then click on the entry then “Select the survey(s) to import” then choose “Import data into which sheet?” finally “Import survey data” for update the data from Kobo to excel sheet)).

But, I need automatically, do you have any ways