# Simple Google Sheet - writing a row

**URL:** <https://community.thunkable.com/t/simple-google-sheet-writing-a-row/1789932>\
**Category:** Questions about Thunkable X\
**Tags:** solved, beginner\
**Created:** [March 18, 2022, 6:16am UTC](https://community.thunkable.com/t/simple-google-sheet-writing-a-row/1789932 "2022-03-18T06:16:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![joshmf0s](https://avatars.discourse-cdn.com/v4/letter/j/2bfe46/32.png) [@joshmf0s](https://community.thunkable.com/u/joshmf0s)\
**Post date:** [March 18, 2022, 6:16am UTC](https://community.thunkable.com/t/simple-google-sheet-writing-a-row/1789932/1 "2022-03-18T06:16:52Z")

</div>

TLDR: Use Chrome, not Opera, when editing Thunkable.

PROBLEM:

I’m new to Thunkable (from [bubble.io](http://bubble.io)), trying to add a new row to a Google Sheet. I’ve successfully connected my Google Sheet as a data source, and wrote the code in the image below. Thunkable can read the header row. But when I try to add a row, nothing happens. (I see debug text “begin writing…” , but not “wrote Google Sheet”. The Google Sheet doesn’t change).

I demo the problem in a video at [https://www.dropbox.com/s/1f50r0gmbiewp7g/Thunkable%20-%20Opera%202022-03-18%2017-17-27.mp4?dl=0](https://www.dropbox.com/s/1f50r0gmbiewp7g/Thunkable%20-%20Opera%202022-03-18%2017-17-27.mp4?dl=0)

1. Am I doing this right? Is there something else I need to do, to push data from Thunkable to Google Sheet?

2. how can I debug this? Is there any way to see if a block is crashed, throwing errors, is frozen or stalled, is waiting for an external call to complete, or has silently failed? Is there an log or any debugging tools? I looked in “Debugging” in Docs and iddn’t see anything like that.

3. is this likely to be a sync problem? or access problem? I refreshed sync in Data Sources. That seems to work fine (when I change header rows in sheets, Thunkable shows the change)

4. any tutorials or guides on writing to google sheets? I didn’t see much on the forum, docs, Youtube (mostly folks using 3rd party APIs instead of Thunkable’s built-in access)

I’m about to give up and struggle through learning Firebase, which everyone here seems to prefer, but I prefer to stay with Google Sheets because I know Google Apps Script, and my users already know Sheets. (I have read that I can export Firebase to Google Sheets, but would like to avoid an unnecessary step)

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/d/8d7c36be3754b995f73a6dad1f0ccc71b8350ce8.png)

---

<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:** [March 18, 2022, 6:23am UTC](https://community.thunkable.com/t/simple-google-sheet-writing-a-row/1789932/2 "2022-03-18T06:23:18Z")

</div>

What happens if you replace the UID value in the create row block with a text string (e.g. “none”)?

If that works, then you probably need to check for a null value in your stored variable:

> [@Store variable stopping my app](https://community.thunkable.com/t/store-variable-stopping-my-app/1528439/4):
>
> Stored variables are a little tricky because they start out with a null value. So you have to do when screen opens → if stored variable = null → set stored variable to [some value]. That value can be zero (0) or an empty string ("") or any other value.

---

<div class="post-metadata">

**Author:** ![joshmf0s](https://avatars.discourse-cdn.com/v4/letter/j/2bfe46/32.png) [@joshmf0s](https://community.thunkable.com/u/joshmf0s)\
**Post date:** [March 18, 2022, 7:06am UTC](https://community.thunkable.com/t/simple-google-sheet-writing-a-row/1789932/3 "2022-03-18T07:06:21Z")

</div>

Thanks for suggesting something.

I replaced the stored variable block with a “none” text block, and it still didn’t work.

Any other suggestions?

Any thoughts on my question #2 about debugging? or #4, on existing tutorials for using create row to write to Google Sheets?

---

<div class="post-metadata">

**Author:** ![joshmf0s](https://avatars.discourse-cdn.com/v4/letter/j/2bfe46/32.png) [@joshmf0s](https://community.thunkable.com/u/joshmf0s)\
**Post date:** [March 18, 2022, 7:37am UTC](https://community.thunkable.com/t/simple-google-sheet-writing-a-row/1789932/4 "2022-03-18T07:37:08Z")

</div>

I tried it in Chrome, on a hunch, and it worked!

So, I think Opera is not fully supported.

I hope that goes on a FAQ somewhere, if it’s correct.

---

<div class="post-metadata">

**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:** [June 16, 2022, 7:37am UTC](https://community.thunkable.com/t/simple-google-sheet-writing-a-row/1789932/5 "2022-06-16T07:37:22Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
