//n8n pitfalls · critical
Never use append on sheets with formula columns
Google Sheets append operation writes raw values including formula results as plain text. If the sheet has formula columns (like calculated totals), appending will overwrite formulas with their last computed values. Use update operation with specific cell ranges instead.
- Category
- integration / google_sheets
Source: the n8n-mcp pitfall list, maintained by the tool's author
Mistakes AI agents make in n8n
- Execute Workflow + Wait nodes cause data loss
- SplitInBatches + Wait nodes cause state loss
- $env expressions blocked in Code nodes
- saveExecutionProgress fills disk space
- IF node uses branch true/false not sourceIndex
- Code node $input.all() vs $input.first()
- Per-item execution on large datasets
- Webhook node response must be sent explicitly
- Error Trigger workflow must be separate
- $getWorkflowStaticData global loses data in loops