SQLite Web: database.sqlite

versionId

Primary key. varchar(36) NOT NULL

workflowId

varchar(36) NOT NULL

authors

varchar(255) NOT NULL

createdAt

datetime(3) NOT NULL (default STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')

updatedAt

datetime(3) NOT NULL (default STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')

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 NOT NULL

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 NOT NULL

name

varchar(128)

autosaved

boolean NOT NULL (default false

description

TEXT

nodeGroups

TEXT NOT NULL (default '[]'

database.sqlite — workflow_history

Update row 0f3773bd-63ac-4cb0-b97f-45aa9e6f85b3 in workflow_history