Do I need to remove past rows from Google Sheet which have been completed by make.com?

How To
1

I use Google Sheet which says “Watch new rows” an configured the Limit to 1. Do I have to remove the rows manually which have been completed by make.com automation while I add new rows to the sheet? The workflow runs successfully for the first time. I guess I will know the answer to my question the next time it runs. But before it’s next run schedule, I am worried that if I don’t remove the processed item, how does it behave? How does it know which item to process next?

2

If you right-click on the module, it will ask you when you want it to start monitoring.

Short answer: no you don’t. Mke will start at the point you tell it to, and proceed from there.

L

3

Does it keep any internal state? If I add 10 items in the sheet abd configure Limit to 1, does it know where it should pick up from? Thanks.

4

Yes. You can even check that. Tell your scenario to run once a minute. If you don’t want it to execute the rest of the scenario, add a filter that always equals FALSE in the connection tot he next module (for example, “if 0 = 1”).

L

5

What happens at the next scheduled run when the list is exhausted?

6

Did you try it? It’s pretty easy to test.

But to answer your question: nothing.

I encourage you to go through some of the Academy courses. You will find many answers there:

https://academy.make.com/courses/BasicsC01

L