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

Описание и применение

Ошибка n8n при работе с Google Sheets в режиме defineBelow возникает из‑за отсутствия поля 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

Источник