Batch Fetch Data from Supabase

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "name": "batch_get_tool",
  "nodes": [
    {
      "parameters": {
        "workflowInputs": {
          "values": [
            {
              "name": "execution",
              "type": "object"
            }
          ]
        }
      },
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "typeVersion": 1.1,
      "position": [
        -352,
        64
      ],
      "id": "caa5d0d1-8116-4482-a620-f82d8bdd6327",
      "name": "When Executed by Another Workflow"
    },
    {
      "parameters": {
        "jsCode": "const matches = $('When Executed by Another Workflow').first().json.execution || {nombres_normalizados:\"__no_matches__\", principio_activo:\"__no_matches__\"}\nlet results = []\nfor (let i of $input.all()) {\n  if (matches['nombres_normalizados'].includes(i.json.nombre_normalizado) || matches['principio_activo'].includes(i.json['Principio activo'])){\n    results.push(i)\n  }\n}\nreturn results"
      },
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        112,
        64
      ],
      "id": "e6cf4c24-6baf-4873-90a1-7a01847bd8a9",
      "name": "Code"
    },
    {
      "parameters": {
        "content": "## tool para obtener todas las filas de un match\n",
        "height": 320,
        "width": 696
      },
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        -400,
        -64
      ],
      "id": "9c7e54e6-0fc2-4171-8172-b4d7dd819295",
      "name": "Sticky Note"
    },
    {
      "parameters": {
        "operation": "getAll",
        "tableId": "dummy_table_products",
        "returnAll": true
      },
      "type": "n8n-nodes-base.supabase",
      "typeVersion": 1,
      "position": [
        -112,
        64
      ],
      "id": "24b3ff98-7e61-4e56-b077-bec9584fec11",
      "name": "Get many rows",
      "credentials": {
        "supabaseApi": {
          "name": "<your credential>"
        }
      }
    }
  ],
  "connections": {
    "When Executed by Another Workflow": {
      "main": [
        [
          {
            "node": "Get many rows",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get many rows": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": true,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "2e637547-091a-4599-8112-f411e4d75bfd",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "id": "5kPHVcSTXPAkfAMy",
  "tags": []
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• supabaseApi

About this workflow

batch_get_tool. Uses executeWorkflowTrigger, supabase. Event-driven trigger; 4 nodes.

Source: https://github.com/Btike/Cloud_Automations_portfolio/blob/3c10a42a30b099a761b16e494f4fcbc8c9ff401b/flows/Pharmacy_customer_asistant/data_flows/batch_get_tool.json — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.