There’s almost certainly a more elegant way of doing this, but this was what I was able to quickly throw together as a potentially viable workaround for this issue. In this case, I need to use the Google Sheets Appender node for the first set of records to establish the new tab, and the Google Sheets Updater node for all subsequent writes. I used a “Java If” node to drive this, though not sure if that’s the best approach. I used breakpoint nodes after the Google nodes just as a way to tie them into the flow of the loop.
At 200 records per chunk, each write takes about 1 second and has no problem completing within the timeout period.
Google Sheet Troubleshooting.knar.knwf (43.3 KB)