# Deleting datas saved on google sheets

**URL:** <https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254>\
**Category:** Questions about Thunkable X\
**Tags:** beginner\
**Created:** [December 17, 2021, 8:49am UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254 "2021-12-17T08:49:15Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![teamzaddysn9m](https://avatars.discourse-cdn.com/v4/letter/t/e480ec/32.png) [@teamzaddysn9m](https://community.thunkable.com/u/teamzaddysn9m)\
**Post date:** [December 17, 2021, 8:49am UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254/1 "2021-12-17T08:49:15Z")

</div>

Hi, may I ask how am i able to delete records from the button clicked on thunkable when I would want the datas saved on my google sheets to be deleted? 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:** [December 17, 2021, 10:47am UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254/2 "2021-12-17T10:47:48Z")

</div>

use this block  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/b/0b2135178e0525af42fd3b35571e2e424cf12f3f.png)

---

<div class="post-metadata">

**Author:** ![teamzaddysn9m](https://avatars.discourse-cdn.com/v4/letter/t/e480ec/32.png) [@teamzaddysn9m](https://community.thunkable.com/u/teamzaddysn9m)\
**Post date:** [December 20, 2021, 6:42pm UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254/3 "2021-12-20T18:42:43Z")

</div>

I would like to delete all 30 rows saved data am I able to do so?

---

<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:** [December 20, 2021, 7:00pm UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254/4 "2021-12-20T19:00:09Z")

</div>

> **[Data Sources](https://docs.thunkable.com/data-sources#delete-all-rows)**
>
> The Data Sources blocks allow you work with the information that you have stored in your connected Airtable Bases, Google Sheets or Local Tables.

---

<div class="post-metadata">

**Author:** ![teamzaddysn9m](https://avatars.discourse-cdn.com/v4/letter/t/e480ec/32.png) [@teamzaddysn9m](https://community.thunkable.com/u/teamzaddysn9m)\
**Post date:** [December 20, 2021, 7:32pm UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254/5 "2021-12-20T19:32:29Z")

</div>

I would like to delete all the data at once. However, for the block “delete row” which is applicable for google sheets does not allow me to may i ask how am i able to delete all my data at once? and not just a single row data.

 ![Screenshot 2021-12-21 at 3.32.10 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/9/d9b1f3b98145ec0463282dd5ab78c21b6ebf4d51.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:** [December 20, 2021, 8:00pm UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254/6 "2021-12-20T20:00:07Z")

</div>

Try this:

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

---

<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:** [December 20, 2021, 9:26pm UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254/7 "2021-12-20T21:26:23Z")

</div>

Note that there is a block to `delete all rows` but it only functions for local table. You will not see this block for Airtable or Google sheet.

---

<div class="post-metadata">

**Author:** ![teamzaddysn9m](https://avatars.discourse-cdn.com/v4/letter/t/e480ec/32.png) [@teamzaddysn9m](https://community.thunkable.com/u/teamzaddysn9m)\
**Post date:** [December 21, 2021, 9:01am UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254/8 "2021-12-21T09:01:56Z")

</div>

Already knew about this.

---

<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:** [December 25, 2021, 2:18pm UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254/9 "2021-12-25T14:18:18Z")

</div>

Please note that the last update in Thunkable added the possibility to **delete all rows** for Google sheet.

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/3/237957bae33d9addd398cf8ab88b4aaf8dc796d7.png)

---

<div class="post-metadata">

**Author:** ![teamzaddysn9m](https://avatars.discourse-cdn.com/v4/letter/t/e480ec/32.png) [@teamzaddysn9m](https://community.thunkable.com/u/teamzaddysn9m)\
**Post date:** [December 29, 2021, 8:01am UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254/10 "2021-12-29T08:01:55Z")

</div>

Does it mean, by deleting all rows in the google sheets means the first low which is my labels for each specific column, will get deleted too? If so, is there any way to solve this?

---

<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:** [December 29, 2021, 8:23am UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254/11 "2021-12-29T08:23:04Z")

</div>

Good question. I think “delete all rows” means that it will delete everything in the sheet including any header row data. But the best way to know is to test it out.

---

<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:** [December 29, 2021, 8:38am UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254/12 "2021-12-29T08:38:38Z")

</div>

Delete all rows will delete the data rows only keeping the header row as is.

I tested it with a Google sheet with 2 data rows.

---

<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:** [March 29, 2022, 8:39am UTC](https://community.thunkable.com/t/deleting-datas-saved-on-google-sheets/1656254/13 "2022-03-29T08:39:31Z")

</div>

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