I am on n8n cloud. I have a Google Sheets node set to Append Row inside an AI agent workflow. The Document field is set to “From list” and shows “Clipsie Chat Logs” correctly. The Sheet field is set to “By URL” (I selected Sheet1 from list first, then switched to By URL as a workaround suggested in this forum).
Every time I try to publish, I get: “Cannot publish workflow: 1 node have configuration issues: Node ‘Append row in sheet’: Missing or invalid required parameters: documentId, sheetName”
The spreadsheet exists, the credential is connected and shows “Account connected.” The columns loaded correctly earlier and I was able to map expressions to all six fields.
What is the correct stable configuration for Document and Sheet fields that will allow this workflow to publish?
This is a common gotcha with the Google Sheets node — n8n requires certain fields to be resolved before it will let you publish.
Fix:
In the Google Sheets node, select the spreadsheet from the dropdown instead of typing the ID manually. Click the dropdown, browse to your file — once you select it n8n stores the resolved ID and the publish button unlocks.
If you’re using an expression for documentId (e.g. pulling it from a previous node), temporarily switch it to a fixed/static value, publish, then switch back to the expression. n8n validates that required fields are non-empty at publish time regardless of whether an expression would resolve at runtime.
Same fix for sheetName — if it’s dynamic, hardcode it temporarily to publish, then swap back.
Root cause: n8n’s workflow validation requires documentId and sheetName to be non-empty at save time to prevent broken workflows from activating. Once published with static values, you can safely switch back to expressions — the workflow stays published.
