Building block that writes all pending rows to Google Sheet

i would love to have a new building block that forces all accumulated/pending rows to be written out to the Google Sheet without having to wait for the next 100-row mark.

i would mostly use it when i have a random delay built into the taskbot inside a loop (inserting it just before the delay). the longer the delay, the more likely it is that the taskbot can crash during that time, such as if the user closes the browser or shuts down their machine or whatnot. if that happens, i don’t want to lose the data that been generated so far.

the reason i am not using a repetition limit on the loop and scheduling the taskbot to run every so often is that i do not want to keep starting a new run. in one case, it’s because each separate run will cause the site to show another captcha. in another case, it’s because i’m scrolling down a long page and i want to keep my position for the next run, and not have to scroll down and find it again. i also think that will reflect more human behavior.

a side benefit (but definitely not a driving reason) is that this block can allow multiple taskbots to share the same google sheet at the same time, even when taskbot A writes to the google sheet and taskbot B needs to read that data before taskbot A finishes running.