# Storing data to be reflected on google sheets **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** firebase\ **Created:** [December 10, 2021, 6:14am UTC](https://community.thunkable.com/t/storing-data-to-be-reflected-on-google-sheets/1650929 "2021-12-10T06:14:34Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![teamzaddysn9m](https://avatars.discourse-cdn.com/v4/letter/t/e480ec/32.png) [@teamzaddysn9m](https://community.thunkable.com/u/teamzaddysn9m)\ **Post date:** [December 10, 2021, 6:14am UTC](https://community.thunkable.com/t/storing-data-to-be-reflected-on-google-sheets/1650929/1 "2021-12-10T06:14:34Z")
Hi, may I ask how will I be able to utilise the real-time database on THUNKABLE to store my live data from the THUNKABLE application to be reflected on google sheets for graphing reasons? As I have researched online, the examples I found are all using a different interface from mine. I am using this interface (SCREENSHOT 1 & 2) while the examples are using the interface (SCREENSHOT 3 & 4). ![Screenshot 2021-12-10 at 2.05.16 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/a/7a2eefbd12d4907c2a28eef0cb0629e713bb548d.png) ![Screenshot 2021-12-10 at 2.05.25 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/f/6f7521120e9d35bb25646fe3d8514c0098ad8ec6.png) ![Screenshot 2021-12-10 at 2.10.04 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/6/16f4434273538b54a6e82cc3920a746c1fc9641d.png) ![Screenshot 2021-12-10 at 2.12.24 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/a/1a8f91cc179b89597c39b30ab98a04768ad81f52.png) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [December 10, 2021, 6:34am UTC](https://community.thunkable.com/t/storing-data-to-be-reflected-on-google-sheets/1650929/2 "2021-12-10T06:34:22Z")
If you want to graph things in Google Sheets, why not store your data directly in Google Sheets? If you want to use Firebase, you can do that with cloud variables. Here are some examples of that: > [@Replace GET or SAVE Blocks with cloud variables](https://community.thunkable.com/t/replace-get-or-save-blocks-with-cloud-variables/975738): > > I just discovered a VERY simple and fast way to get and set Firebase data without using the GET or SAVE blocks (which has all sorts of asynchronous issues). The 2 any button click blocks below return the same data. Just put the GET block KEY variable into the CLOUD variable name and PRESTO. You have a synchronous call to firebase! Similarly, you can set data anywhere in the JSON Hierarchy using cloud variables. Both of the examples below update Firebase, but the CLOUD based solution… You don’t need a special block for accessing Firebase data… you just use the blocks in the Variables drawer. The **name** of the cloud variable is the path to the data in Firebase. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 10, 2021, 10:35am UTC](https://community.thunkable.com/t/storing-data-to-be-reflected-on-google-sheets/1650929/3 "2021-12-10T10:35:23Z")
To connect your Thunkable app with a Google sheet you need to go to Data tab: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/9/99394abd534270a14c53b213b6daceaf5aed88a8.png) Click the **+** to add a new `Data Source` ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/b/0b35395444d1bffa591645e2b89d08baf4470d66.png) If the Google sheet is already added then select it or click **Create New** to link the Google sheet with your app. ---
**Author:** ![teamzaddysn9m](https://avatars.discourse-cdn.com/v4/letter/t/e480ec/32.png) [@teamzaddysn9m](https://community.thunkable.com/u/teamzaddysn9m)\ **Post date:** [December 10, 2021, 10:43am UTC](https://community.thunkable.com/t/storing-data-to-be-reflected-on-google-sheets/1650929/4 "2021-12-10T10:43:21Z")
I am asking help with real time data base, not help with adding data source (google sheet) into my thunkable application. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 10, 2021, 11:01am UTC](https://community.thunkable.com/t/storing-data-to-be-reflected-on-google-sheets/1650929/5 "2021-12-10T11:01:40Z")
When you say **realtime database** do you mean Firebase? If this is what you mean then read the post of @tatiang. He explained what to do and shared a post giving detailed explanation. ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [December 10, 2021, 3:12pm UTC](https://community.thunkable.com/t/storing-data-to-be-reflected-on-google-sheets/1650929/6 "2021-12-10T15:12:07Z")
You can see some examples of using Firebase here: [![](https://img.youtube.com/vi/KvFvSkG6G-k/maxresdefault.jpg "Cloud Variables - Save User Data to the Cloud in Thunkable Drag and Drop UI") ](https://www.youtube.com/watch?v=KvFvSkG6G-k) ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [March 10, 2022, 3:12pm UTC](https://community.thunkable.com/t/storing-data-to-be-reflected-on-google-sheets/1650929/7 "2022-03-10T15:12:38Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.