# Retrieve the next row's value from Google Sheet **URL:** \ **Category:** Questions\ **Tags:** arrays, filters, google-sheets, functions, mapping\ **Created:** [September 19, 2024, 9:04am UTC](https://community.make.com/t/retrieve-the-next-rows-value-from-google-sheet/55463 "2024-09-19T09:04:15Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![SRKDaniel](https://avatars.discourse-cdn.com/v4/letter/s/d9b06d/32.png) [@SRKDaniel](https://community.make.com/u/SRKDaniel)\ **Post date:** [September 19, 2024, 9:04am UTC](https://community.make.com/t/retrieve-the-next-rows-value-from-google-sheet/55463/1 "2024-09-19T09:04:15Z")
Hi, In my app, new data is added to a new cell after each request, and I need to retrieve the value from the most recent cell after every run. Currently, I’m using the **Google Sheets Get Cell** module, but I’m unsure how to dynamically move from, for example, cell **C2** to **C3** (or the next available row) after each run. Could anyone help me set this up or suggest a better approach for always retrieving the most recent value? Thanks in advance! ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [September 19, 2024, 9:09am UTC](https://community.make.com/t/retrieve-the-next-rows-value-from-google-sheet/55463/2 "2024-09-19T09:09:24Z")
Welcome to the Make community! You need a “date used” column to keep track of when the item was last used. Then your search module simply has to sort by date last used, oldest first. Hope this helps! Let me know if there are any further questions or issues. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**Author:** ![SRKDaniel](https://avatars.discourse-cdn.com/v4/letter/s/d9b06d/32.png) [@SRKDaniel](https://community.make.com/u/SRKDaniel)\ **Post date:** [September 19, 2024, 9:19am UTC](https://community.make.com/t/retrieve-the-next-rows-value-from-google-sheet/55463/3 "2024-09-19T09:19:10Z")
Thank you for the answer. Where can I set that in the module to sort based on the dates from another column? ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [September 19, 2024, 12:04pm UTC](https://community.make.com/t/retrieve-the-next-rows-value-from-google-sheet/55463/4 "2024-09-19T12:04:22Z")
That would be the “Search Rows” module. ![Screenshot_2024-09-19_200902](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/1/4107ffe59a39be2171add2c8c51da62a429af384.png) Hope this helps! Let me know if there are any further questions or issues. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**Author:** ![SRKDaniel](https://avatars.discourse-cdn.com/v4/letter/s/d9b06d/32.png) [@SRKDaniel](https://community.make.com/u/SRKDaniel)\ **Post date:** [September 20, 2024, 12:21pm UTC](https://community.make.com/t/retrieve-the-next-rows-value-from-google-sheet/55463/5 "2024-09-20T12:21:33Z")
Thank you, I added the Search Rows module and it works as I wanted. Currently, my only problem is that the Search Rows module is keep running, constantly creating operations despite the values remaining the same. How could I do that it would only run once when there is a new data/row added to the google sheet? ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [September 20, 2024, 12:43pm UTC](https://community.make.com/t/retrieve-the-next-rows-value-from-google-sheet/55463/6 "2024-09-20T12:43:51Z")
You’ll have to add a new column to update once each item’s been processed then. ---
**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:** [December 19, 2024, 1:55pm UTC](https://community.make.com/t/retrieve-the-next-rows-value-from-google-sheet/55463/7 "2024-12-19T13:55:26Z")