# Delete row action clearing instead of deleting?

**URL:** <https://community.glideapps.com/t/delete-row-action-clearing-instead-of-deleting/35493>\
**Category:** Ask for Help\
**Created:** [December 3, 2021, 10:32pm UTC](https://community.glideapps.com/t/delete-row-action-clearing-instead-of-deleting/35493 "2021-12-03T22:32:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![saphier](https://avatars.discourse-cdn.com/v4/letter/s/f08c70/32.png) [@saphier](https://community.glideapps.com/u/saphier)\
**Post date:** [December 3, 2021, 10:32pm UTC](https://community.glideapps.com/t/delete-row-action-clearing-instead-of-deleting/35493/1 "2021-12-03T22:32:12Z")

</div>

Hi,

Using google sheet as a data source. I have a custom action with delete row as an action. When triggered the rows in the sheets are cleared but not deleted. The result is blank rows in google sheet in between rows of data. Is this expected behaviour?

There is a protected column in this sheet - don’t know if this interacts as I haven’t had a chance to test but may be relevant

Thanks for any insight 😃

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [December 3, 2021, 10:53pm UTC](https://community.glideapps.com/t/delete-row-action-clearing-instead-of-deleting/35493/2 "2021-12-03T22:53:43Z")

</div>

This is how Google Sheets API defines deleting a row – it clears the row.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 4, 2021, 3:29am UTC](https://community.glideapps.com/t/delete-row-action-clearing-instead-of-deleting/35493/3 "2021-12-04T03:29:46Z")

</div>

If the blank rows are an issue, then the solution is to use something external - Integromat/Zapier/Apps Script - to periodically clean them up.

---

<div class="post-metadata">

**Author:** ![saphier](https://avatars.discourse-cdn.com/v4/letter/s/f08c70/32.png) [@saphier](https://community.glideapps.com/u/saphier)\
**Post date:** [December 4, 2021, 4:23pm UTC](https://community.glideapps.com/t/delete-row-action-clearing-instead-of-deleting/35493/4 "2021-12-04T16:23:47Z")

</div>

Thanks both of you. I’ll probably do what was suggested and schedule a trash collector of some type or modify the action to let integromat know to delete that row. 👍🏼

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 5, 2021, 4:24pm UTC](https://community.glideapps.com/t/delete-row-action-clearing-instead-of-deleting/35493/5 "2021-12-05T16:24:24Z")

</div>

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