Google sheets lookup error?

Hello! I’m starting with n8n.io (desktop app) and i don’t know if i am doing something wrong or the lookup node in google sheets doesn’t work.

When I read a sheet it gaves me all the data that i need. But when i use the lookup node to fin only one key data, it returns me the same data for all the rows. You can see this in the following pictures.

Read works perfect

Lookup error

This are the nodes i’m using.

{
  "nodes": [
    {
      "parameters": {
        "sheetId": "10ubSYiDBk4zSk9zY_11lEmJxDuf1_8XiRoMAlmtzZzU",
        "range": "Datos paso 1 en clickup!A:Z",
        "options": {
          "valueRenderMode": "FORMATTED_VALUE"
        }
      },
      "name": "Google Sheets5",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2000,
        220
      ],
      "typeVersion": 1,
      "credentials": {
        "googleApi": {
          "id": "2",
          "name": "Google account"
        }
      }
    },
    {
      "parameters": {
        "operation": "lookup",
        "sheetId": "10ubSYiDBk4zSk9zY_11lEmJxDuf1_8XiRoMAlmtzZzU",
        "range": "Datos paso 1 en clickup!A:Z",
        "lookupColumn": "Teléfono",
        "lookupValue": "qq",
        "options": {
          "returnAllMatches": false,
          "valueRenderMode": "FORMATTED_VALUE"
        }
      },
      "name": "Google Sheets6",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2180,
        220
      ],
      "typeVersion": 1,
      "credentials": {
        "googleApi": {
          "id": "2",
          "name": "Google account"
        }
      }
    }
  ],
  "connections": {
    "Google Sheets5": {
      "main": [
        [
          {
            "node": "Google Sheets6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Am I doing something wrong?

Thanks!

Probably because the node has more than one input. The nodes in n8n execute as many times as input they have. To solve this, in the node settings, set Execute Once to true. The other option it’s to remove the Google Sheet5 node if you do not need it.

2 Likes

Thank you! But I need to lookup for multiple values. For example, from a previous node I have 3 phone numbers and I need to look for these three numbers in a new sheet.
Is that posible with lookup node?

Thnaks.