n8n errors / Config
No columns found in Google Sheet. All rows will be appended
Cause
The Google Sheets node needs schema discovery at design time, but when the spreadsheet ID is a runtime expression it cannot read column headers during setup.
Fix
Pin sample data to the trigger so the Sheets node can resolve the expression and detect columns. Alternatively hard-code a representative spreadsheet ID during setup, load the schema, then switch the field back to an expression. Ensure the sheet has a populated header row in row 1.
Part of the Automation Error Index — n8n errors: browse all.
Hitting an automation error we have not covered?
AutomateLab builds and debugs n8n, Make, and agent workflows as fixed-scope projects. If something is broken in production, tell us what you are seeing.
Describe the problem