AutomationFlowsData & Sheets › Wf Kb Ingest V2

Wf Kb Ingest V2

WF_KB_ingest_v2. Uses httpRequest, googleSheets. Webhook trigger; 5 nodes.

Webhook trigger★★★★☆ complexity5 nodesHTTP RequestGoogle Sheets
Data & Sheets Trigger: Webhook Nodes: 5 Complexity: ★★★★☆ Added:

This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.

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 →

Download .json
{
  "name": "WF_KB_ingest_v2",
  "nodes": [
    {
      "id": "WB_Ingest",
      "name": "Webhook KB Ingest",
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 1,
      "position": [
        300,
        200
      ],
      "parameters": {
        "path": "kb/ingest",
        "httpMethod": "POST",
        "responseMode": "onReceived"
      }
    },
    {
      "id": "Fn_Split",
      "name": "Fn Chunk",
      "type": "n8n-nodes-base.function",
      "typeVersion": 2,
      "position": [
        560,
        200
      ],
      "parameters": {
        "functionCode": "const text=items[0].json.text||''; const CH=800; let out=[]; for(let i=0;i<text.length;i+=CH){ out.push({json:{chunk:text.slice(i,i+CH)}});} return out;"
      }
    },
    {
      "id": "HTTP_TEI",
      "name": "TEI Embed",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 3,
      "position": [
        820,
        200
      ],
      "parameters": {
        "method": "POST",
        "url": "{{TEI_URL}}/embeddings",
        "jsonParameters": true,
        "bodyParametersJson": "={\"inputs\":\"{{$json.chunk}}\",\"truncate\":true}"
      }
    },
    {
      "id": "HTTP_QdrantUp",
      "name": "Qdrant Upsert",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 3,
      "position": [
        1080,
        200
      ],
      "parameters": {
        "method": "PUT",
        "url": "{{QDRANT_URL}}/collections/products/points?wait=true",
        "jsonParameters": true,
        "bodyParametersJson": "={\"points\":[{\"id\":\"={{$json.id || $now}}\",\"vector\":{{$json.embeddings?.[0]?.embedding || []}},\"payload\":{{PAYLOAD_TEMPLATE}}}]}"
      }
    },
    {
      "id": "GS_Propose",
      "name": "Google Sheets Proposals",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 3,
      "position": [
        1340,
        200
      ],
      "parameters": {
        "operation": "append",
        "documentId": "{{GSHEET_ID}}",
        "range": "KB_Suggestions!A:Z",
        "values": "=[[\"{{$now}}\",\"source\",\"lang\",\"title\",\"{{$json.chunk.slice(0,80)}}\"]]"
      }
    }
  ],
  "connections": {
    "Webhook KB Ingest": {
      "main": [
        [
          {
            "node": "Fn Chunk",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fn Chunk": {
      "main": [
        [
          {
            "node": "TEI Embed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "TEI Embed": {
      "main": [
        [
          {
            "node": "Qdrant Upsert",
            "type": "main",
            "index": 0
          },
          {
            "node": "Google Sheets Proposals",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "export_seal": {
    "project": "auto-atc",
    "prompt_id": "WF_KB_ingest_v2",
    "version": "3.0.0",
    "file": "n8n/WF_KB_ingest_v2.json",
    "lang": "json",
    "created_at": "2025-10-31T00:10:55Z",
    "author": "GPT-5 Thinking",
    "origin": "bundle",
    "body_sha256": "3ac4ceb201f6b268117c5daa1a2845c4fa409197b664989f932980b9826577b4"
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

WF_KB_ingest_v2. Uses httpRequest, googleSheets. Webhook trigger; 5 nodes.

Source: https://github.com/matiasportugau-ui/ChatBOT/blob/261ee4d4317e2349de5dd5fd1cba254b542a5eae/n8n/WF_KB_ingest_v2.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.

Data & Sheets

Resume Screening & Behavioral Interviews with Gemini, Elevenlabs, & Notion ATS copy. Uses googleDrive, httpRequest, notion, formTrigger. Webhook trigger; 67 nodes.

Google Drive, HTTP Request, Notion +3
Data & Sheets

[SANTOBET] FLUXO TODO - BACKUP. Uses googleSheets, httpRequest, googleSheetsTrigger. Webhook trigger; 57 nodes.

Google Sheets, HTTP Request, Google Sheets Trigger
Data & Sheets

This workflow sends post-purchase review request emails for WooCommerce orders, stores expiring form links in Google Sheets, optionally shortens links with Dub.co and delays delivery, serves a hosted

HTTP Request, Google Sheets, Email Send
Data & Sheets

FLUXO DISPARO DATA E HORA. Uses itemLists, googleSheets, httpRequest. Webhook trigger; 48 nodes.

Item Lists, Google Sheets, HTTP Request
Data & Sheets

This workflow allows you to accept online payments via YooKassa and log both orders and transactions in Google Sheets — all without writing a single line of code. It supports full payment flow: produc

Google Sheets, HTTP Request