# ODK Collect Form with Loops and Google Sheets **URL:** \ **Category:** Support\ **Created:** [August 25, 2017, 9:13pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556 "2017-08-25T21:13:18Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![jlsevillano](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/jlsevillano/32/2253_2.png) [@jlsevillano](https://forum.getodk.org/u/jlsevillano)\ **Post date:** [August 25, 2017, 9:13pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/1 "2017-08-25T21:13:18Z")
I have a form with loops. It runs ok with ODK Aggregate but when i try with Google Sheets, ODK Collect says: It's not support (loops) I'm using ODK Collect 1.9.1 Is it my fault? Any way to do it? ---
**Author:** ![Ronald\_Munjoma](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ronald_munjoma/32/1647_2.png) [@Ronald\_Munjoma](https://forum.getodk.org/u/Ronald_Munjoma)\ **Post date:** [August 26, 2017, 10:17am UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/2 "2017-08-26T10:17:03Z")
Hi @jlsevillano, Welcome to the ODK Forum and Community! Please use the below template for your post. That way community members get enough information to be in a better position to assist you. **What is the problem? Please be detailed.** **What ODK tool and version are you using? And on what device and operating system version?** **What steps can we take to reproduce the problem?** **What you have you tried to fix the problem?** **Anything else we should know or have? If you have a test form or screenshots or logs, attach here.** We would like to learn more about yourself, what you do, your interests, projects you are working … please [introduce yourself.](https://forum.getodk.org/t/introduce-yourself-here/6671) Whilst you are it, please add a profile picture. ---
**Author:** ![jlsevillano](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/jlsevillano/32/2253_2.png) [@jlsevillano](https://forum.getodk.org/u/jlsevillano)\ **Post date:** [August 26, 2017, 3:52pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/3 "2017-08-26T15:52:56Z")
**What is the problem? Please be detailed.** I have a form with loops. It runs ok with ODK Aggregate but when i try with Google Sheets, ODK Collect says: It’s not support (loops) **What ODK tool and version are you using? And on what device and operating system version?** I’m using ODK Collect 1.9.1 and Geo Data Collect 1.1.7 ( [https://play.google.com/store/apps/details?id=hosm.odk.collect.android](https://play.google.com/store/apps/details?id=hosm.odk.collect.android) ) I test it on Asus ASUS\_Z00AD - Android 5.0 **What steps can we take to reproduce the problem?** If you create a survey with loop and you decide to send the responses to Google Sheets, the ODK App display an error: name="google\_repeat\_error" and stop the sending. **Anything else we should know or have? If you have a test form or screenshots or logs, attach here.** I created and XLSX form and generate a XLS . Both uploaded into Google Drive (you need to add the submission url in settings tab). After that i configurated my ODK Collect App to connect to My Google Account (Google Drive/Google Sheets), get the Blank Form...collect data (with loop) and if you try to send the data...the app display the error. (I attach the XLS) > **[MEGA](https://mega.nz/#!Z4c2FSzC!h99u5g5YskldcHvgYazcvfFUt5T0ECCU0P5FRI6v4oA)** > > MEGA provides free cloud storage with convenient and powerful always-on privacy. Claim your free 20GB now ---
**Author:** ![Nader](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/nader/32/2015_2.png) [@Nader](https://forum.getodk.org/u/Nader)\ **Post date:** [August 26, 2017, 7:04pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/4 "2017-08-26T19:04:22Z")
I think the problem because in spreadsheet you don't have a conroller (ODK Aggregate) When we use spreadsheet It's like writing to excel file directly so each field in the form has one in the spreadsheet. But odk aggregate can parse loops then write the result in the database. ---
**Author:** ![jlsevillano](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/jlsevillano/32/2253_2.png) [@jlsevillano](https://forum.getodk.org/u/jlsevillano)\ **Post date:** [August 26, 2017, 7:18pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/5 "2017-08-26T19:18:49Z")
I test it with SMAP (like to ODK aggregate) and everything runs perfect. My intention is not use SMAP sever...try to use (only) Google Drive / Google Sheet. Of course, with SMAP if i export data (XLS format or CSV format) each loop generate 1 row. I'm going to try to write to excel file directly and on the reponses sheet with column names but I don't hope anything. ---
**Author:** ![jlsevillano](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/jlsevillano/32/2253_2.png) [@jlsevillano](https://forum.getodk.org/u/jlsevillano)\ **Post date:** [August 26, 2017, 7:27pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/6 "2017-08-26T19:27:16Z")
I tried writing directly and same error display. 😕 If you try it but with loop...you are going to have the error: > **[ODK Collect and Google Drive Integration to Store and Manage Your Data](https://www.google.com/earth/outreach/learn/odk-collect-and-google-drive-integration-to-store-and-manage-your-data/)** > > How to store and manage data you collect with ODK Collect in Google Drive. ---
**Author:** ![Nader](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/nader/32/2015_2.png) [@Nader](https://forum.getodk.org/u/Nader)\ **Post date:** [August 26, 2017, 7:32pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/7 "2017-08-26T19:32:08Z")
Am sorry my english is not good If you want to use loops i think you have to use Aggregate Server. Best regards ---
**Author:** ![jlsevillano](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/jlsevillano/32/2253_2.png) [@jlsevillano](https://forum.getodk.org/u/jlsevillano)\ **Post date:** [August 26, 2017, 7:44pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/8 "2017-08-26T19:44:01Z")
no problem my english is not good neither. I'm going to try Aggregate Server too. But I hope to do it directly with G Drive. Thanks! ---
**Author:** ![Nader](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/nader/32/2015_2.png) [@Nader](https://forum.getodk.org/u/Nader)\ **Post date:** [August 26, 2017, 8:06pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/9 "2017-08-26T20:06:31Z")
Your welcom Best regards ---
**Author:** ![Ronald\_Munjoma](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ronald_munjoma/32/1647_2.png) [@Ronald\_Munjoma](https://forum.getodk.org/u/Ronald_Munjoma)\ **Post date:** [August 28, 2017, 5:09pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/10 "2017-08-28T17:09:33Z")
Hi @jlsevillano, I think Google drive supports simple forms. I am on mobile right, I will confirm what is supported tomorrow ---
**Author:** ![Nader](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/nader/32/2015_2.png) [@Nader](https://forum.getodk.org/u/Nader)\ **Post date:** [August 28, 2017, 5:48pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/11 "2017-08-28T17:48:49Z")
Hi Ronald, thank you we will appreciate that Best Regards ---
**Author:** ![jlsevillano](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/jlsevillano/32/2253_2.png) [@jlsevillano](https://forum.getodk.org/u/jlsevillano)\ **Post date:** [August 28, 2017, 6:00pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/12 "2017-08-28T18:00:13Z")
Thanks a lot!!! Best Regards ---
**Author:** ![LN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ln/32/1605_2.png) [@LN](https://forum.getodk.org/u/LN)\ **Post date:** [August 28, 2017, 6:58pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/13 "2017-08-28T18:58:02Z")
The Google Sheets integration does not currently support loops/repeats. If you'd like to see that implemented, please vote on the feature description at [Repeat groups and google sheets upload - #2 by LN](https://forum.getodk.org/t/repeat-groups-and-google-sheets-upload/6677/2) and/or see if you can find anyone who would like to contribute it! ---
**Author:** ![jlsevillano](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/jlsevillano/32/2253_2.png) [@jlsevillano](https://forum.getodk.org/u/jlsevillano)\ **Post date:** [August 28, 2017, 7:39pm UTC](https://forum.getodk.org/t/odk-collect-form-with-loops-and-google-sheets/9556/14 "2017-08-28T19:39:50Z")
Thanks Hélène...i did it... If i ll find someone to contribute....I'll say here. Br,