Known Issue: Cell limit error when writing to Google Sheets

Liz Sanderson
Liz Sanderson
  • Updated
Known Issue ID  N/A

FME 2021.1.3.1 Build 21635


All Versions


See Resolution



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.'



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).



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.

Was this article helpful?



Please sign in to leave a comment.