# Export List Values to Google Sheet **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [August 18, 2020, 2:27pm UTC](https://community.thunkable.com/t/export-list-values-to-google-sheet/751315 "2020-08-18T14:27:05Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![gregdotcom77oi](https://avatars.discourse-cdn.com/v4/letter/g/ecb155/32.png) [@gregdotcom77oi](https://community.thunkable.com/u/gregdotcom77oi)\ **Post date:** [August 18, 2020, 2:27pm UTC](https://community.thunkable.com/t/export-list-values-to-google-sheet/751315/1 "2020-08-18T14:27:05Z")
I’m trying to export values stored in a list variable to my Google Sheet but I can only see a function for ‘create row’ not ‘create list’. Is this possible? If so, how? Many thanks! ![Screenshot 2563-08-18 at 21.26.23](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/a/0a63a6b30c268106a50f5cd4ca1a879036d73bfb.png) ---
**Author:** ![gregdotcom77oi](https://avatars.discourse-cdn.com/v4/letter/g/ecb155/32.png) [@gregdotcom77oi](https://community.thunkable.com/u/gregdotcom77oi)\ **Post date:** [August 18, 2020, 2:54pm UTC](https://community.thunkable.com/t/export-list-values-to-google-sheet/751315/2 "2020-08-18T14:54:21Z")
No worries . . . I’ve figured it out 🤓👍🏻 ---
**Author:** ![gregdotcom77oi](https://avatars.discourse-cdn.com/v4/letter/g/ecb155/32.png) [@gregdotcom77oi](https://community.thunkable.com/u/gregdotcom77oi)\ **Post date:** [August 18, 2020, 3:14pm UTC](https://community.thunkable.com/t/export-list-values-to-google-sheet/751315/3 "2020-08-18T15:14:20Z")
Actually, no I haven’t 🤦🏻‍♂️ ---
**Author:** ![gregdotcom77oi](https://avatars.discourse-cdn.com/v4/letter/g/ecb155/32.png) [@gregdotcom77oi](https://community.thunkable.com/u/gregdotcom77oi)\ **Post date:** [August 18, 2020, 3:32pm UTC](https://community.thunkable.com/t/export-list-values-to-google-sheet/751315/4 "2020-08-18T15:32:34Z")
I tried using the ‘for each J in list’ function but I have multiple lists in a row and need the results to be returned in the same row for each Listviewer i.e orders\_list1 row 1 → Google row 2 column A, orders\_list2 row 1 → Google row 2 Column B etc. ![Screenshot 2563-08-18 at 22.26.15](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/e/bef3d936b3daed088fc99ef01de88a44e0c3b1c2.png) ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [August 19, 2020, 5:01am UTC](https://community.thunkable.com/t/export-list-values-to-google-sheet/751315/5 "2020-08-19T05:01:28Z")
> [@gregdotcom77oi](#): > > thanks! > > ![Screenshot 2563-08-18 at 21.26.23](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/a/0a63a6b30c268106a50f5cd4ca1a879036d73bfb.png) Could you use the ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/9/f9b44a76c26984184c20c29713e5948f1f721f27.jpeg) ? No, it works too fast to function appropriately without a wait block. But, you can make a function that Calls itself after each row of data is saved until no data are left to save to the sheet. Read about recursion. I will post an example next week when I’m back from vacation. 🙃 ---
**Author:** ![gregdotcom77oi](https://avatars.discourse-cdn.com/v4/letter/g/ecb155/32.png) [@gregdotcom77oi](https://community.thunkable.com/u/gregdotcom77oi)\ **Post date:** [August 19, 2020, 7:33am UTC](https://community.thunkable.com/t/export-list-values-to-google-sheet/751315/6 "2020-08-19T07:33:33Z")
Awesome, thanks. I’ll check it out 👍🏻 ---
**Author:** ![gregdotcom77oi](https://avatars.discourse-cdn.com/v4/letter/g/ecb155/32.png) [@gregdotcom77oi](https://community.thunkable.com/u/gregdotcom77oi)\ **Post date:** [August 21, 2020, 6:54am UTC](https://community.thunkable.com/t/export-list-values-to-google-sheet/751315/7 "2020-08-21T06:54:25Z")
I got it working in the end 🤓👍🏻 ![Screenshot 2563-08-21 at 13.43.43](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/3/e34ab7ba54836b0a5bd254b44ad81b80c4fa8923.png) ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 12:24pm UTC](https://community.thunkable.com/t/export-list-values-to-google-sheet/751315/8 "2024-11-08T12:24:41Z")