Workflow: Lmchatopenai Workflow
Integrations: manualTrigger, noOp, notion, set, stickyNote

{"meta": {"instanceId": "workflow-81a31fbb", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:54.993537", "updatedAt": "2025-09-29T07:07:54.993569", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "nodes": [{"id": "trigger-79609b87", "name": "Manual Trigger", "type": "n8n-nodes-base.manualTrigger", "typeVersion": 1, "position": [100, 100], "parameters": {}}, {"id": "d1d4291e-fa37-43d0-81e0-f0a594371426", "name": "OpenAI Chat Model", "type": "n8n-nodes-base.noOp", "position": [680, 620], "parameters": {"model": "gpt-4o", "options": {"timeout": 25000, "temperature": 0.7}}, "credentials": {"openAiApi": {"id": "AzPPV759YPBxJj3o", "name": "Max's DevRel OpenAI account"}}, "typeVersion": 1, "notes": "This lmChatOpenAi node performs automated tasks as part of the workflow."}, {"id": "68e6805b-9c19-4c9e-a300-8983f2b7c28a", "name": "Search notion database", "type": "n8n-nodes-base.noOp", "position": [980, 620], "parameters": {"url": "{{ $env.BASE_URL }}", "method": "POST", "jsonBody": "{\n \"filter\": {\n \"or\": [\n {\n \"property\": \"question\",\n \"rich_text\": {\n \"contains\": \"{keyword}\"\n }\n },\n {\n \"property\": \"tags\",\n \"multi_select\": {\n \"contains\": \"{tag}\"\n }\n }\n ]\n },\n \"sorts\": [\n {\n \"property\": \"updated_at\",\n \"direction\": \"ascending\"\n }\n ]\n}", "sendBody": true, "specifyBody": "json", "authentication": "{{ $credentials.predefinedCredentialType }}", "toolDescription": "=Use this tool to search the \"\" Notion app database.\n\nIt is structured with question and answer format. \nYou can filter query result by:\n- By keyword\n- filter by tag.\n\nKeyword and Tag have an OR relationship not AND.\n\n", "nodeCredentialType": "YOUR_CREDENTIAL_HERE", "placeholderDefinitions": {"values": [{"name": "keyword", "description": "Searches question of the record. Use one keyword at a time."}, {"name": "tag", "description": "=Options: {{ $json.tagsOptions }}"}]}}, "credentials": {"notionApi": {"id": "gfNp6Jup8rsmFLRr", "name": "max-bot"}}, "typeVersion": 1.1, "notes": "This toolHttpRequest node performs automated tasks as part of the workflow."}, {"id": "c3164d38-a9fb-4ee3-b6bd-fccb4aa5a1a4", "name": "Get database details", "type": "n8n-nodes-base.notion", "position": [420, 380], "parameters": {"simple": false, "resource": "database", "databaseId": {"__rl": true, "mode": "list", "value": "7ea9697d-4875-441e-b262-1105337d232e", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "StarLens Company Knowledge Base"}}, "credentials": {"notionApi": {"id": "gfNp6Jup8rsmFLRr", "name": "max-bot"}}, "typeVersion": 2.2, "notes": "This notion node performs automated tasks as part of the workflow."}, {"id": "98300243-efcc-4427-88da-c1af8a91ddae", "name": "Window Buffer Memory", "type": "n8n-nodes-base.noOp", "position": [820, 620], "parameters": {"contextWindowLength": 4}, "typeVersion": 1.2, "notes": "This memoryBufferWindow node performs automated tasks as part of the workflow."}, {"id": "a8473f48-1343-4eb2-8e48-ec89377a2a00", "name": "Search inside database record", "type": "n8n-nodes-base.noOp", "notes": " ", "position": [1140, 620], "parameters": {"url": "{{ $env.API_BASE_URL }}{page_id}/children", "fields": "id, type, paragraph.text, heading_1.text, heading_2.text, heading_3.text, bulleted_list_item.text, numbered_list_item.text, to_do.text, children", "dataField": "results", "authentication": "{{ $credentials.predefinedCredentialType }}", "fieldsToInclude": "selected", "toolDescription": "=Use this tool to retrieve Notion page content using the page ID. \n\nIt is structured with question and answer format. \nYou can filter query result by:\n- By keyword\n- filter by tag.\n\nKeyword and Tag have an OR relationship not AND.\n\n", "optimizeResponse": true, "nodeCredentialType": "YOUR_CREDENTIAL_HERE", "placeholderDefinitions": {"values": [{"name": "page_id", "description": "Notion page id from 'Search notion database' tool results"}]}}, "credentials": {"notionApi": {"id": "gfNp6Jup8rsmFLRr", "name": "max-bot"}}, "notesInFlow": true, "typeVersion": 1.1}, {"id": "115c328e-84b0-43d2-8df7-8b3f74cbb2fb", "name": "Format schema", "type": "n8n-nodes-base.set", "position": [620, 380], "parameters": {"options": {}, "assignments": {"assignments": [{"id": "a8e58791-ba51-46a2-8645-386dd1a0ff6e", "name": "sessionId", "type": "string", "value": "={{ $('When chat message received').item.json.sessionId }}"}, {"id": "434209de-39d5-43d8-a964-0fcb7396306c", "name": "action", "type": "string", "value": "={{ $('When chat message received').item.json.action }}"}, {"id": "cad4c972-51a9-4e16-a627-b00eea77eb30", "name": "chatInput", "type": "string", "value": "={{ $('When chat message received').item.json.chatInput }}"}, {"id": "8e88876c-2714-494d-bd5e-5e80c99f83e3", "name": "notionID", "type": "string", "value": "={{ $('Get database details').item.json.id }}"}, {"id": "a88a15f6-317c-4d2e-9d64-26f5ccaf7a97", "name": "databaseName", "type": "string", "value": "={{ $json.title[0].text.content }}"}, {"id": "7c3bf758-8ed3-469a-8695-6777f4af4fb9", "name": "tagsOptions", "type": "string", "value": "={{ $json.properties.tags.multi_select.options.map(item => item.name).join(',') }}"}]}}, "typeVersion": 3.4, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "3b82f4fe-6c0c-4e6e-a387-27de31fec758", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [-340, 240], "parameters": {"color": 6, "width": 462.3561535890252, "height": 95.12709218477178, "content": "## Notion knowledge base assistant [v1]\nBuilt as part of the [30 Day AI Sprint]({{ $env.WEBHOOK_URL }} by [@maxtkacz]({{ $env.WEBHOOK_URL }}\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "31debc55-6608-4e64-be18-1bc0fc0fbf16", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [-340, 1060], "parameters": {"color": 7, "width": 462.3561535890252, "height": 172.4760209818479, "content": "### FAQ\n- In `Get database details` if you see a `The resource you are requesting could not be found` error, you need to add your connection to the database (in the Notion app).\n- The `Get database details` pulls most recent `Tags` and informs AI Agent of them. However this step adds ~250-800ms per run. Watch detailed video to see how to remove this step. "}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "9f48e548-f032-477c-960d-9c99d61443df", "name": "AI Agent", "type": "n8n-nodes-base.noOp", "position": [820, 380], "parameters": {"text": "={{ $json.chatInput }}", "options": {"systemMessage": "=# Role:\nYou are a helpful agent. Query the \"{{ $json.databaseName }}\" Notion database to find relevant records or summarize insights based on multiple records.\n\n# Behavior:\n\nBe clear, very concise, efficient, and accurate in responses. Do not hallucinate.\nIf the request is ambiguous, ask for clarification. Do not embellish, only use facts from the Notion records. Do not offer general advice.\n\n# Error Handling:\n\nIf no matching records are found, try alternative search criteria. Example 1: Laptop, then Computer, then Equipment. Example 2: meetings, then meeting.\nClearly explain any issues with queries (e.g., missing fields or unsupported filters).\n\n# Output:\n\nReturn concise, user-friendly results or summaries.\nFor large sets, show top results by default and offer more if needed. Output URLs in markdown format. \n\nWhen a record has the answer to user question, always output the URL to that page. Do not output links twice."}, "promptType": "define"}, "typeVersion": 1.6, "notes": "This agent node performs automated tasks as part of the workflow."}, {"id": "f1274a12-128c-4549-a19b-6bfc3beccd89", "name": "When chat message received", "type": "n8n-nodes-base.noOp", "position": [220, 380], "webhookId": "b76d02c0-b406-4d21-b6bf-8ad2c623def3", "parameters": {"public": true, "options": {"title": "Notion Knowledge Base", "subtitle": ""}, "initialMessages": "=Happy {{ $today.weekdayLong }}!\nKnowledge source assistant at your service. How can I help you?"}, "typeVersion": 1.1, "notes": "This chatTrigger node performs automated tasks as part of the workflow."}, {"id": "2e25e4bc-7970-4d00-a757-ba1e418873aa", "name": "Sticky Note2", "type": "n8n-nodes-base.stickyNote", "position": [-340, 360], "parameters": {"color": 7, "width": 463.90418399676537, "height": 318.2958135288425, "content": "### Template set up quickstart video \ud83d\udc47\n[![Video Thumbnail]({{ $env.WEBHOOK_URL }}]({{ $env.WEBHOOK_URL }}\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "ba6fe953-fd5c-497f-ac2a-7afa04b7e6cc", "name": "Sticky Note3", "type": "n8n-nodes-base.stickyNote", "position": [-340, 700], "parameters": {"color": 7, "width": 461.5634274842711, "height": 332.14098134070576, "content": "### Written set up steps\n1. Add a Notion credential to your n8n workspace (follow [this Notion guide]({{ $env.WEBHOOK_URL }}\n2. [Duplicate Company knowledge base Notion template]({{ $env.WEBHOOK_URL }} to your Notion workspace, then make sure to share the new knowledge base with connection you created in Step 1. \n3. Add Notion cred to `Get database details`:`Credential to connect with` parameter, then to `Search notion database`:`Notion API` parameter (same for `Search inside database record`)\n4. Add OpenAI credential to `Open AI Chat Model` node (tested and working with Anthropic Claude 3.5 too)\n5. In `Get database details`, select the db you created from Step 2 in `Database` dropdown.\n6. Click `Chat` button to test the workflow. Then Activate it and copy the `Chat URL` from `When chat message received`."}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}], "pinData": {}, "connections": {"68e6805b-9c19-4c9e-a300-8983f2b7c28a": {"main": [[{"node": "error-handler-68e6805b-9c19-4c9e-a300-8983f2b7c28a", "type": "main", "index": 0}], [{"node": "error-handler-68e6805b-9c19-4c9e-a300-8983f2b7c28a-bd5255f9", "type": "main", "index": 0}], [{"node": "error-handler-68e6805b-9c19-4c9e-a300-8983f2b7c28a-e50525c6", "type": "main", "index": 0}], [{"node": "error-handler-68e6805b-9c19-4c9e-a300-8983f2b7c28a-d668ca27", "type": "main", "index": 0}], [{"node": "error-handler-68e6805b-9c19-4c9e-a300-8983f2b7c28a-a58ca5dc", "type": "main", "index": 0}], [{"node": "error-handler-68e6805b-9c19-4c9e-a300-8983f2b7c28a-86ef8671", "type": "main", "index": 0}], [{"node": "error-handler-68e6805b-9c19-4c9e-a300-8983f2b7c28a-da2a7f89", "type": "main", "index": 0}], [{"node": "error-handler-68e6805b-9c19-4c9e-a300-8983f2b7c28a-dce3c52d", "type": "main", "index": 0}], [{"node": "error-handler-68e6805b-9c19-4c9e-a300-8983f2b7c28a-d6175b0f", "type": "main", "index": 0}]]}, "a8473f48-1343-4eb2-8e48-ec89377a2a00": {"main": [[{"node": "error-handler-a8473f48-1343-4eb2-8e48-ec89377a2a00", "type": "main", "index": 0}], [{"node": "error-handler-a8473f48-1343-4eb2-8e48-ec89377a2a00-6745f018", "type": "main", "index": 0}], [{"node": "error-handler-a8473f48-1343-4eb2-8e48-ec89377a2a00-afc36d4b", "type": "main", "index": 0}], [{"node": "error-handler-a8473f48-1343-4eb2-8e48-ec89377a2a00-3e96946d", "type": "main", "index": 0}], [{"node": "error-handler-a8473f48-1343-4eb2-8e48-ec89377a2a00-28a3ca7a", "type": "main", "index": 0}], [{"node": "error-handler-a8473f48-1343-4eb2-8e48-ec89377a2a00-fc6810d4", "type": "main", "index": 0}], [{"node": "error-handler-a8473f48-1343-4eb2-8e48-ec89377a2a00-0acedbcf", "type": "main", "index": 0}], [{"node": "error-handler-a8473f48-1343-4eb2-8e48-ec89377a2a00-af78849c", "type": "main", "index": 0}], [{"node": "error-handler-a8473f48-1343-4eb2-8e48-ec89377a2a00-b56874a6", "type": "main", "index": 0}]]}, "d1d4291e-fa37-43d0-81e0-f0a594371426": {"main": [[{"node": "error-handler-d1d4291e-fa37-43d0-81e0-f0a594371426-f00a4131", "type": "main", "index": 0}]]}}, "name": "Lmchatopenai Workflow", "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "description": "Automated workflow: Lmchatopenai Workflow. This workflow integrates 9 different services: stickyNote, toolHttpRequest, agent, set, stopAndError. It contains 17 nodes and follows best practices for error handling and security.", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "notes": "Excellent quality workflow: Lmchatopenai Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}