Google Sheet - Watch Rows module

[HarishDe]

Hello Everyone 

Can anyone suggest how exactly this module works ? 
I dont see any details about the below in the documentation. 
Moreover unlike the documentation specification ,watch rows doesn't retrieve the list of updated rows but all rows. 

Is there a way to Iterate only on the newly added rows ? 

Thanks
Harish

 

[lgaertner]

Hi HarishDe,

Google Sheets > Watch Rows returns new rows added after the last time the scenario was run.

This should explain how to use it.

Regards

Lars

[HarishDe]

Hi @lgaertner 

This is incorrect. 

I tried all options -- All, specific ID & manual 
When using any of the 3 - I was able to get all the rows NOT the newly added rows, unlike stated on the documentation.

[lgaertner]

I just tried the module using 

Choose where to start: specific ID

Here I entered the row number of the last existing row.

Running the module now returned zero results, as expected, running it again after adding an additional row or additional rows returned that new row(s).

[HarishDe]

Hi @lgaertner 

Is this your expectation ?

1. enter the row number of the last existing row.
2. Zero results -- if no additional rows added -- Expected
3. Return the new row -- if an additional row was added -- Expected
4. Return 2 rows [ (3) + the new row ] -- If another row is added after some time -- NOT expected

If you think its expected, its a duplicate module because the same functionality can be easily achieved via Search(Advanced) module. 

Nevertheless, Thanks a lot for explaining !

[lgaertner]

Hi @HarishDe,

I am not sure, if I understand point 4 in your enumeration right, but in my test scenario the module is working as expected using the above way.

The module does remember, which rows have been fetched already and returns only new rows

through each subsequent call.

Regards

Lars