Şablonlara geri dön
İŞ AKIŞI ŞABLONU
AI Lead Qualification
5 düğümAI_Lead_Qualification-workflow.json
{"id": "D3gKQ4UE1XR2TC8n","meta": {"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177","templateCredsSetupCompleted": true},"name": "AI lead qualification","tags": [],"nodes": [{"id": "4c1057b9-9d53-47b3-a319-b726d87759b4","name": "Google Sheets Trigger","type": "n8n-nodes-base.googleSheetsTrigger","position": [-544,-128],"parameters": {"options": {},"pollTimes": {"item": [{"mode": "everyMinute"}]},"sheetName": {"__rl": true,"mode": "list","value": 931869588,"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cOFWYxogbcRih5akkyApvBsV7vXPTFWUjAGtJe-fwEI/edit#gid=931869588","cachedResultName": "Form Responses 1"},"documentId": {"__rl": true,"mode": "list","value": "1cOFWYxogbcRih5akkyApvBsV7vXPTFWUjAGtJe-fwEI","cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cOFWYxogbcRih5akkyApvBsV7vXPTFWUjAGtJe-fwEI/edit?usp=drivesdk","cachedResultName": "Product Review form (Responses)"}},"credentials": {"googleSheetsTriggerOAuth2Api": {"id": "tjY8nawuuRO1rxAE","name": "Google Sheets Trigger account"}},"typeVersion": 1},{"id": "5abf8a0d-a5d9-46d6-8e3d-097158a50d9b","name": "Code - Parse AI JSON","type": "n8n-nodes-base.code","position": [32,-128],"parameters": {"jsCode": "// Loop over all input items\nfor (const item of $input.all()) {\n // Add a new field\n item.json.myNewField = 1;\n\n // Parse the stringified JSON in 'output'\n const parsed = JSON.parse(item.json.output);\n const sheet = $('Google Sheets Trigger').first().json;\n\n // Extract and assign values\n item.json.Timestamp = sheet.Timestamp;\n item.json.Name = sheet.Name;\n item.json.Email = sheet.Email;\n item.json['Contact Number'] = sheet['Contact Number'];\n item.json['Review of the product'] = sheet['Review of the product'];\n item.json.intent = parsed.intent;\n item.json.sentiment = parsed.sentiment;\n item.json.score = parsed.score;\n item.json.summary = parsed.summary;\n\n\n delete item.json.output;\n delete item.json.myNewField;\n}\n\n// Return updated items\nreturn $input.all();\n"},"typeVersion": 2},{"id": "908c833d-4230-45b6-a7ae-d3f3d4d4ac51","name": "Google Sheets - Update Lead","type": "n8n-nodes-base.googleSheets","position": [256,-128],"parameters": {"columns": {"value": {"Name": "={{ $json.Name }}","Email": "={{ $json.Email }}","Score": "={{ $json.score }}","Intent": "={{ $json.intent }}","Summary": "={{ $json.summary }}","Sentiment": "={{ $json.sentiment }}","Timestamp": "={{ $json.Timestamp }}","row_number": 0,"Contact Number": "={{ $json[\"Contact Number\"] }}","Review of the product": "={{ $json[\"Review of the product\"] }}"},"schema": [{"id": "Timestamp","type": "string","display": true,"required": false,"displayName": "Timestamp","defaultMatch": false,"canBeUsedToMatch": true},{"id": "Name","type": "string","display": true,"required": false,"displayName": "Name","defaultMatch": false,"canBeUsedToMatch": true},{"id": "Email","type": "string","display": true,"required": false,"displayName": "Email","defaultMatch": false,"canBeUsedToMatch": true},{"id": "Contact Number","type": "string","display": true,"required": false,"displayName": "Contact Number","defaultMatch": false,"canBeUsedToMatch": true},{"id": "Review of the product","type": "string","display": true,"required": false,"displayName": "Review of the product","defaultMatch": false,"canBeUsedToMatch": true},{"id": "Intent","type": "string","display": true,"removed": false,"required": false,"displayName": "Intent","defaultMatch": false,"canBeUsedToMatch": true},{"id": "Sentiment","type": "string","display": true,"removed": false,"required": false,"displayName": "Sentiment","defaultMatch": false,"canBeUsedToMatch": true},{"id": "Score","type": "string","display": true,"removed": false,"required": false,"displayName": "Score","defaultMatch": false,"canBeUsedToMatch": true},{"id": "Summary","type": "string","display": true,"removed": false,"required": false,"displayName": "Summary","defaultMatch": false,"canBeUsedToMatch": true},{"id": "row_number","type": "number","display": true,"removed": false,"readOnly": true,"required": false,"displayName": "row_number","defaultMatch": false,"canBeUsedToMatch": true}],"mappingMode": "defineBelow","matchingColumns": ["row_number"],"attemptToConvertTypes": false,"convertFieldsToString": false},"options": {},"operation": "appendOrUpdate","sheetName": {"__rl": true,"mode": "list","value": "gid=0","cachedResultUrl": "https://docs.google.com/spreadsheets/d/1qohS8H6x3_CrXiT0t1jpxjDk_YbEbHrkAa2tDHWJCc4/edit#gid=0","cachedResultName": "Sheet1"},"documentId": {"__rl": true,"mode": "list","value": "1qohS8H6x3_CrXiT0t1jpxjDk_YbEbHrkAa2tDHWJCc4","cachedResultUrl": "https://docs.google.com/spreadsheets/d/1qohS8H6x3_CrXiT0t1jpxjDk_YbEbHrkAa2tDHWJCc4/edit?usp=drivesdk","cachedResultName": "Updated product review"}},"credentials": {"googleSheetsOAuth2Api": {"id": "s4dP1fNuVZ2gWvs3","name": "Google Sheets account"}},"typeVersion": 4},{"id": "8d30516b-719c-4d62-a419-571423e98969","name": "AI Agent","type": "@n8n/n8n-nodes-langchain.agent","position": [-336,-128],"parameters": {"text": "=Here is the customer review data: {{ $json[\"Review of the product\"] }}","options": {"systemMessage": "=You are an AI assistant that analyzes customer product reviews.\nYour job is to:\n\nUnderstand the customer’s intent (e.g., praise, complaint, suggestion, feature request, mixed feedback).\n\nEvaluate the sentiment (positive, neutral, negative, or mixed).\n\nAssign a score from 1–10 (1 = very negative, 10 = excellent).\n\nReturn results in clean JSON format with these keys:\n\nintent\n\nsentiment\n\nscore\n\nsummary (short 1–2 sentence summary of the review).\n\nDo not add extra commentary outside the JSON."},"promptType": "define"},"typeVersion": 2.1},{"id": "789b8347-91ce-4152-9eaf-7a7550016897","name": "Azure OpenAI Chat Model","type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi","position": [-352,32],"parameters": {"model": "gpt-4o-mini","options": {}},"credentials": {"azureOpenAiApi": {"id": "C3WzT18XqF8OdVM6","name": "Azure Open AI account"}},"typeVersion": 1},{"id": "ab65ad1f-f875-437b-bb05-4decf1d27c8b","name": "Sticky Note","type": "n8n-nodes-base.stickyNote","position": [-688,-496],"parameters": {"width": 288,"height": 336,"content": "## Node 1: Google Sheets Trigger\n**Type**: Trigger Node\n**Purpose**: Data Source Monitor\n**Description**: This node continuously monitors a spreadsheet for new customer review submissions. It polls the data source at regular intervals (every minute) and automatically triggers the workflow whenever new form responses are detected. The node is configured to watch a specific sheet containing customer feedback data including timestamps, names, contact information, and product reviews."},"typeVersion": 1},{"id": "a7c641fd-b529-4038-b5ed-2c18d2eea2be","name": "Sticky Note1","type": "n8n-nodes-base.stickyNote","position": [-336,-544],"parameters": {"width": 272,"height": 384,"content": "## Node 2: AI Agent\n **Type**: AI Processing Node\n**Purpose**: Review Analysis Engine\n**Description**: This node processes customer review text using an AI language model. It analyzes the review content to determine customer intent (such as praise, complaint, suggestion, or feature request), evaluates sentiment (positive, negative, neutral, or mixed), assigns a numerical score from 1-10, and generates a concise summary. The node is configured with specific system prompts to ensure consistent JSON-formatted output containing intent, sentiment, score, and summary fields."},"typeVersion": 1},{"id": "d132ceb8-058a-434f-b872-5aab1275ee2d","name": "Sticky Note2","type": "n8n-nodes-base.stickyNote","position": [-592,144],"parameters": {"height": 384,"content": "## Node 3: Azure OpenAI Chat Model\n**Type**: AI Model Connection\n**Purpose**: Language Model Provider\n**Description**: This node provides the AI language model capability to the AI Agent node. It connects to an external AI service using the GPT-4o-mini model and handles the actual natural language processing tasks. The node manages the API connection and model configuration required for the review analysis functionality."},"typeVersion": 1},{"id": "9ae50a46-7c45-47b0-85cc-d11731138f66","name": "Sticky Note3","type": "n8n-nodes-base.stickyNote","position": [-48,32],"parameters": {"height": 432,"content": "## Node 4: Code - Parse AI JSON\n**Type**: Data Processing Node\n**Purpose**: Data Parser and Formatter\n**Description**: This node processes the AI analysis results and combines them with the original customer data. It extracts the JSON response from the AI agent, parses the intent, sentiment, score, and summary fields, and merges this information with the original customer details (timestamp, name, email, contact number, and review text). The node also cleans up temporary fields and prepares the data for final storage."},"typeVersion": 1},{"id": "91c624b3-9f27-4d26-8918-fe7e27e092e1","name": "Sticky Note4","type": "n8n-nodes-base.stickyNote","position": [112,-560],"parameters": {"width": 256,"height": 416,"content": "## Node 5: Google Sheets - Update Lead\n**Type**: Data Storage Node\n**Purpose**: Enhanced Data Writer\n**Description**: This node saves the processed results to a destination spreadsheet. It takes the combined customer information and AI analysis results and appends them to a target sheet. The node is configured to write specific columns including all original customer data plus the new AI-generated insights (intent, sentiment, score, summary), creating a comprehensive customer feedback database."},"typeVersion": 1}],"active": false,"pinData": {},"settings": {"executionOrder": "v1"},"versionId": "79ed4ff6-5908-4fff-9cb7-a4ed0f023328","connections": {"AI Agent": {"main": [[{"node": "Code - Parse AI JSON","type": "main","index": 0}]]},"Code - Parse AI JSON": {"main": [[{"node": "Google Sheets - Update Lead","type": "main","index": 0}]]},"Google Sheets Trigger": {"main": [[{"node": "AI Agent","type": "main","index": 0}]]},"Azure OpenAI Chat Model": {"ai_languageModel": [[{"node": "AI Agent","type": "ai_languageModel","index": 0}]]}}}
n8n Editöründe: Ctrl+V ile yapıştırın→İş akışı oluşturulacak