{ "edges": [ { "to": "41db9f75-f0f9-4e3c-a3c1-a45eb8ae5f2d", "from": "147ee7e8-a5e9-49ce-aa4c-c293f2992f0e", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "69f5e7fa-a6fa-484b-aa8c-d32537d504f4", "from": "910e8d50-c471-4fc2-af38-8e596c5208d3", "toPort": "0", "fromPort": "0" }, { "to": "9c64a8a4-057b-432d-a2c5-f41d7947bdca", "from": "294dd5aa-6ac3-4a69-8b60-5afebc6c239b", "toPort": "0", "fromPort": "0" }, { "to": "849c3cb4-d096-4681-9ff4-494046950319", "from": "2a7317c5-985f-4cdb-9b9a-ec70f929d583", "toPort": "0", "fromPort": "0" }, { "to": "ef10b14b-774d-4cfc-8507-1e0ed514e312", "from": "954f940a-fe0f-43fb-b86f-75892f45b97e", "toPort": "0", "fromPort": "1" }, { "to": "954f940a-fe0f-43fb-b86f-75892f45b97e", "from": "9c64a8a4-057b-432d-a2c5-f41d7947bdca", "toPort": "0", "fromPort": "0" }, { "to": "2a7317c5-985f-4cdb-9b9a-ec70f929d583", "from": "d1fb31c6-80f0-45b9-8807-94c66f5e5cb4", "toPort": "0", "fromPort": "0" }, { "to": "c29b6dab-bd39-4ac3-ace8-2dba69af093e", "from": "8619ad60-4d30-461e-8903-86c948bd3988", "toPort": "0", "fromPort": "0" }, { "to": "910e8d50-c471-4fc2-af38-8e596c5208d3", "from": "c29b6dab-bd39-4ac3-ace8-2dba69af093e", "toPort": "0", "fromPort": "0" }, { "to": "41db9f75-f0f9-4e3c-a3c1-a45eb8ae5f2d", "from": "ef10b14b-774d-4cfc-8507-1e0ed514e312", "toPort": "0", "fromPort": "0" }, { "to": "294dd5aa-6ac3-4a69-8b60-5afebc6c239b", "from": "849c3cb4-d096-4681-9ff4-494046950319", "toPort": "0", "fromPort": "0" }, { "to": "d1fb31c6-80f0-45b9-8807-94c66f5e5cb4", "from": "41db9f75-f0f9-4e3c-a3c1-a45eb8ae5f2d", "toPort": "0", "fromPort": "0" }, { "to": "954f940a-fe0f-43fb-b86f-75892f45b97e", "from": "69f5e7fa-a6fa-484b-aa8c-d32537d504f4", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "c29b6dab-bd39-4ac3-ace8-2dba69af093e", "name": "Fetch All Campaign", "type": "http", "params": { "url": "https://app.manyreach.com/api/campaigns", "options": {}, "sendQuery": true, "authentication": "genericCredentialType", "genericAuthType": "httpQueryAuth", "queryParameters": { "parameters": [ { "name": "limit", "value": "100" } ] } }, "position": [ -656, 448 ] }, { "id": "910e8d50-c471-4fc2-af38-8e596c5208d3", "name": "Split Out", "type": "passthrough", "params": { "mode": "splitOut", "field": "data", "options": {}, "fieldToSplitOut": "data" }, "position": [ -384, 448 ] }, { "id": "954f940a-fe0f-43fb-b86f-75892f45b97e", "name": "Loop Over Items", "type": "passthrough", "params": { "mode": "noOp", "options": {} }, "position": [ 176, 448 ] }, { "id": "69f5e7fa-a6fa-484b-aa8c-d32537d504f4", "name": "Filter Active & Completed Campaign", "type": "passthrough", "params": { "mode": "filter", "options": {}, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "loose" }, "combinator": "and", "conditions": [ { "id": "22eefede-be0f-4a73-848b-95741e9df874", "operator": { "type": "boolean", "operation": "equals" }, "leftValue": "={{ $json.active }}", "rightValue": true }, { "id": "60e38e2a-c77f-42a9-ac79-e9dfa47fb205", "operator": { "name": "filter.operator.equals", "type": "string", "operation": "equals" }, "leftValue": "={{ $json.campStatus }}", "rightValue": "completed" } ] }, "looseTypeValidation": true }, "position": [ -160, 448 ] }, { "id": "147ee7e8-a5e9-49ce-aa4c-c293f2992f0e", "name": "4.1", "type": "llm", "params": { "model": "gpt-4.1", "options": {}, "provider": "openai" }, "position": [ 592, 640 ] }, { "id": "d1fb31c6-80f0-45b9-8807-94c66f5e5cb4", "name": "Markdown -> HTML", "type": "passthrough", "params": { "mode": "noOp", "options": { "emoji": true, "tables": true }, "markdown": "={{ $json.output }}" }, "position": [ 944, 592 ] }, { "id": "2a7317c5-985f-4cdb-9b9a-ec70f929d583", "name": "Set Details", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "e7ee03ac-13e3-4fca-a7bc-57c8fc56dc42", "name": "document_name", "type": "string", "value": "=dfdfdfdf" }, { "id": "48a07ef2-ae46-4bfc-aa7e-d92a74ef46d6", "name": "html_content", "type": "string", "value": "={{ $json.data }}" }, { "id": "22b02fba-ba72-423a-b92f-1191a183a554", "name": "drive_folder_id", "type": "string", "value": "" } ] } }, "position": [ 1120, 592 ] }, { "id": "849c3cb4-d096-4681-9ff4-494046950319", "name": "HTML -> Magic 🪄", "type": "code", "params": { "jsCode": "const boundary = 'divider';\nconst docName = $input.first().json.document_name;\n// const folderId = $input.first().json.drive_folder_id;\nconst htmlContent = $input.first().json.html_content;\n\nconst metadata = JSON.stringify({\n name: docName,\n mimeType: \"application/vnd.google-apps.document\",\n // parents: [folderId]\n});\n\nconst htmlWithStyles = `\n\n\n\n \n \n\n\n ${htmlContent}\n\n\n`;\n\n// Construct the body with literal \\r\\n ONLY\nlet body = `--${boundary}\\r\\n`;\nbody += `Content-Type: application/json; charset=UTF-8\\r\\n`;\nbody += `\\r\\n`; // Blank line\nbody += `${metadata}\\r\\n`;\nbody += `--${boundary}\\r\\n`;\nbody += `Content-Type: text/html\\r\\n`;\nbody += `\\r\\n`; // Blank line\nbody += `${htmlWithStyles}\\r\\n`; // Add the HTML content\nbody += `--${boundary}--\\r\\n`; // Final boundary\n\nreturn {\n rawData: body \n};" }, "position": [ 1296, 592 ] }, { "id": "294dd5aa-6ac3-4a69-8b60-5afebc6c239b", "name": "Upload Doc", "type": "http", "params": { "url": "https://www.googleapis.com/upload/drive/v3/files", "body": "={{ $json.rawData }}", "method": "POST", "options": {}, "sendBody": true, "sendQuery": true, "contentType": "raw", "authentication": "predefinedCredentialType", "rawContentType": "multipart/related; boundary=divider", "queryParameters": { "parameters": [ { "name": "uploadType", "value": "multipart" }, { "name": "supportsAllDrives", "value": "true" } ] }, "nodeCredentialType": "googleDriveOAuth2Api" }, "position": [ 1472, 592 ] }, { "id": "9c64a8a4-057b-432d-a2c5-f41d7947bdca", "name": "Send a Doc Link", "type": "integration", "params": { "text": "=Campaign: {{ $('Fetch One Campaign').item.json.data.name }}\n\nReport Link: https://docs.google.com/document/d/{{ $json.id }}", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "C09V55TL5JN", "cachedResultName": "manyreach" }, "operation": "read", "otherOptions": { "mrkdwn": true, "includeLinkToWorkflow": false }, "authentication": "oAuth2" }, "position": [ 1648, 592 ] }, { "id": "8619ad60-4d30-461e-8903-86c948bd3988", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "weeks", "triggerAtDay": [ 1 ] } ] } }, "position": [ -928, 448 ] }, { "id": "41db9f75-f0f9-4e3c-a3c1-a45eb8ae5f2d", "name": "Campaign Report Agent", "type": "llm", "params": { "text": "=# Campaign Details:\n\n- Subject: {{ $json.data.subject }}\n- Body: {{ $json.data.body }}\n- Prospects: {{ $json.data.prospects }}\n- Replies: {{ $json.data.replies }}\n- OpenInitial: {{ $json.data.opensInitial }}\n- ClickInitial: {{ $json.data.clicksInitial }}\n- ReplyInitial: {{ $json.data.repliesInitial }}\n- Conversions: {{ $json.data.conversions }}\n- ConversionsInitial: {{ $json.data.conversionsInitial }}\n- InterestedInitial: {{ $json.data.interestedInitial }}\n- InterestedCount: {{ $json.data.interestedCount }}\n- From Emails: {{ $json.data.from.split(',').length }}\n- Campaign Name: {{ $json.data.name }}\n- Campaign Description: {{ $json.data.desc }}\n- Daily Limit: {{ $json.data.dailyLimit }}\n- conversionTrackingUrlParameter: {{ $json.data.conversionTrackingUrlParameter }}\n- DeactivateIfMissingPlaceholder: {{ $json.data.deactivateIfMissingPlaceholder }}\n- StopCoworkersOnReply: {{ $json.data.stopCoworkersOnReply }}\n- SendUnsubscribeListHeader: {{ $json.data.sendUnsubscribeListHeader }}\n- EspMatchType: {{ $json.data.espMatchType }}\n- EspMatchEnabled: {{ $json.data.espMatchEnabled }}\n- EspLimitEnabled: {{ $json.data.espLimitEnabled }}\n- EspLimitToMS: {{ $json.data.espLimitToMS }}\n- EspLimitToGoogle: {{ $json.data.espLimitToGoogle }}\n- EspLimitToOther: {{ $json.data.espLimitToOther }}\n- textOnlyEmails: {{ $json.data.textOnlyEmails }}", "prompt": "=# Campaign Details:\n\n- Subject: {{ $json.data.subject }}\n- Body: {{ $json.data.body }}\n- Prospects: {{ $json.data.prospects }}\n- Replies: {{ $json.data.replies }}\n- OpenInitial: {{ $json.data.opensInitial }}\n- ClickInitial: {{ $json.data.clicksInitial }}\n- ReplyInitial: {{ $json.data.repliesInitial }}\n- Conversions: {{ $json.data.conversions }}\n- ConversionsInitial: {{ $json.data.conversionsInitial }}\n- InterestedInitial: {{ $json.data.interestedInitial }}\n- InterestedCount: {{ $json.data.interestedCount }}\n- From Emails: {{ $json.data.from.split(',').length }}\n- Campaign Name: {{ $json.data.name }}\n- Campaign Description: {{ $json.data.desc }}\n- Daily Limit: {{ $json.data.dailyLimit }}\n- conversionTrackingUrlParameter: {{ $json.data.conversionTrackingUrlParameter }}\n- DeactivateIfMissingPlaceholder: {{ $json.data.deactivateIfMissingPlaceholder }}\n- StopCoworkersOnReply: {{ $json.data.stopCoworkersOnReply }}\n- SendUnsubscribeListHeader: {{ $json.data.sendUnsubscribeListHeader }}\n- EspMatchType: {{ $json.data.espMatchType }}\n- EspMatchEnabled: {{ $json.data.espMatchEnabled }}\n- EspLimitEnabled: {{ $json.data.espLimitEnabled }}\n- EspLimitToMS: {{ $json.data.espLimitToMS }}\n- EspLimitToGoogle: {{ $json.data.espLimitToGoogle }}\n- EspLimitToOther: {{ $json.data.espLimitToOther }}\n- textOnlyEmails: {{ $json.data.textOnlyEmails }}", "options": { "systemMessage": "You are an email campaign analytics expert. Analyze the provided campaign data and generate a comprehensive performance report.\n\n## Campaign Data Provided:\n- Campaign Name & Description\n- Email Content (Subject & Body)\n- Performance Metrics (Prospects, Replies, Opens, Clicks, Conversions, Interested)\n- Configuration Settings (Daily Limit, ESP settings, Email sending options)\n\n## Your Task:\nGenerate a detailed campaign performance report with the following sections:\n\n### 1. Executive Summary\n- Overall campaign performance (success/needs improvement)\n- Key achievements and highlights\n- Critical metrics at a glance\n\n### 2. Performance Metrics Analysis\n- **Engagement Rates:**\n - Open Rate: (opensInitial / prospects) × 100\n - Click Rate: (clicksInitial / prospects) × 100\n - Reply Rate: (repliesInitial / prospects) × 100\n - Interest Rate: (interestedInitial / prospects) × 100\n - Conversion Rate: (conversionsInitial / prospects) × 100\n\n- Compare these rates against industry benchmarks (typical cold email benchmarks: 40-50% open, 2-5% reply, 1-3% conversion)\n\n### 3. Email Content Analysis\n- Subject line effectiveness\n- Email body assessment (tone, length, clarity)\n- Suggestions for improvement\n\n### 4. Configuration Insights\n- Assessment of daily sending limit appropriateness\n- ESP distribution strategy evaluation\n- Unsubscribe and compliance settings review\n\n### 5. Actionable Recommendations\nProvide 3-5 specific, actionable recommendations for:\n- Improving engagement rates\n- Optimizing email content\n- Adjusting campaign settings\n- Scaling successful strategies\n\n### 6. Next Steps\nSuggest concrete next steps based on the campaign's performance level.\n\n## Output Format:\n- Use clear headings and subheadings\n- Include specific numbers and percentages\n- Be concise but thorough\n- Highlight both strengths and areas for improvement\n- Maintain a professional, constructive tone\n\nGenerate the report in markdown Only now based on the campaign details provided above." }, "provider": "openai", "promptType": "define", "approximated": true, "systemMessage": "You are an email campaign analytics expert. Analyze the provided campaign data and generate a comprehensive performance report.\n\n## Campaign Data Provided:\n- Campaign Name & Description\n- Email Content (Subject & Body)\n- Performance Metrics (Prospects, Replies, Opens, Clicks, Conversions, Interested)\n- Configuration Settings (Daily Limit, ESP settings, Email sending options)\n\n## Your Task:\nGenerate a detailed campaign performance report with the following sections:\n\n### 1. Executive Summary\n- Overall campaign performance (success/needs improvement)\n- Key achievements and highlights\n- Critical metrics at a glance\n\n### 2. Performance Metrics Analysis\n- **Engagement Rates:**\n - Open Rate: (opensInitial / prospects) × 100\n - Click Rate: (clicksInitial / prospects) × 100\n - Reply Rate: (repliesInitial / prospects) × 100\n - Interest Rate: (interestedInitial / prospects) × 100\n - Conversion Rate: (conversionsInitial / prospects) × 100\n\n- Compare these rates against industry benchmarks (typical cold email benchmarks: 40-50% open, 2-5% reply, 1-3% conversion)\n\n### 3. Email Content Analysis\n- Subject line effectiveness\n- Email body assessment (tone, length, clarity)\n- Suggestions for improvement\n\n### 4. Configuration Insights\n- Assessment of daily sending limit appropriateness\n- ESP distribution strategy evaluation\n- Unsubscribe and compliance settings review\n\n### 5. Actionable Recommendations\nProvide 3-5 specific, actionable recommendations for:\n- Improving engagement rates\n- Optimizing email content\n- Adjusting campaign settings\n- Scaling successful strategies\n\n### 6. Next Steps\nSuggest concrete next steps based on the campaign's performance level.\n\n## Output Format:\n- Use clear headings and subheadings\n- Include specific numbers and percentages\n- Be concise but thorough\n- Highlight both strengths and areas for improvement\n- Maintain a professional, constructive tone\n\nGenerate the report in markdown Only now based on the campaign details provided above." }, "position": [ 592, 464 ] }, { "id": "ef10b14b-774d-4cfc-8507-1e0ed514e312", "name": "Fetch One Campaign", "type": "http", "params": { "url": "=https://app.manyreach.com/api/campaigns/{{ $json.campaignID }}", "options": {}, "authentication": "genericCredentialType", "genericAuthType": "httpQueryAuth" }, "position": [ 416, 464 ] } ] }

Generate weekly cold email performance reports with ManyReach, GPT-4.1 & Slack