# Google sheets trigger watch new rows not taking the next row **URL:** \ **Category:** Questions\ **Tags:** trigger, google-sheets\ **Created:** [June 6, 2024, 4:48pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646 "2024-06-06T16:48:50Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Ruben\_Koemans](https://avatars.discourse-cdn.com/v4/letter/r/ce73a5/32.png) [@Ruben\_Koemans](https://community.make.com/u/Ruben_Koemans)\ **Post date:** [June 6, 2024, 4:48pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/1 "2024-06-06T16:48:51Z")
Hey! I have been working on a make scenario that makes blogs. The scenario uses a spreadsheets content as input for the blogs. The issue here is that the trigger search rows only searches one row. It needs to search for the next topic and keyword (the next row) after using the first one. So when it ran the first time, the second time it should use the row underneath the first row that it used. Right now it keeps getting the same row. ![Screenshot 2024-06-06 at 18.47.25](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/1/a1fab1d0015b7b019eb2461c5fce8e81c4182133.jpeg) I hope someone can help me fix this ![Screenshot 2024-06-06 at 18.48.32](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/0/9053ede8219c8fdfc3ba2c13ae6356f960602dac.png) ---
**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:** [June 6, 2024, 4:51pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/3 "2024-06-06T16:51:45Z")
You’ll need to use a column to store a variable that it has been used, perhaps last used date? [samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make) > Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with us! ---
**Author:** ![Ruben\_Koemans](https://avatars.discourse-cdn.com/v4/letter/r/ce73a5/32.png) [@Ruben\_Koemans](https://community.make.com/u/Ruben_Koemans)\ **Post date:** [June 6, 2024, 4:55pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/4 "2024-06-06T16:55:06Z")
@samliew thanks for your quick reply. But i dont get what you are saying. Do i need to use a different trigger? ---
**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:** [June 6, 2024, 5:03pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/5 "2024-06-06T17:03:28Z")
The trigger is fine, you’ll just need to use another module to update a third column with the special now date variable so you can sort by oldest first using the trigger module. Alternatively, you can just get all the rows, aggregate to an array, and pick a random one. - [How to get a random value from Data Store](https://community.make.com/t/how-to-get-a-random-value-from-data-store/18777) ---
**Author:** ![alex.newpath](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/alex.newpath/32/84_2.png) [@alex.newpath](https://community.make.com/u/alex.newpath)\ **Post date:** [June 6, 2024, 5:19pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/6 "2024-06-06T17:19:40Z")
You will need to adjust your spreadsheet to store information on when a row has been used. And your scenario will need to update that row at the end to make sure once it has processed a row the new column with the information on when a row has been used is populated. So the flow will look like this 1. Search rows where the last updated column (use the filter) is empty 2. select the first row (or random row) from this result 3. process the data in the spreadsheet row 4. Update the row selected with the last updated column to be populated with say the {{now}} variable in Make Now when the scenario runs any rows that have been processed will have a last updated column be set and step 1 will not select these rows in the Search. ---
**Author:** ![Ruben\_Koemans](https://avatars.discourse-cdn.com/v4/letter/r/ce73a5/32.png) [@Ruben\_Koemans](https://community.make.com/u/Ruben_Koemans)\ **Post date:** [June 6, 2024, 5:26pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/7 "2024-06-06T17:26:14Z")
like this right? ![Screenshot 2024-06-06 at 19.24.26](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/0/d07cfb89622dbfb29ea49811c0b62c5e9ca63a79.jpeg) later in the scenario i added the update a row module that updates the row (selected by the trigger) with the current time - {{now}} ---
**Author:** ![alex.newpath](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/alex.newpath/32/84_2.png) [@alex.newpath](https://community.make.com/u/alex.newpath)\ **Post date:** [June 6, 2024, 5:28pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/8 "2024-06-06T17:28:28Z")
> [@Ruben\_Koemans](#): > > ![Screenshot 2024-06-06 at 19.24.26](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/0/d07cfb89622dbfb29ea49811c0b62c5e9ca63a79.jpeg) In the operators dropdown you can use the operator not empty I think, I cannot remember. But you have to basically check if there is a value in column C. You can probably use the Text operator “Not equal to” and then use {{emptystring}} in the value for the condition. ---
**Author:** ![Ruben\_Koemans](https://avatars.discourse-cdn.com/v4/letter/r/ce73a5/32.png) [@Ruben\_Koemans](https://community.make.com/u/Ruben_Koemans)\ **Post date:** [June 6, 2024, 5:34pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/9 "2024-06-06T17:34:05Z")
I have tried it but the output was 0. bundles. the is empty is not available unfortunately ---
**Author:** ![alex.newpath](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/alex.newpath/32/84_2.png) [@alex.newpath](https://community.make.com/u/alex.newpath)\ **Post date:** [June 6, 2024, 5:35pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/10 "2024-06-06T17:35:06Z")
Sorry I meant you want it to search on Column C to be EQUAL TO {{emptystring}} to grab rows that have not been yet processed. ---
**Author:** ![Ruben\_Koemans](https://avatars.discourse-cdn.com/v4/letter/r/ce73a5/32.png) [@Ruben\_Koemans](https://community.make.com/u/Ruben_Koemans)\ **Post date:** [June 6, 2024, 5:36pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/11 "2024-06-06T17:36:18Z")
I tried that, the output was the same. Or should it be case insensitive? ---
**Author:** ![alex.newpath](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/alex.newpath/32/84_2.png) [@alex.newpath](https://community.make.com/u/alex.newpath)\ **Post date:** [June 6, 2024, 5:37pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/12 "2024-06-06T17:37:06Z")
show what your spreadsheet looks like please? ---
**Author:** ![Ruben\_Koemans](https://avatars.discourse-cdn.com/v4/letter/r/ce73a5/32.png) [@Ruben\_Koemans](https://community.make.com/u/Ruben_Koemans)\ **Post date:** [June 6, 2024, 5:37pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/13 "2024-06-06T17:37:39Z")
![Screenshot 2024-06-06 at 19.37.17](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/2/a2aee009c0b90a5c1272383a5aefe930e02f1e4f.png) ![Screenshot 2024-06-06 at 19.37.31](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/1/a128f4dac90e9373a9b5706348ceff2a3461cc20.jpeg) ---
**Author:** ![alex.newpath](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/alex.newpath/32/84_2.png) [@alex.newpath](https://community.make.com/u/alex.newpath)\ **Post date:** [June 6, 2024, 5:42pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/14 "2024-06-06T17:42:49Z")
Try the basic operator “Does not exist” ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/3/2327e0e3f44085ecb3f336440ee8b2d8bc39d7ed.png) ---
**Author:** ![Ruben\_Koemans](https://avatars.discourse-cdn.com/v4/letter/r/ce73a5/32.png) [@Ruben\_Koemans](https://community.make.com/u/Ruben_Koemans)\ **Post date:** [June 6, 2024, 5:46pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/15 "2024-06-06T17:46:11Z")
You are amazing, thanks a lot! ---
**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:** [June 20, 2024, 5:49pm UTC](https://community.make.com/t/google-sheets-trigger-watch-new-rows-not-taking-the-next-row/40646/16 "2024-06-20T17:49:06Z")