Google Sheet append overrides my ARRAYFORMULA column

Questions
1

Problem:
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.

What’s happening?

  • n8n version: 1.1.1
  • Running cloud
3

Found the problem, I should have used the “Let Google Sheet format” and Data location on sheet options. Now it doesn’t change the empty cells.

3 Likes
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.