columns.schema is required when columns.mappingMode is defineBelow — What This n8n Error Actually Means

说明与用途

n8n 在 defineBelow 模式下，Google Sheets 节点缺少 schema 时会报错。解决方案：在 UI 中重新选择工作表、切换到 autoMapInputData 或手动生成 schema。

问题

Google Sheets node fails with error "columns.schema is required when columns.mappingMode is defineBelow" when workflow JSON is imported or created via API, because the schema field is missing.

结果

Node runs successfully after schema is regenerated or mapping mode changed; importers avoid error by re‑selecting sheet or generating schema programmatically.

工作流

• Open failing node in editor
• Ensure Document and Sheet fields are set to "From list" and re‑select spreadsheet and tab
• Verify mapping remains populated
• Save and run
• (Optional) Switch mappingMode to "autoMapInputData" and clear value map
• (Optional) Programmatically generate schema from header array and inject into node before workflow execution

证据

columns.schema is required when columns.mappingMode is defineBelow

来源

Fix 1 — re-select the document and sheet (recommended, about ten seconds)

来源

Fix 3 — build the schema yourself

来源