Google Sheets - New Row Added source suddenly stopped emitting new rows

Jay Vercellone : Hi , just checking with you to see if you saw the same issue again, and if so do you have logs that you can share?

Trever Faden : I recreated the source and it’s been working thus far!

Trever Faden : I’ll keep you posted

Jay Vercellone : OK, thanks!

Jay Vercellone : One thing that could’ve happened is that a row was added at the bottom, processed by the event source, and then removed.
The event source keeps track of the latest row number that was processed so far. If rows were removed at some point, then adding new rows won’t trigger events until those rows go beyond the latest known row number.

Trever Faden : ah!

Trever Faden : interesting

Trever Faden : I can dig into that and see if that was the case

Trever Faden : Hey @U019EEQLNSG I’m running into this problem again

Trever Faden : the polling seems to happen but it’s no longer identifying the newest row

Trever Faden : last row it picked up was #126 and it didn’t trigger on row #127

Dylan Sather (Pipedream) : Thanks for letting us know. Is this still source https://pipedream.com/sources/dc_lVunn43 ?

Trever Faden : dc_76uZ27P

Trever Faden : created a new one after the last issue

Trever Faden : I can share the source spreadsheet with you too if that’s helpful

Dylan Sather (Pipedream) : Yes that might be helpful if you don’t mind. dylan@pipedream.com

Trever Faden : done

Dylan Sather (Pipedream) : Would you be able to duplicate the row on row 128, if that’s possible? I’d like to observe the incoming webhooks from Google sheets on your source

Trever Faden : yah

Trever Faden : 1 sec