Google sheet formula

Questions
1

Hello. I have a question for the developers. I’m having a problem working with Google Sheets. If a table contains columns with formulas, when the add row or update node is triggered, these formulas disappear. Even if I don’t add these columns with formulas to the node at all. Perhaps you could add a function to this node to leave the columns untouched so I can specify this?

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
2

Hey. You have to add ‘ at the beginning of the text. Use Code or Set Node.

3

I don’t think the Set or Code node will solve my problem. The issue is with the Google Sheet node itself. The Append operation overwrites spreadsheet cells that contain formulas.

4

I don’t know exactly, but maybe that cells with formulas are considered empty?

If is so, here is an workaround to preserve empty cells. Worth to give a try …

1 Like
5

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