# How to update a new row every time

**URL:** <https://community.make.com/t/how-to-update-a-new-row-every-time/25493>\
**Category:** Questions\
**Tags:** google-sheets\
**Created:** [January 26, 2024, 2:13pm UTC](https://community.make.com/t/how-to-update-a-new-row-every-time/25493 "2024-01-26T14:13:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rylle\_Tee](https://avatars.discourse-cdn.com/v4/letter/r/cab0a1/32.png) [@Rylle\_Tee](https://community.make.com/u/Rylle_Tee)\
**Post date:** [January 26, 2024, 2:13pm UTC](https://community.make.com/t/how-to-update-a-new-row-every-time/25493/1 "2024-01-26T14:13:39Z")

</div>

Hello I want to find a way on how I can update an existing sheet with a lot of data already and I want to update a blank row as seen in this photo (see the last column full of the comments about the weather saying up if its above 19 or down if its below 20)

![Screen Shot 2024-01-26 at 10.08.27 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/4/d49e641811c5e408fd3df2b9eaaf0990d3ac78c4.png)

I keep running the search function to filter and then to update the last column to say if the temp is above or below 19/20, but every time I run it, it just overwrites the cells that were already filled. So if I ran it the first time, it fills cells on the 1,2,3 rows, and when I run it the second time, it will just fill the those same cells in the same row.

Is there a way for me to be able to fill the next cells after the first x amount have already been filled?

Any help will be great.

---

<div class="post-metadata">

**Author:** ![ThakurHemansh](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/thakurhemansh/32/51014_2.png) [@ThakurHemansh](https://community.make.com/u/ThakurHemansh)\
**Post date:** [January 26, 2024, 2:29pm UTC](https://community.make.com/t/how-to-update-a-new-row-every-time/25493/4 "2024-01-26T14:29:34Z")

</div>

use search rows module with filter, where the suggestion column value does not exist

---

<div class="post-metadata">

**Author:** ![Rylle\_Tee](https://avatars.discourse-cdn.com/v4/letter/r/cab0a1/32.png) [@Rylle\_Tee](https://community.make.com/u/Rylle_Tee)\
**Post date:** [January 26, 2024, 2:31pm UTC](https://community.make.com/t/how-to-update-a-new-row-every-time/25493/5 "2024-01-26T14:31:15Z")

</div>

that makes sense. Thank you so much!

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [February 9, 2024, 2:43pm UTC](https://community.make.com/t/how-to-update-a-new-row-every-time/25493/6 "2024-02-09T14:43:31Z")

</div>

This topic was automatically closed because it's resolved or inactive. Please, start a new topic.


