I have a folder containing several Google Sheets documents - my goal is to have Make help me maintain a master document that aggregates the rows from the documents in this folder.
I can easily get the list of documents in the folder and use an Iterator to iterate over them. But when I try to connect a Google Sheets node to the Iterator, the “Watch new rows” action isn’t one of the options provided.
Is there another way to accomplish this task?
Hello,
unfortunately, Watch Rows is a module that can only be used at the beginning of the scenarios. It needs to reference a single document, because it keeps track of the latest rowID to detect any new row…
You can still implement it, but it will be more complex. What you could do it to use the Data Store to keep track of the ID of each document, and the last row id of it.
When yo run the scenario, you first check for files, and for each file, you check if they are already in the Data Store (if not, you add them, with rowID=0), and then you load any extra rows from what you have in the Data Store (I don’t know how to do, but “search rows” with filters could do the trick). Then you add these new rows in the main spreadsheet and update the Data Store.
I hope if helps
Benjamin