Looker Overwriting Google Sheet with > 6000 rows causes empty rows (Intermittent Issue)

[shabaz]

I'm facing an issue where Looker scheduled deliveries to Google Sheets intermittently leave row 6000 empty when overwriting an existing file. Additionally, sometimes:

1. Row 6000 is always blank in the overwritten file.
2. Rows 1-6000 are empty intermittently, while data appears correctly after that.
3. The entire sheet is empty sometimes, but retrying the delivery fixes it.

This issue only happens when overwriting an existing sheet—new files work perfectly.

The error in Looker is:

async delivery failed due to errors {}

and 

async delivery failed due to errors Invalid requests[0].pasteData: GridCoordinate.rowIndex[6002] is after last row in grid[5999]

Possible Causes (From Debugging)

• Looker might not be clearing previous data properly, leaving remnants from the old dataset.
• Google Sheets batch update limits might be causing a partial overwrite.
• Race conditions between Looker clearing and writing data could be skipping certain rows.
• The sheet may retain extra empty rows from a previous dataset if the new data has fewer rows.