missleading, this does NOT work real time, every time you add new data to the form you have to export and the URL will be different every time, you better use API connector
Hi. Thankyou for the tutorial. It went well, but when I reach over 500 submission data it turn to error message "Resource at url contents exceeded maximum size". I wondering, is there any maximum size of csv to fetch in google sheet? Any idea to fix this?
You can connect to 2 - 3 or more sheets then when it's up to 500 delete some rows and concatenate all sheets. Another simple explanation- fetch the data to 2 or more sheets, when you notice that you are close to 500 submissions, delete the row since, you still have it in another sheet. Which means that 1 sheet for 1-500 submissions, then 2nd sheets for 501-1000 continue like that. then you can connect all sheets to one in another workbook or sheet
Hello from Mexico Oluwa, I have been troubles with "real time", how long time I need wait to have the data in data sheet? thank you so much, your video it really helps me!
Nice one oluwaseun, my google sheet is well connected to my kobotoolbox but I couldn't fetch new data entry from Kobotoolbox. E.G I have 600 fetched data, I entered two new datasets into Kobotoolbox, but I couldn't find them in my google sheet and I don't know why.
Thanks for sharing the process but once i connected the data in google sheet the data is not correctly aligned any tips for this i have survey form in enketo
what is the survey limit in its free plan I didnt understand if I am accessing million records i.e for million user per month will it not work it said a survey limit of 25k
sir I encountered this error "Resource at url not found." i followed the steps on how to put the link to import the data..thanks if you can help me sir...
HELLO BRO FROM NIGERIA GOD BLESSED YOU. I HAVE WATCHED OTHER VIDEOS BUT COULDN'T FIND SOLUTION. I THINK YOU SHOULD IMPROVE ON YOUR SEARCH TERM. WHY DON'T YOU SAY "LINKING G OOGLESHEET WITH KOBOTOOLBOX" THIS IS THE SEARCH I HAVE BEEN USING UNTIL I FOUND YOU
Nice job. Help me a lot
Thank you!
Thank you for this Oluwaseun.
Great job, Seun.
Thanks..Very useful video
missleading, this does NOT work real time, every time you add new data to the form you have to export and the URL will be different every time, you better use API connector
Hi. Thankyou for the tutorial. It went well, but when I reach over 500 submission data it turn to error message "Resource at url contents exceeded maximum size". I wondering, is there any maximum size of csv to fetch in google sheet? Any idea to fix this?
You can connect to 2 - 3 or more sheets then when it's up to 500 delete some rows and concatenate all sheets. Another simple explanation- fetch the data to 2 or more sheets, when you notice that you are close to 500 submissions, delete the row since, you still have it in another sheet. Which means that 1 sheet for 1-500 submissions, then 2nd sheets for 501-1000 continue like that. then you can connect all sheets to one in another workbook or sheet
Hello from Mexico Oluwa, I have been troubles with "real time", how long time I need wait to have the data in data sheet? thank you so much, your video it really helps me!
It will take like 5 to 10 minutes.
Thank you so much. So this will automatically update the googlesheet each time there is a new data submission?
Yes but it’s going to be every 1 hour. If you submit a new data you will need to wait an hour before it will shoe in google sheet.
Thanks Seun!
Nice one oluwaseun, my google sheet is well connected to my kobotoolbox but I couldn't fetch new data entry from Kobotoolbox. E.G I have 600 fetched data, I entered two new datasets into Kobotoolbox, but I couldn't find them in my google sheet and I don't know why.
It will display after one hour. That’s the process of google sheet, since we rely on importdata function
Thanks for this.. is alright 1 hour.. hehe..
is that we should always open the file.. or.. just can we close file and wait..
Thanks for sharing the process but once i connected the data in google sheet the data is not correctly aligned any tips for this i have survey form in enketo
what is the survey limit in its free plan I didnt understand if I am accessing million records i.e for million user per month will it not work it said a survey limit of 25k
You can subscribe for one month plan then mail them for additional submissions
sir I encountered this error "Resource at url not found." i followed the steps on how to put the link to import the data..thanks if you can help me sir...
Make sure you deploy the form first. secondly you also need to download the form.
Sorry, What can I do if it tells me that the URL does not exist or is not valid?
There’s tendency that you have deleted the form mistakenly. Check it and follow my step.
I can't find the csv in the api access?
Check the kobotoolbox you are using please. If it is humanitarian you can use this: kobo.humanitarianresponse.info/api/v2/
How do you connect Kobotoolbox v1 to google sheet
There’s no csv or xlsx url in Kc.humanitarianresponse.info/api/v1/data. That’s why it’s best to use v2
@@oluwaseunogunmolu Very Grateful, i used the version 2 and it worked like magic
@@emmanuelowusukwakye232 I'm grateful for this.
for V1 youcan download the Api connector to add in your google sheet extension
@@desmondwafula5246 you’re correct
HELLO BRO FROM NIGERIA GOD BLESSED YOU.
I HAVE WATCHED OTHER VIDEOS BUT COULDN'T FIND SOLUTION.
I THINK YOU SHOULD IMPROVE ON YOUR SEARCH TERM.
WHY DON'T YOU SAY "LINKING G OOGLESHEET WITH KOBOTOOLBOX" THIS IS THE SEARCH I HAVE BEEN USING UNTIL I FOUND YOU
Noted sir. God bless you