`next` version: Google Sheets maxes out at 1000 rows

I was running an audit and suddenly the audit got stuck with this error:
> Error: Range ('Lighthouse Results'!A1001) exceeds grid limits. Max rows: 1000, max columns: 121

I manually added more rows to the Google Sheet at that point, but the process could not get out of that error state.

My workaround was to start a new process, then as soon as the new Google Sheet was opened, I added 10K rows to ensure it wouldn't get stuck again with that 1000 max row error.