# Save Variable to Google Sheets

**URL:** https://community.thunkable.com/t/save-variable-to-google-sheets/1314159
**Category:** Questions about Thunkable X
**Tags:** beginner
**Created:** [May 29, 2021, 12:58am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159 "2021-05-29T00:58:54Z")
**Posts on this page:** 14
**Page:** 1

<div class="post-metadata">

### Author: ![nthon255](https://avatars.discourse-cdn.com/v4/letter/n/a87d85/32.png) [@nthon255](https://community.thunkable.com/u/nthon255)
#### Post date: [May 29, 2021, 12:58am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/1 "2021-05-29T00:58:54Z")

</div>

Hello!  
I am creating a Reminder’s app where the user can save Reminders, so instead of using Air table I wanted to use Google Sheets.

The Logic I want is for the Variable (Reminders - which holds the reminder text input and a timestamp) to be saved into a google sheet with the headers : Reminders (the text input) and Email (to identify which user wrote which reminder)

I am really confused, please let me know if there is a way to do this!

---

<div class="post-metadata">

### Author: ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)
#### Post date: [May 29, 2021, 1:28am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/2 "2021-05-29T01:28:47Z")

</div>

So I’d think about having a column with email addresses and then one or more columns with your reminder text (probably two - one for the text and one for the timestamp)?

The question is how are you going to make sure the user enters their email address (and not someone else’s)? Also, if you have a lot of users, finding the row(s) belonging to your user can be slow, so that’s a potential concern.

You certainly /can/ do it with Google Sheets, but this sounds more like a job for Firebase, which is faster, has a user sign-in function, and lets you grab just one user’s data easily.

---

<div class="post-metadata">

### Author: ![nthon255](https://avatars.discourse-cdn.com/v4/letter/n/a87d85/32.png) [@nthon255](https://community.thunkable.com/u/nthon255)
#### Post date: [May 29, 2021, 1:35am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/3 "2021-05-29T01:35:06Z")

</div>

Thank you!

I do actually have Firebase for the Authentication part of my app (the sign-in, sign up and reset password). But one of my features is the reminders screen.

Also the timestamp I made manually was created by following a Youtube Tutorial : [9. Thunkable: Code a Timestamp Function in a Social App - YouTube](https://www.youtube.com/watch?v=nxJ0X38SLAM)

So what I ended up doing is creating a Sheet with Email and Reminder - so I can show just the reminder of the user ONLY!!

 ![Screen Shot 2021-05-28 at 9.33.55 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/6/86cd638bbf573982aaa4ce77208b08b4593f471f.png)

Thanks for your help Much appreciated!!

---

<div class="post-metadata">

### 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: [May 29, 2021, 2:39am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/4 "2021-05-29T02:39:00Z")

</div>

I’m making something very similar. It’s a Photo Journal app. Users sign in with Firebase and then add a photo, description, and automated date/time stamp. I was storing the data in Firebase under each user ID which works really well for that kind of data record but I ended up switching to a local DB (data base) because I wanted to be able to use a Data Viewer List to display the info.

---

<div class="post-metadata">

### Author: ![nthon255](https://avatars.discourse-cdn.com/v4/letter/n/a87d85/32.png) [@nthon255](https://community.thunkable.com/u/nthon255)
#### Post date: [May 29, 2021, 9:11am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/5 "2021-05-29T09:11:49Z")

</div>

I’ve gotten how to save Data to google sheets, but I haven’t been able to show that data onto a list viewer!

 ![Screen Shot 2021-05-29 at 5.10.26 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/1/21262a099377d1e9120b603cfc156a30b3a331d0.png)  
(I didn’t include email - I’m still trying to find a way)

Thank you!

---

<div class="post-metadata">

### 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: [May 29, 2021, 10:01am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/6 "2021-05-29T10:01:46Z")

</div>

Why are you using [sheetdb.io](http://sheetdb.io) instead of connecting to the Google sheet from the `Data Sources` option?

Using the `Data Sources` option allows you to read from and write to Google sheet using Thunkable blocks.

---

<div class="post-metadata">

### Author: ![nthon255](https://avatars.discourse-cdn.com/v4/letter/n/a87d85/32.png) [@nthon255](https://community.thunkable.com/u/nthon255)
#### Post date: [May 29, 2021, 10:03am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/7 "2021-05-29T10:03:47Z")

</div>

I’ve tried, but I wasn’t able to successfully save data to Google Sheets (let alone change and update it) Which is why I did it this way.

If you have time, would you be able to create an example of a text input being saved to any DB and then being shown into a list viewer. (Making sure the user is only able to see their Reminders)?

Thank you,  
either way It helped a lot

---

<div class="post-metadata">

### Author: ![codeswept](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/codeswept/32/87755_2.png) [@codeswept](https://community.thunkable.com/u/codeswept)
#### Post date: [May 29, 2021, 10:08am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/8 "2021-05-29T10:08:07Z")

</div>

This is possible using the Data Viewer list, and Local DB. Could you give me a few moments to make an example for you?

---

<div class="post-metadata">

### Author: ![nthon255](https://avatars.discourse-cdn.com/v4/letter/n/a87d85/32.png) [@nthon255](https://community.thunkable.com/u/nthon255)
#### Post date: [May 29, 2021, 10:11am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/9 "2021-05-29T10:11:06Z")

</div>

Yes, Thank you!  
But you can’t delete anything from the Data Viewer list - or am I wrong?

As I need to be able to delete select Reminders the user wants.

---

<div class="post-metadata">

### Author: ![codeswept](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/codeswept/32/87755_2.png) [@codeswept](https://community.thunkable.com/u/codeswept)
#### Post date: [May 29, 2021, 10:11am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/10 "2021-05-29T10:11:40Z")

</div>

Nope, you definitely _can_ delete reminders. Let me create an example for you. Give me 5 minutes.

---

<div class="post-metadata">

### Author: ![codeswept](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/codeswept/32/87755_2.png) [@codeswept](https://community.thunkable.com/u/codeswept)
#### Post date: [May 29, 2021, 10:17am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/11 "2021-05-29T10:17:49Z")

</div>

[https://x.thunkable.com/copy/a0786a219cb58cd6efc1f91e0f396236](https://x.thunkable.com/copy/a0786a219cb58cd6efc1f91e0f396236)

Here’s a basic app. Swipe any item to delete it.

---

<div class="post-metadata">

### Author: ![nthon255](https://avatars.discourse-cdn.com/v4/letter/n/a87d85/32.png) [@nthon255](https://community.thunkable.com/u/nthon255)
#### Post date: [May 29, 2021, 10:20am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/12 "2021-05-29T10:20:58Z")

</div>

Thank you Soooo much!!!  
I have an Assignment due today - on my app and this helped so much!!

Thanks a million!!!

---

<div class="post-metadata">

### Author: ![codeswept](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/codeswept/32/87755_2.png) [@codeswept](https://community.thunkable.com/u/codeswept)
#### Post date: [May 29, 2021, 10:21am UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/13 "2021-05-29T10:21:51Z")

</div>

No problem! Glad it helped you.

---

<div class="post-metadata">

### 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, 1:22pm UTC](https://community.thunkable.com/t/save-variable-to-google-sheets/1314159/14 "2024-11-08T13:22:14Z")

</div>


