Google Sheets "Append" error "Could not retrieve the column data"

Questions
1

Hello all,

I have been creating a flow that reads new lines containing URLs from a Google sheets, performs HTTP GET, HTML Extract and Set operations on those URL and saves them back into a new tab on the Google Sheet.

Reading the sheet works fine, but when I try to append data to the spreadsheet, it returns an error:
ERROR: Could not retrieve the column data!

My node is configured as follows:

{
  "nodes": [
    {
      "parameters": {
        "operation": "append",
        "sheetId": "REMOVED",
        "range": "ghresults!D:G", // I have also tried 'ghresults'!D:G and D:G - neither work.
        "keyRow": 1,
        "options": {
          "valueInputMode": "RAW"
        }
      },
      "name": "Google Sheets1",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 1,
      "position": [
        920,
        300
      ],
      "credentials": {
        "googleApi": "Google Service Acc 2"
      }
    }
  ],
  "connections": {}
}

Any ideas what is going wrong?

2

Solved - “keyRow”: 0
My headers were in the first row and keyRow numbering starts at 0. Changing this in n8n solved the issue.

1 Like
3

Glad that you found a solution and thanks for sharing with the community!