I have a google sheet with active columns from A to Y.
Columns A:X its my main data I collect from n8n.
Column Y: ARRAYFORMULA that’s generating ID numbers based on new rows added.
When I run the Google Sheet Append node (mapping columns manually or automatically) it does something to Y3, so my ARRAYFORMULA breaks. Looking in the sheet Y3 is empty, nothing in the cell, no spaces, no formulas, deleting it allows the formula to work again.
Error message in Google Sheet:
“Array result was not expanded because it would overwrite data in Y3”
The number of INPUT values are equal to the OUTPUT, covering all the columns A:X, I don’t see the node adding new empty values.
- n8n version: 1.1.1
- Running cloud