# Delete rows in a Google Sheet

**URL:** <https://community.parabola.io/t/delete-rows-in-a-google-sheet/807>\
**Category:** Ask a question\
**Created:** [July 15, 2020, 2:05pm UTC](https://community.parabola.io/t/delete-rows-in-a-google-sheet/807 "2020-07-15T14:05:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tessa\_T](https://avatars.discourse-cdn.com/v4/letter/t/e79b87/32.png) [@Tessa\_T](https://community.parabola.io/u/Tessa_T)\
**Post date:** [July 15, 2020, 2:05pm UTC](https://community.parabola.io/t/delete-rows-in-a-google-sheet/807/1 "2020-07-15T14:05:11Z")

</div>

Trying to figure out a two step flow to essentially import a Google Sheet and then clear the rows in the sheet. I know with Airtable this is possible using the API Export destination and DELETE, but how does one do this with a Google Sheet as there isn’t an API. Thanks!

---

<div class="post-metadata">

**Author:** ![jp](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/jp/32/20_2.png) [@jp](https://community.parabola.io/u/jp)\
**Post date:** [July 15, 2020, 5:33pm UTC](https://community.parabola.io/t/delete-rows-in-a-google-sheet/807/2 "2020-07-15T17:33:52Z")

</div>

Hey @Tessa_T!

Are you trying to import the Google Sheet just to retain the headers? If so, you could always upload a CSV of the headers and not column data, and for example, overwrite your Google Sheet during each export. Does that make sense?

---

<div class="post-metadata">

**Author:** ![Tessa\_T](https://avatars.discourse-cdn.com/v4/letter/t/e79b87/32.png) [@Tessa\_T](https://community.parabola.io/u/Tessa_T)\
**Post date:** [July 15, 2020, 8:11pm UTC](https://community.parabola.io/t/delete-rows-in-a-google-sheet/807/3 "2020-07-15T20:11:49Z")

</div>

Hey @jp — ya that’s kind of what I was trying to do, more so just automate the clearing of a Google Sheet each night. I actually opted to just use Airtable instead as it was more straightforward given there’s an endpoint for delete records 🙂

Thanks for your help!
