# \[Solved\] How do I create a new row in google sheets?
**URL:** https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656
**Category:** Questions about Thunkable X
**Created:** [March 27, 2022, 4:08pm UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656 "2022-03-27T16:08:35Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@sketch](https://community.thunkable.com/u/sketch)
#### Post date: [March 27, 2022, 4:08pm UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/1 "2022-03-27T16:08:35Z")
Hi all!
It’s been a while.
Im trying to create a task app with google sheet.
But When using google sheet it doesn’t create a new row:
Here are the blocks:
The sheet is public for everyone to acces.
Thanks
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [March 27, 2022, 4:45pm UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/2 "2022-03-27T16:45:46Z")
Does this work in Thunkable Live on a mobile device?
Can you share a link to the Google Sheet? Does the Google Sheet allow edit access or only view access?
---
### Author:  [@sketch](https://community.thunkable.com/u/sketch)
#### Post date: [March 27, 2022, 5:24pm UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/3 "2022-03-27T17:24:47Z")
> [@tatiang](#):
>
> Does this work in Thunkable Live on a mobile device?
No it doesn’t
> [@tatiang](#):
>
> Can you share a link to the Google Sheet?
[https://docs.google.com/spreadsheets/d/1QqxNEwwXtG0X8RtMJSjoY1KK4W2409fOWG8qeyzeNBE/edit?usp=drivesdk](https://docs.google.com/spreadsheets/d/1QqxNEwwXtG0X8RtMJSjoY1KK4W2409fOWG8qeyzeNBE/edit?usp=drivesdk)
> [@tatiang](#):
>
> Does the Google Sheet allow edit access
Yes
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [March 27, 2022, 6:17pm UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/4 "2022-03-27T18:17:25Z")
I just checked and it seems **All Okay**
See this
The sheet
The blocks
Can you try again and and check that the Google sheet has the updates I made?
---
### Author:  [@sketch](https://community.thunkable.com/u/sketch)
#### Post date: [March 27, 2022, 6:26pm UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/5 "2022-03-27T18:26:03Z")
Thanks @muneer it still doesn’t work:/
Here is the project link: [Thunkable](https://x.thunkable.com/copy/7e3ffda692c4e4b7197de5bfddcf3ec2)
> [@muneer](#):
>
> Can you try again and and check that the Google sheet has the updates I made?
The sheet is updated,
But nothing gets loaded in the app
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [March 27, 2022, 6:32pm UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/6 "2022-03-27T18:32:42Z")
> [@sketch](#):
>
> [https://docs.google.com/spreadsheets/d/1QqxNEwwXtG0X8RtMJSjoY1KK4W2409fOWG8qeyzeNBE/edit?usp=drivesdk](https://docs.google.com/spreadsheets/d/1QqxNEwwXtG0X8RtMJSjoY1KK4W2409fOWG8qeyzeNBE/edit?usp=drivesdk)
It’s crashing as soon as I try to type in the text input box.
Okay, if I tap the New Task button, nothing gets added to Google Sheets.
**Edit:** Task is a local data source, **not** a Google Sheet. You need to add the Google Sheet as a data source. Google Sheets have a green icon but yours does not:
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [March 27, 2022, 6:40pm UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/7 "2022-03-27T18:40:57Z")
> [@sketch](#):
>
> Here is the project link: [Thunkable](https://x.thunkable.com/copy/7e3ffda692c4e4b7197de5bfddcf3ec2)
It is unfortunate that once you remix a project links to Data Sources are reset to Local. I tried my side and it’s working for me.
---
### Author:  [@sketch](https://community.thunkable.com/u/sketch)
#### Post date: [March 27, 2022, 6:42pm UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/8 "2022-03-27T18:42:36Z")
Did you downloaded it and it Worked?
That’s odd.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [March 27, 2022, 6:45pm UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/9 "2022-03-27T18:45:14Z")
Let me explain more.
You cannot initialize a variable using `Data Source` blocks. So this
will result with a value of **null** which hinders your `create row` code from finishing.
This assignment must be done in `Screen Opens` block.
---
### Author:  [@sketch](https://community.thunkable.com/u/sketch)
#### Post date: [March 27, 2022, 6:50pm UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/10 "2022-03-27T18:50:20Z")
Hmmm that’s new for new for me.
Guess i’m never to old to learn something new😅
Anyways it’s working thanks!!
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [March 27, 2022, 6:52pm UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/11 "2022-03-27T18:52:52Z")
> [@sketch](#):
>
> Guess in never to old to kearn something new
I’m still learning… We’re all students in the school of life.
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [March 28, 2022, 1:15am UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/12 "2022-03-28T01:15:16Z")
@Muneer, your question implied that YOUR blocks had somehow updated the google sheet of @sketch - i was scratching my head wondering how you did that.
i’ve also verified that once you remix, the connection to the google sheet becomes a connection to local storage.
i have several questions about the use of google sheets in thunkable though.
1. if my app connects to my google sheet - can i distribute it - as apk - and will the person who installs it also have access to the (only) version of my google sheet?
2. do i have to mark my google sheet editable? (if the app creates a row)
3. does this also work if it’s a webapp and i send the link to someone?
4. how would it handle 2 users trying to add new (different) rows to my google sheet?
5. or is google sheet useful mostly as a browsable object?
thanks
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [March 28, 2022, 2:30am UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/13 "2022-03-28T02:30:06Z")
Hi @manyone
The first time I actually requested @sketch to check, I made my own project and connected to his Google sheet because he made it available as a sharable resource.
The issue of converting the sheet to local table when remix, I have not went into more details in this subject, if you are a PRO member then you can share the project with an option to **share** your sources too.
Now, for your questions:
> [@manyone](#):
>
> if my app connects to my google sheet - can i distribute it - as apk - and will the person who installs it also have access to the (only) version of my google sheet?
Yes, you can. You need to make your sheet sharable and editable for the APK to run as expected.
> [@manyone](#):
>
> do i have to mark my google sheet editable? (if the app creates a row)
Yes, you need to.
> [@manyone](#):
>
> does this also work if it’s a webapp and i send the link to someone?
Yes, it will/should work.
> [@manyone](#):
>
> how would it handle 2 users trying to add new (different) rows to my google sheet?
Thunkable does not manage multiuser tasks but in practice, if you do not have lots of concurrent users, then it should work but you will have to keep in mind the possibility of two users trying to commit data to the sheet simultaneously.
> [@manyone](#):
>
> or is google sheet useful mostly as a browsable object?
The sheet can manage edits but will not manage a situation like filtering data from one sheet to another while your app displays the filtered data because the other user will overwrite the content of the filtered sheet which would result in an unpredictable behavior.
Hope to have answered your queries.
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [March 28, 2022, 2:34am UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/14 "2022-03-28T02:34:49Z")
> [@muneer](#):
>
> The first time I actually requested @lukehoogenboom0i to check, I made my own project and connected to his Google sheet because he made it available as a sharable resource.
did you connect to his copy? how do you that? i also had a link to the google sheet but i couldnt figure out how to add a google sheet data source that points to a url.
or did you make a copy of the sheet and upload it to your google drive and connect to it as if it were yours?
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [March 28, 2022, 2:36am UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/15 "2022-03-28T02:36:41Z")
thank you! you have answered all my questions!
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [March 28, 2022, 2:41am UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/16 "2022-03-28T02:41:14Z")
> [@manyone](#):
>
> did you connect to his copy?
Yes.
You need to trick the system. First click on the link provided to view the sheet. Keep it open.
Now go to Thunkable and add the sheet as a new `Data Source`. You should see the sheet name in the list of available sheet after you click on the `select sheet` button.
However, I noticed that if I try to switch to the `Blocks` screen, I get nothing and had to close the project and open it again to be able to work normally.
The shared sheet has to be editable for the connection to work. If the sheet is read only then you will need to make a copy and work with the copy made.
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [March 28, 2022, 2:45am UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/17 "2022-03-28T02:45:40Z")
that’s the option i didnt try! nice trick! if the app only reads the sheet , maybe you don’t need to set the sheet as editable.
for example i can share my jokes google sheet and a simple thunkable to read the sheet - anybody should be able to do your trick and make the app working? i want to try later.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [March 28, 2022, 2:47am UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/18 "2022-03-28T02:47:30Z")
> [@manyone](#):
>
> i want to try later.
Yes why not. I will be happy to try it.
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [March 28, 2022, 2:55am UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/19 "2022-03-28T02:55:17Z")
very nice of you.
here’s my jokes sheet (with permission to view only)
> **[jokes](https://docs.google.com/spreadsheets/d/1hpnL7F_n_nSH0X46pbjDz4h58S4KjQ3PyPFsZYRAh2g/edit?usp=sharing)**
>
> Sheet1
>
> id,title,joke
> tm2lof,My girlfriend shouted at me, “You’re always acting like a detective. I want to split up!" Eyes growing wide, I replied...,"Great idea! We can cover more ground that way!"
> tmz139,So I was looking up popular pornographic...
and here’s the joke\_reader
[https://x.thunkable.com/copy/5a5eb5fba6f380d9d1a9556a8ccbb109](https://x.thunkable.com/copy/5a5eb5fba6f380d9d1a9556a8ccbb109)
it starts with a listviewer- click item to view the punchline.
thanks for testing.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [March 28, 2022, 5:54am UTC](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656/20 "2022-03-28T05:54:27Z")
I checked that and all works OK from both the computer and the mobile with one classic issue. In screen 2 you are showing the joke in a `Label` which supposed to scroll to see the rest of the joke. In the computer it scrolls, in the mobile it doesn’t.
[Next page](https://community.thunkable.com/t/solved-how-do-i-create-a-new-row-in-google-sheets/1804656.md?page=2)