My scenario uses Google Sheets Watch New Rows to monitor a spreadsheet which gets populated when a person fills out a Google Form. The spreadsheet, which was created by Google Forms not by me, has many blank rows at the end.
It was working fine for a while, only processing the real data, but now it has started treating the blank rows as data. I have a limit of 10 rows per execution, and now every night when it runs it processes the next 10 blank rows. When someone fills out the form, a new row gets added to the spreadsheet after the last non-blank row, but my automation doesn’t process it because it has already moved its pointer farther down through the blank rows.
So I could filter out the blank data for the next step, but that doesn’t solve my problem because the real data is no longer being found. I don’t know what happened to change the behavior.
I tried resetting the starting row to be back where the real data is, and that got the real data processed in the next execution, but then it went back to processing the subsequent blank rows and I’m back in the same situation.
Help appreciated!