My ‘watch changes’ module is getting all the new rows in a google sheet, but when the array is passed to the iterator (to search another sheet for a repeat entry, or add a new one) it seems to only receive an array of one row rather than all the rows. I tried adding in an array aggregator after the watches changes, but kinda seems to be doing the same thing.
I want it to do this: Watch for new rows and upon find new rows, iterate over each row and use one of the cells in that row to check an existing sheet for previous entries. If there it exists return the row number in the existing sheet otherwise make a new row in that sheet and return that new row number for later on.
I’m not sure how I’m mapping this improperly with the ‘Watch Changes’ module. I had it working properly with the ‘Watch New Rows’ module. But that only watches one tab within a google sheet. I need to watch several tabs in that same google sheet. Each tab is the response of a different google form.
