{ "name": "Screen and score investment deals with AI using OpenAI, Gmail, and Telegram", "nodes": [ { "id": "d1010001-0001-4000-a000-000000000001", "name": "New Email Received", "type": "n8n-nodes-base.gmailTrigger", "position": [ 448, 608 ] }, { "id": "d1010002-0002-4000-a000-000000000002", "name": "Deal Submission Webhook", "type": "n8n-nodes-base.webhook", "position": [ 224, 416 ] }, { "id": "d1010003-0003-4000-a000-000000000003", "name": "Respond - Deal Received", "type": "n8n-nodes-base.respondToWebhook", "position": [ 448, 416 ] }, { "id": "d1010004-0004-4000-a000-000000000004", "name": "Normalize Email Data", "type": "n8n-nodes-base.set", "position": [ 672, 608 ] }, { "id": "d1010005-0005-4000-a000-000000000005", "name": "Normalize Webhook Data", "type": "n8n-nodes-base.set", "position": [ 672, 416 ] }, { "id": "d1010006-0006-4000-a000-000000000006", "name": "Build Deal Text", "type": "n8n-nodes-base.code", "position": [ 896, 512 ] }, { "id": "d1010007-0007-4000-a000-000000000007", "name": "Has Deal Content?", "type": "n8n-nodes-base.if", "position": [ 1120, 512 ] }, { "id": "d1010008-0008-4000-a000-000000000008", "name": "Extract Deal Info - OpenAI", "type": "@n8n/n8n-nodes-langchain.openAi", "position": [ 1344, 416 ] }, { "id": "d1010009-0009-4000-a000-000000000009", "name": "Merge Deal Fields", "type": "n8n-nodes-base.set", "position": [ 1696, 416 ] }, { "id": "d1010010-0010-4000-a000-000000000010", "name": "Score Deal - OpenAI", "type": "@n8n/n8n-nodes-langchain.openAi", "position": [ 1920, 416 ] }, { "id": "d1010011-0011-4000-a000-000000000011", "name": "Parse Score Results", "type": "n8n-nodes-base.set", "position": [ 2272, 416 ] }, { "id": "d1010012-0012-4000-a000-000000000012", "name": "Is PASS?", "type": "n8n-nodes-base.if", "position": [ 2496, 416 ] }, { "id": "d1010013-0013-4000-a000-000000000013", "name": "Is REVIEW?", "type": "n8n-nodes-base.if", "position": [ 2720, 512 ] }, { "id": "d1010014-0014-4000-a000-000000000014", "name": "Telegram - PASS Alert", "type": "n8n-nodes-base.telegram", "position": [ 2944, 224 ] }, { "id": "d1010015-0015-4000-a000-000000000015", "name": "Telegram - REVIEW Notice", "type": "n8n-nodes-base.telegram", "position": [ 2944, 416 ] }, { "id": "d1010016-0016-4000-a000-000000000016", "name": "Telegram - REJECT Log", "type": "n8n-nodes-base.telegram", "position": [ 2944, 608 ] }, { "id": "d1010017-0017-4000-a000-000000000017", "name": "Log Deal to Pipeline Sheet", "type": "n8n-nodes-base.googleSheets", "position": [ 3168, 416 ] }, { "id": "d1010018-0018-4000-a000-000000000018", "name": "Stop - No Deal Content", "type": "n8n-nodes-base.stopAndError", "position": [ 1408, 608 ] }, { "id": "5c37b238-9cc3-467c-a033-f1a351f46b24", "name": "Section - Intake", "type": "n8n-nodes-base.stickyNote", "position": [ 176, 256 ], "parameters": { "width": 1060, "height": 546, "content": "### Intake & validate\nDeals enter via Gmail or webhook. Both paths normalize into the same fields. Build Deal Text combines everything into a single string for AI processing. Empty submissions are sto" } }, { "id": "a0405eda-4270-4d7c-8566-da33c7ceb409", "name": "Section - Screen", "type": "n8n-nodes-base.stickyNote", "position": [ 1248, 272 ], "parameters": { "width": 1138, "height": 532, "content": "### AI extraction & scoring\nFirst OpenAI call extracts structured deal info. Second call scores on 5 weighted criteria (industry fit, revenue, growth, team, clarity) and assigns a verdict." } }, { "id": "b809330a-b9c1-4a90-8b4b-6e20e6d666b7", "name": "Section - Route", "type": "n8n-nodes-base.stickyNote", "position": [ 2416, 80 ], "parameters": { "width": 920, "height": 726, "content": "### Route & log\nRoutes by verdict: PASS (7.5+), REVIEW (5-7.4), REJECT (<5). Each tier gets a Telegram notification. All deals are appended to the Google Sheets pipeline." } }, { "id": "ff2c6e64-9793-49bb-89c2-4cc0c783bf1d", "name": "Warning", "type": "n8n-nodes-base.stickyNote", "position": [ 176, 128 ], "parameters": { "width": 412, "height": 120, "content": "**Dont forget to** Replace YOUR_TELEGRAM_CHAT_ID in all three Telegram nodes and YOUR_GOOGLE_SHEET_ID in the Log Deal node before activating. Connect all five credentials (Gmail, OpenAI, Telegram, She" } }, { "id": "26548bc4-55b0-4894-8252-55156547ed3f", "name": "Main Description", "type": "n8n-nodes-base.stickyNote", "position": [ -496, -144 ], "parameters": { "width": 640, "height": 944, "content": "## Screen and Score Investment Deals with AI\n\nScreens incoming deal submissions via email or webhook, extracts key data with OpenAI, scores against 5 weighted investment criteria, and sends Telegram a" } } ], "connections": { "Is PASS?": { "main": [ [ { "node": "Telegram - PASS Alert", "type": "main", "index": 0 } ], [ { "node": "Is REVIEW?", "type": "main", "index": 0 } ] ] }, "Is REVIEW?": { "main": [ [ { "node": "Telegram - REVIEW Notice", "type": "main", "index": 0 } ], [ { "node": "Telegram - REJECT Log", "type": "main", "index": 0 } ] ] }, "Build Deal Text": { "main": [ [ { "node": "Has Deal Content?", "type": "main", "index": 0 } ] ] }, "Has Deal Content?": { "main": [ [ { "node": "Extract Deal Info - OpenAI", "type": "main", "index": 0 } ], [ { "node": "Stop - No Deal Content", "type": "main", "index": 0 } ] ] }, "Merge Deal Fields": { "main": [ [ { "node": "Score Deal - OpenAI", "type": "main", "index": 0 } ] ] }, "New Email Received": { "main": [ [ { "node": "Normalize Email Data", "type": "main", "index": 0 } ] ] }, "Parse Score Results": { "main": [ [ { "node": "Is PASS?", "type": "main", "index": 0 } ] ] }, "Score Deal - OpenAI": { "main": [ [ { "node": "Parse Score Results", "type": "main", "index": 0 } ] ] }, "Normalize Email Data": { "main": [ [ { "node": "Build Deal Text", "type": "main", "index": 0 } ] ] }, "Telegram - PASS Alert": { "main": [ [ { "node": "Log Deal to Pipeline Sheet", "type": "main", "index": 0 } ] ] }, "Telegram - REJECT Log": { "main": [ [ { "node": "Log Deal to Pipeline Sheet", "type": "main", "index": 0 } ] ] }, "Normalize Webhook Data": { "main": [ [ { "node": "Build Deal Text", "type": "main", "index": 0 } ] ] }, "Deal Submission Webhook": { "main": [ [ { "node": "Respond - Deal Received", "type": "main", "index": 0 } ] ] }, "Respond - Deal Received": { "main": [ [ { "node": "Normalize Webhook Data", "type": "main", "index": 0 } ] ] }, "Telegram - REVIEW Notice": { "main": [ [ { "node": "Log Deal to Pipeline Sheet", "type": "main", "index": 0 } ] ] }, "Extract Deal Info - OpenAI": { "main": [ [ { "node": "Merge Deal Fields", "type": "main", "index": 0 } ] ] } } }