SQLite Web: database.sqlite

id

Primary key. varchar(36) NOT NULL

name

varchar(128) NOT NULL

active

boolean NOT NULL

nodes

[{"parameters":{"promptType":"define","text":"={{ $json.text }}","needsFallback":true,"options":{"systemMessage":"=Bạn là một trợ lý chuyên nghiệp.\nHãy phân tích, tóm tắt và nhập các thông tin vào Google Calendar.\nTrả về dữ liệu có cấu trúc sau cho người dùng, dạng text thuần túy, không phải Markdown:\n\n- Tiêu đề:\n- Thời gian:\n- Địa điểm:\n- Nội dung tóm tắt:\n- Link google calendar:"}},"type":"@n8n/n8n-nodes-langchain.agent","typeVersion":2.2,"position":[2880,816],"id":"9d3ea1e1-cb43-4e89-9324-1ca913edb9fc","name":"AI Agent","onError":"continueErrorOutput"},{"parameters":{"calendar":{"__rl":true,"value":"hoanggiaovien2026@gmail.com","mode":"list","cachedResultName":"hoanggiaovien2026@gmail.com"},"start":"={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Start', `(GMT+07:00) Asia/Ho_Chi_Minh`, 'string') }}","end":"={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('End', `(GMT+07:00) Asia/Ho_Chi_Minh`, 'string') }}","additionalFields":{"description":"={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Description', ``, 'string') }}","location":"={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Location', ``, 'string') }}","summary":"={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Summary', ``, 'string') }}"}},"type":"n8n-nodes-base.googleCalendarTool","typeVersion":1.3,"position":[3104,1008],"id":"bdca23cc-9e4f-4b46-aba2-43109a24266c","name":"Create an event in Google Calendar","credentials":{"googleCalendarOAuth2Api":{"id":"BlAI0BHbdgcKZN6b","name":"hoanggiaovien2026@gmail.com"}}},{"parameters":{"rules":{"values":[{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"leftValue":"={{ $json.data.msgType }}","rightValue":"chat.photo","operator":{"type":"string","operation":"equals"},"id":"b3a65a6c-7e5c-4afb-8caa-922d8b487230"}],"combinator":"and"},"renameOutput":true,"outputKey":"Photo"},{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"2071a0a5-ac82-452c-80bc-5e0615d9a344","leftValue":"={{ $json.data.msgType }}","rightValue":"share.file","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"},"renameOutput":true,"outputKey":"PDF"}]},"options":{}},"type":"n8n-nodes-base.switch","typeVersion":3.2,"position":[1520,816],"id":"4481cc6f-45f1-4eec-aa32-3c0968af8832","name":"Switch"},{"parameters":{"resource":"image","operation":"analyze","modelId":{"__rl":true,"value":"models/gemini-2.5-pro","mode":"list","cachedResultName":"models/gemini-2.5-pro"},"text":"Extract all text content in file image url","imageUrls":"={{ $('Zalo Event Trigger').item.json.data.content.href }}","options":{}},"type":"@n8n/n8n-nodes-langchain.googleGemini","typeVersion":1,"position":[1984,496],"id":"b6427b20-385a-476d-8a8d-5d3ce6382f6d","name":"Analyze image","credentials":{"googlePalmApi":{"id":"su7zMLYMOp13bt1l","name":"Google Gemini(PaLM) Api account"}}},{"parameters":{"resource":"document","modelId":{"__rl":true,"value":"models/gemini-2.5-flash","mode":"list","cachedResultName":"models/gemini-2.5-flash"},"text":"Extract all text content in document url","documentUrls":"={{ $('Zalo Event Trigger').item.json.data.content.href }}","options":{}},"type":"@n8n/n8n-nodes-langchain.googleGemini","typeVersion":1,"position":[1984,1168],"id":"4459adb1-705f-4861-b5ee-928975751434","name":"Analyze document","credentials":{"googlePalmApi":{"id":"su7zMLYMOp13bt1l","name":"Google Gemini(PaLM) Api account"}}},{"parameters":{"model":{"__rl":true,"mode":"list","value":"gpt-4.1-mini"},"options":{}},"type":"@n8n/n8n-nodes-langchain.lmChatOpenAi","typeVersion":1.2,"position":[2720,1008],"id":"aa729847-3c42-4a5f-819a-3f99ebe85a60","name":"OpenAI Chat Model","credentials":{"openAiApi":{"id":"v5NxhTmXpMWSe8nd","name":"OpenAI account"}}},{"parameters":{"assignments":{"assignments":[{"id":"69aa03b7-671a-47d5-9561-5a0213c2fe65","name":"text","value":"={{ $json.pages[0].markdown }}","type":"string"}]},"options":{}},"type":"n8n-nodes-base.set","typeVersion":3.4,"position":[2608,816],"id":"cab9a345-ea91-4641-908c-d66cdc84736b","name":"Edit Fields"},{"parameters":{"method":"POST","url":"https://script.google.com/macros/s/AKfycbxlQpKOuQDvTPePkCRWBXR39SYPNJBKvxe_eTK31pJKxgnv5HsGLto5GsxsvTtaOzvc/exec","sendBody":true,"specifyBody":"json","jsonBody":"={{ JSON.stringify($json)}}","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1520,1008],"id":"953a2368-c6b6-404f-bdea-96bceab5e324","name":"HTTP Request"},{"parameters":{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"5fc7a7b8-de11-4daf-b999-7f75b07cc863","leftValue":"={{ $json.data.uidFrom }}","rightValue":"6988156783950298935","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"},"options":{}},"type":"n8n-nodes-base.if","typeVersion":2.2,"position":[1264,832],"id":"96c070df-2c29-4f27-9f21-7847bd5d1af4","name":"If"},{"parameters":{"modelName":"models/gemini-2.5-pro","options":{}},"type":"@n8n/n8n-nodes-langchain.lmChatGoogleGemini","typeVersion":1,"position":[2912,1008],"id":"50ca0197-e0ae-4911-864d-a0a21fbb9b9c","name":"Google Gemini Chat Model","credentials":{"googlePalmApi":{"id":"su7zMLYMOp13bt1l","name":"Google Gemini(PaLM) Api account"}}},{"parameters":{},"type":"n8n-nodes-social-zalo.zaloUserLogin","typeVersion":3,"position":[1024,608],"id":"1222dbd4-2296-41bb-8a64-42b338c98271","name":"Zalo Login Via QR Code","credentials":{}},{"parameters":{},"type":"n8n-nodes-social-zalo.zaloUser","typeVersion":1,"position":[864,832],"id":"993a67cc-cd9c-4ef2-bcf3-29af3e3b3e6c","name":"Zalo Event Trigger","credentials":{}},{"parameters":{"threadId":"={{ $json.threadId }}","message":"Đã tiếp nhận Hình ảnh và đang phân tích","threadType":"={{ $json.type }}"},"type":"n8n-nodes-social-zalo.zaloUserInteract","typeVersion":1,"position":[1760,720],"id":"103aa69d-917d-44c1-bcc6-9e8de8ed0707","name":"Send Message Image","credentials":{}},{"parameters":{"threadId":"={{ $json.threadId }}","message":"Đã tiếp nhận PDF và đang phân tích","threadType":"={{ $json.type }}"},"type":"n8n-nodes-social-zalo.zaloUserInteract","typeVersion":1,"position":[1760,944],"id":"10f2457d-eaaf-45c4-aed1-acf970d1ceec","name":"Send Message PDF","credentials":{}},{"parameters":{"threadId":"={{ $('Zalo Event Trigger').item.json.threadId }}","message":"Đang tóm tắt nội dung & cập nhật vào Google Calendar","threadType":"={{ $('Zalo Event Trigger').item.json.type }}"},"type":"n8n-nodes-social-zalo.zaloUserInteract","typeVersion":1,"position":[2880,624],"id":"9bcf2226-9fad-40da-b47b-283eee1d6653","name":"Send Message","credentials":{}},{"parameters":{"threadId":"={{ $('Zalo Event Trigger').item.json.threadId }}","message":"={{ $json.output }}","threadType":"={{ $('Zalo Event Trigger').item.json.type }}"},"type":"n8n-nodes-social-zalo.zaloUserInteract","typeVersion":1,"position":[3280,736],"id":"cb556b60-cf7c-4992-be78-cf9ae68b4c1c","name":"Send Success","credentials":{}},{"parameters":{"threadId":"={{ $('Zalo Event Trigger').item.json.threadId }}","message":"={{ $json.output }}","threadType":"={{ $('Zalo Event Trigger').item.json.type }}"},"type":"n8n-nodes-social-zalo.zaloUserInteract","typeVersion":1,"position":[3280,928],"id":"ed11a1d6-b460-4e90-aa0d-7d601df39424","name":"Send Error","credentials":{}},{"parameters":{"options":{}},"type":"n8n-nodes-base.mistralAi","typeVersion":1,"position":[2208,944],"id":"b432195f-2f33-46e3-b754-bb9c67875d7e","name":"Extract PDF","credentials":{"mistralCloudApi":{"id":"YjNytnj56U2VFsH0","name":"Mistral Cloud account"}}},{"parameters":{"documentType":"image_url","options":{}},"type":"n8n-nodes-base.mistralAi","typeVersion":1,"position":[2208,720],"id":"51a1839e-a422-4a1d-a839-61d99fde4c50","name":"Extract IMG","credentials":{"mistralCloudApi":{"id":"YjNytnj56U2VFsH0","name":"Mistral Cloud account"}}},{"parameters":{},"type":"n8n-nodes-base.wait","typeVersion":1.1,"position":[1072,832],"id":"473ba20d-b107-4777-98f2-ffabab897eec","name":"Wait","webhookId":"ffaf6cd2-ec22-405a-9118-d6f49413a5e1"},{"parameters":{"url":"={{ $('Zalo Event Trigger').item.json.data.content.href }}","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.4,"position":[1984,944],"id":"6bc9e407-d152-40ae-bff7-2111f5519d24","name":"Get PDF"},{"parameters":{"url":"={{ $('Zalo Event Trigger').item.json.data.content.href }}","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.4,"position":[1984,720],"id":"91c1b2f1-2787-45eb-82c0-8337109ba1e9","name":"Get IMG"}]

TEXT

connections

{"Create an event in Google Calendar":{"ai_tool":[[{"node":"AI Agent","type":"ai_tool","index":0}]]},"Switch":{"main":[[{"node":"Send Message Image","type":"main","index":0}],[{"node":"Send Message PDF","type":"main","index":0}]]},"AI Agent":{"main":[[{"node":"Send Success","type":"main","index":0}],[{"node":"Send Error","type":"main","index":0}]]},"OpenAI Chat Model":{"ai_languageModel":[[{"node":"AI Agent","type":"ai_languageModel","index":0}]]},"Edit Fields":{"main":[[{"node":"AI Agent","type":"main","index":0},{"node":"Send Message","type":"main","index":0}]]},"If":{"main":[[{"node":"Switch","type":"main","index":0}],[{"node":"HTTP Request","type":"main","index":0}]]},"Google Gemini Chat Model":{"ai_languageModel":[[{"node":"AI Agent","type":"ai_languageModel","index":1}]]},"Zalo Event Trigger":{"main":[[{"node":"Wait","type":"main","index":0}]]},"Send Message Image":{"main":[[{"node":"Get IMG","type":"main","index":0}]]},"Send Message PDF":{"main":[[{"node":"Get PDF","type":"main","index":0}]]},"Extract PDF":{"main":[[{"node":"Edit Fields","type":"main","index":0}]]},"Extract IMG":{"main":[[{"node":"Edit Fields","type":"main","index":0}]]},"Wait":{"main":[[{"node":"If","type":"main","index":0}]]},"Get PDF":{"main":[[{"node":"Extract PDF","type":"main","index":0}]]},"Get IMG":{"main":[[{"node":"Extract IMG","type":"main","index":0}]]}}

TEXT

settings

TEXT

staticData

TEXT

pinData

TEXT

versionId

varchar(36) NOT NULL

triggerCount

INTEGER (default 0

database.sqlite — workflow_entity

Update row 7BDgQrz1KMOtzZGM in workflow_entity