cloudfour / lighthouse-parade

A Node.js command line tool that crawls a domain and gathers lighthouse performance data for every page.
MIT License
357 stars 14 forks source link

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

Open gerardo-rodriguez opened 9 months ago

gerardo-rodriguez commented 9 months ago

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.