Known Issue: Cell limit error when writing to Google Sheets

Symptom 

When writing hundreds of thousands of features to a new Google sheet (using the Google Sheets Writer v4), you get a translation error saying: Python Exception <ApiError>: API Error 400 INVALID_ARGUMENT: 'This action would increase the number of cells in the workbook above the limit of 10000000 cells.'

Cause

When a new Google Sheet is created, by default columns A-Z are generated.  Even if your output features have less than 26 attributes, the blank cells generated from the default Sheet columns are counted towards the workbook cell limit.  Please note that Google Sheets have a workbook cell limit of 10 million (all sheets) and a worksheet cell limit of 5 million (individual sheet).

Resolution

Before writing out your features, manually delete the unnecessary default columns in the Google Sheet.  For example, if your output only has 5 attributes, then delete the Sheet columns F-Z.