{
“nodes”: [
{
“parameters”: {
“promptType”: “define”,
“text”: “={{ $json.area }}”,
“messages”: {
“messageValues”: [
{
“message”: “=You are an address recognition assistant. Based on the input Hong Kong address, identify which district it belongs to. Use keywords like ‘Wan Chai’ for Wai Chai, ‘Mong Kok’ for Yau Tsim Mong District, and ‘Sha Tin’ for Sha Tin District, and reply with the district name directly.”
}
]
},
“batching”: {}
},
“type”: “@n8n/n8n-nodes-langchain.chainLlm”,
“typeVersion”: 1.7,
“position”: [
-80,
-144
],
“id”: “393853ae-4c0a-409e-9027-1e08f3ba648c”,
“name”: “Basic LLM Chain”
},
{
“parameters”: {
“options”: {}
},
“type”: “@n8n/n8n-nodes-langchain.lmChatGoogleGemini”,
“typeVersion”: 1,
“position”: [
-128,
64
],
“id”: “6c04e2e3-1744-4222-a5d8-0d8641fad4ed”,
“name”: “Google Gemini Chat Model”,
“credentials”: {
“googlePalmApi”: {
“id”: “swfJscUV5Ki1dH8U”,
“name”: “Google Gemini(PaLM) Api account”
}
}
},
{
“parameters”: {
“workflowInputs”: {
“values”: [
{
“name”: “company_area”
}
]
}
},
“type”: “n8n-nodes-base.executeWorkflowTrigger”,
“typeVersion”: 1.1,
“position”: [
-336,
-144
],
“id”: “b56ace32-93f5-487b-835e-6d739eede271”,
“name”: “When Executed by Another Workflow”,
“alwaysOutputData”: true
},
{
“parameters”: {
“documentId”: {
“__rl”: true,
“value”: “1pWheh5i4vpFiWfy1VkH3fp4s_bZEnuOSbZsM35frhSc”,
“mode”: “list”,
“cachedResultName”: “area”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/1pWheh5i4vpFiWfy1VkH3fp4s_bZEnuOSbZsM35frhSc/edit?usp=drivesdk”
},
“sheetName”: {
“__rl”: true,
“value”: “gid=0”,
“mode”: “list”,
“cachedResultName”: “area”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/1pWheh5i4vpFiWfy1VkH3fp4s_bZEnuOSbZsM35frhSc/edit#gid=0”
},
“filtersUI”: {
“values”: [
{
“lookupColumn”: “area”,
“lookupValue”: “={{ $json.text }}”
}
]
},
“combineFilters”: “OR”,
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.6,
“position”: [
240,
-144
],
“id”: “95880024-7118-431a-ab52-7d0edb34292d”,
“name”: “Get row(s) in sheet”,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “3Ydzd3RIDC8Y4NZE”,
“name”: “Google Sheets account”
}
}
},
{
“parameters”: {
“assignments”: {
“assignments”: [
{
“id”: “fd75baee-e29e-4ded-a502-d0e77e12ec7f”,
“name”: “day”,
“value”: “={{ $json.day }}”,
“type”: “string”
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.set”,
“typeVersion”: 3.4,
“position”: [
432,
-144
],
“id”: “90a6b7a4-e602-4e0e-9abe-87a35a6f0d06”,
“name”: “Edit Fields”,
“alwaysOutputData”: true,
“onError”: “continueRegularOutput”
}
],
“connections”: {
“Basic LLM Chain”: {
“main”: [
[
{
“node”: “Get row(s) in sheet”,
“type”: “main”,
“index”: 0
}
]
]
},
“Google Gemini Chat Model”: {
“ai_languageModel”: [
[
{
“node”: “Basic LLM Chain”,
“type”: “ai_languageModel”,
“index”: 0
}
]
]
},
“When Executed by Another Workflow”: {
“main”: [
[
{
“node”: “Basic LLM Chain”,
“type”: “main”,
“index”: 0
}
]
]
},
“Get row(s) in sheet”: {
“main”: [
[
{
“node”: “Edit Fields”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “04695fa805d662a7ca811a5d9568e6cc080c07e6ec9f81360f8146eccb701cc6”
}
}