Hey, I have designed my form which helps me collect information on students and their assessments. The assessment section is collected based on the number of students with position loops and in this case, the data comes through as a download with 2 sheets. I intend to connect these to Google Sheets to automate the process of getting the data however I seem not to have found any tangible solution to doing this. Any support will be appreciated.
Welcome to the community, @BrianO! Exporting repeat groups to google sheet is not currently supported. But the community could advise you with some workarounds. Hence leaving this post open for the community to chime in.
Hi @BrianO, quick question do you have a outlook work/school account? because what i am going to suggest needs a premium feature. If you have you can do it by using Power Automate, You can send get request to kobo via power automate after that you can save the result to Google Drive and update it whenever you want or set an automatic update. I tested my solution and you can bring you data as two sheet
1 Like
Hello @osmanburcu I do have a work email. I am happy to explore this option
hi @BrianO,
Can you check if you have HTTP connector in Power automate because it is a premium connector that needs work or school account? If you are able to use this connector, the rest is easy i can explain
