# Latest Thunkable Release incl Google Spreadsheets (Dec 6)
**URL:** https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660
**Category:** Announcements
**Tags:** spreadsheets, cloudstitch
**Created:** [December 7, 2016, 12:14am UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660 "2016-12-07T00:14:55Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@albert](https://community.thunkable.com/u/albert)
#### Post date: [December 7, 2016, 12:14am UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/1 "2016-12-07T00:14:55Z")
Hey Thunkers!
Have you ever wanted to use Google spreadsheets as a source or a back-end for you app? Thanks to a new component powered by Cloudstitch, you can.
**[Click here to view a sample Spreadsheets app project!](http://app.thunkable.com/?locale=en&repo=share.thunkableapps.com/templates/HelloSpreadsheets.asc)**
With Cloudstitch, anyone can use a Google spreadsheet (or a Microsoft 360 spreadsheet) to store data, powering interesting features like dynamically changing listpickers to easy to understand mapping databases. (Cloudstitch requires you to manually sync your spreadsheet to your app unless you upgrade services).
More details on how you might implement it in [the documentation here](http://thunkable.com/reference/components/experimentation.html).
Can’t wait to see what you thunk!
Albert @ Thunkable
---
### Author:  [@ted\_copy](https://community.thunkable.com/u/ted_copy)
#### Post date: [December 7, 2016, 1:36am UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/2 "2016-12-07T01:36:53Z")
Hi Thunkers,
Ted from Cloudstitch here. Just wanted to say hello and thanks to the Thunkable team for adding this support! We love what you all are doing and are excited to help you build some awesome apps powered by spreadsheets.
Don’t hesitate to ping us for support on this message board or by email at [hello@cloudstitch.com](mailto:hello@cloudstitch.com).
❤
The Cloudstitch Team
---
### Author:  [@mannankhanabdul](https://community.thunkable.com/u/mannankhanabdul)
#### Post date: [December 7, 2016, 7:55am UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/3 "2016-12-07T07:55:50Z")
Useful Feature… Thanks
---
### Author:  [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [December 7, 2016, 12:57pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/4 "2016-12-07T12:57:13Z")
Looking forward to trying out this feature. I also really like that clicking the link clones the project and opens it directly in **my** Thunkable. Excellent UX, thanks @albert 🙂
---
### Author:  [@Ali\_Aydin](https://community.thunkable.com/u/Ali_Aydin)
#### Post date: [December 7, 2016, 7:31pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/5 "2016-12-07T19:31:40Z")
Can we get sorted list from spreadsheets?
For leaderboard like top 250 player.I can sort it in client but can i get it from cloudstitch?
@ted_copy
---
### Author:  [@ted\_copy](https://community.thunkable.com/u/ted_copy)
#### Post date: [December 7, 2016, 11:13pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/6 "2016-12-07T23:13:31Z")
Hi @Ali_Aydin,
You can! We try to leverage the spreadsheet whenever possible, so the way to do it is with a spreadsheet trick. I’ve shared [a spreadsheet here](https://docs.google.com/spreadsheets/d/1eUpUI13FUrOoqzNAp78O_tj-hLP-FeM7ldXxTcbJUxs/edit?usp=sharing) with an example.
Assume you’ve got the raw data in a worksheet called **RawData**. Just create a _second_ worksheet called **Sorted** that will always project a sorted version of the raw data.
- In cell A1 of that new sheet, use the formula **=ArrayFormula(RawData!A1:Z1)** to copy the header row.
- In cell A2 of that new sheet, use the formula **=SORT(RawData!A2:Z, 1, true)** to copy (and sort) everything else.
You could use a similar trick to create a third worksheet that only grabs the top 250 of your leader board by placing the formula **=ArrayFormula(Sorted!A1:Z251)** in cell A1. With this approach you’d have three worksheets: the raw data, the sorted data, and the top leaders.
Remember you’ll have to sync your spreadsheet in Cloudstitch to publish it to the API (or set it to auto-sync). And note that some of the references in the arguments above depend on the particulars of your spreadsheet.
Then just use the sorted data inside Thunkable. You can grab the data from only one worksheet by appending **/WorksheetName** to the URL see for the API Endpoint in the Thunkable editor
---
### Author:  [@Ali\_Aydin](https://community.thunkable.com/u/Ali_Aydin)
#### Post date: [December 7, 2016, 11:59pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/7 "2016-12-07T23:59:05Z")
Oh thats Good.
I will try it with firebase and coded it but this Method is easy than my Method and got better ui for control.
İ will try it. Maybe i switch to this Method but first i need learn more about it.Like how to use and limits 🙂
---
### Author:  [@SaabirSadik](https://community.thunkable.com/u/SaabirSadik)
#### Post date: [December 8, 2016, 3:35pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/8 "2016-12-08T15:35:47Z")
Thanks team Thunkable for adding this great feature.
---
### Author:  [@111](https://community.thunkable.com/u/111)
#### Post date: [March 13, 2017, 9:01pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/9 "2017-03-13T21:01:28Z")
I want your help about this trick i add successfully the formulas and my result is :
Ren 23
Stimpy 34
Larry 87
Curly 56
Moe 76
when i add one more to the Sheet1 for exaple Moe 10 that adds a second Moe row to Sheet2
how can the second to added to correct row?
---
### Author:  [@yoohz17](https://community.thunkable.com/u/yoohz17)
#### Post date: [February 18, 2018, 1:48pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/10 "2018-02-18T13:48:51Z")
Hi @albert is it possible to edit existing data on spreadsheet?
for example if you want to update your phone number is it possible?
Thanks
---
### Author:  [@albert](https://community.thunkable.com/u/albert)
#### Post date: [February 20, 2018, 9:40pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/11 "2018-02-20T21:40:55Z")
Unfortunately, I think you can simply add and query a spreadsheet at the moment – updating and deleting data is not possible as far as I know;
Albert
---
### Author:  [@Shona\_Creations](https://community.thunkable.com/u/Shona_Creations)
#### Post date: [March 29, 2018, 8:01pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/12 "2018-03-29T20:01:56Z")
when we update data then user receive notification ? if not then howz i send notification when i update data .@albert
---
### Author:  [@Shivendra\_Kr\_Sahu](https://community.thunkable.com/u/Shivendra_Kr_Sahu)
#### Post date: [March 29, 2018, 8:11pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/13 "2018-03-29T20:11:35Z")
yet time not possibl
---
### Author:  [@Shona\_Creations](https://community.thunkable.com/u/Shona_Creations)
#### Post date: [March 29, 2018, 8:12pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/14 "2018-03-29T20:12:45Z")
thx bro
---
### Author:  [@B\_Hdez](https://community.thunkable.com/u/B_Hdez)
#### Post date: [April 14, 2018, 1:05pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/15 "2018-04-14T13:05:23Z")
> [@albert](#):
>
> Microsoft 360 spreadsheet
@ted_copy
1. where i can found information about **Microsoft 360 spreadsheet**? I just can work with Google drive.
2. working with Google; i just can upload data to Sheet1; i tryed changing name Sheet in Thunkable Project, but not work, continue uploading data to Sheet1.
Thx U in advanced.
---
### Author:  [@Technical\_Tadap](https://community.thunkable.com/u/Technical_Tadap)
#### Post date: [May 15, 2018, 12:08pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/16 "2018-05-15T12:08:40Z")
Hi ! Can you please help me with this issue I have Posted On Community?
[http://community.thunkable.com/t/need-support-with-spreadsheet-next-back-button/26297](http://community.thunkable.com/t/need-support-with-spreadsheet-next-back-button/26297)
---
### Author:  [@Raphael\_Silva](https://community.thunkable.com/u/Raphael_Silva)
#### Post date: [June 4, 2018, 1:53am UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/17 "2018-06-04T01:53:43Z")
Hi!
Is it safe to use Google spreadsheet as a database to store information like email and user passwords, or would it be better to use Firebase?
---
### Author:  [@B\_Hdez](https://community.thunkable.com/u/B_Hdez)
#### Post date: [June 6, 2018, 3:05pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/18 "2018-06-06T15:05:11Z")
Bad Support for Spreadsheet, few information, Cloudstich support does not respond.
we will wait for some trace of life…
---
### Author:  [@B\_Hdez](https://community.thunkable.com/u/B_Hdez)
#### Post date: [June 7, 2018, 2:52pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/19 "2018-06-07T14:52:33Z")
@ted_copy @albert @domhnallohanlon
Please, All conection of thunkable with spreadsheet cloudstich is Down !!!
Today 07/06/2018 09:45AM
---
### Author:  [@Shivendra\_Kr\_Sahu](https://community.thunkable.com/u/Shivendra_Kr_Sahu)
#### Post date: [June 7, 2018, 4:13pm UTC](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660/20 "2018-06-07T16:13:45Z")
its working for me in India
[Next page](https://community.thunkable.com/t/latest-thunkable-release-incl-google-spreadsheets-dec-6/660.md?page=2)