العودة إلى القوالب
قالب سير عمل
Sticky Note1 2 | Operasyon için n8n Otomasyon İş Akışı Şablonu (HTTP, Filtre, Slack)
n8n için hazır otomasyon şablonu: Sticky Note1 2. 13 düğüm. Entegrasyonlar: HTTP, Filtre, Slack. JSON'u kopyalayıp n8n'e içe aktarın.
13 العُقدSticky_Note1_2-workflow.json
{"meta": {"instanceId": "6c118a8acfbd6c5a7401dc5bfa65b57bbe715feb57d00cd265fb540cc778096d","templateCredsSetupCompleted": true},"nodes": [{"id": "1c6d63fb-c7a7-43b2-a227-869b5a2dbddd","name": "Sticky Note1","type": "n8n-nodes-base.stickyNote","position": [-1840,176],"parameters": {"width": 736,"height": 624,"content": "# 📧 ManyReach Weekly Cold Email Campaign Report📃\n\nThis workflow automates your weekly cold email reporting. It identifies completed campaigns in ManyReach, uses AI to analyze their performance against industry benchmarks, and generates a professional Google Doc report for your team.\n\n### How it works\n1. **Trigger:** Runs automatically once a week (e.g., Monday mornings).\n2. **Fetch & Filter:** Retrieves all campaigns from ManyReach and filters specifically for campaigns that are marked \"Active\" yet have a status of \"Completed.\"\n3. **AI Analyst:** GPT-4 analyzes the campaign metrics (Open Rate, Reply Rate, Conversions) and writes a strategic report including actionable recommendations.\n4. **Document Generation:** The workflow converts the AI's Markdown report into HTML and uses a custom code node to format it as a native Google Doc.\n5. **Upload & Notify:** The report is uploaded to Google Drive, and a direct link is sent to your Slack channel.\n\n### Setup steps\n1. **Credentials:** Configure credentials for **ManyReach**, **OpenAI**, **Google Drive**, and **Slack**.\n2. **Drive Folder:** Open the **Set Details** node and paste the `drive_folder_id` where you want the reports saved.\n3. **Slack Channel:** Open the **Send a Doc Link** node and select the channel where the team should receive the reports.\n4. **API URL:** Ensure the ManyReach API endpoints in the HTTP nodes match your specific account region if necessary."},"typeVersion": 1},{"id": "c29b6dab-bd39-4ac3-ace8-2dba69af093e","name": "Fetch All Campaign","type": "n8n-nodes-base.httpRequest","position": [-656,448],"parameters": {"url": "https://app.manyreach.com/api/campaigns","options": {},"sendQuery": true,"authentication": "genericCredentialType","genericAuthType": "httpQueryAuth","queryParameters": {"parameters": [{"name": "limit","value": "100"}]}},"credentials": {"httpQueryAuth": {"id": "E8eXoDHCV2wWrAlg","name": "ManyReach"}},"typeVersion": 4.3},{"id": "910e8d50-c471-4fc2-af38-8e596c5208d3","name": "Split Out","type": "n8n-nodes-base.splitOut","position": [-384,448],"parameters": {"options": {},"fieldToSplitOut": "data"},"typeVersion": 1},{"id": "954f940a-fe0f-43fb-b86f-75892f45b97e","name": "Loop Over Items","type": "n8n-nodes-base.splitInBatches","position": [176,448],"parameters": {"options": {}},"typeVersion": 3},{"id": "69f5e7fa-a6fa-484b-aa8c-d32537d504f4","name": "Filter Active & Completed Campaign","type": "n8n-nodes-base.filter","position": [-160,448],"parameters": {"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},"typeVersion": 2.2},{"id": "147ee7e8-a5e9-49ce-aa4c-c293f2992f0e","name": "4.1","type": "@n8n/n8n-nodes-langchain.lmChatOpenAi","position": [592,640],"parameters": {"model": {"__rl": true,"mode": "list","value": "gpt-4.1","cachedResultName": "gpt-4.1"},"options": {}},"credentials": {"openAiApi": {"id": "nFuggaqEYFlgAYJm","name": "n8n - Vekrro"}},"typeVersion": 1.2},{"id": "d1fb31c6-80f0-45b9-8807-94c66f5e5cb4","name": "Markdown -> HTML","type": "n8n-nodes-base.markdown","position": [944,592],"parameters": {"mode": "markdownToHtml","options": {"emoji": true,"tables": true},"markdown": "={{ $json.output }}"},"typeVersion": 1},{"id": "2a7317c5-985f-4cdb-9b9a-ec70f929d583","name": "Set Details","type": "n8n-nodes-base.set","position": [1120,592],"parameters": {"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": ""}]}},"notesInFlow": true,"typeVersion": 3.4},{"id": "849c3cb4-d096-4681-9ff4-494046950319","name": "HTML -> Magic 🪄","type": "n8n-nodes-base.code","position": [1296,592],"parameters": {"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};"},"typeVersion": 2},{"id": "294dd5aa-6ac3-4a69-8b60-5afebc6c239b","name": "Upload Doc","type": "n8n-nodes-base.httpRequest","position": [1472,592],"parameters": {"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"},"credentials": {"googleDriveOAuth2Api": {"id": "ZOMp7xuLlUZqtuOW","name": "business.vekrro"}},"notesInFlow": true,"typeVersion": 4.2},{"id": "9c64a8a4-057b-432d-a2c5-f41d7947bdca","name": "Send a Doc Link","type": "n8n-nodes-base.slack","position": [1648,592],"webhookId": "b3ae84d5-8dc7-4f11-b106-25da5a32b567","parameters": {"text": "=Campaign: {{ $('Fetch One Campaign').item.json.data.name }}\n\nReport Link: https://docs.google.com/document/d/{{ $json.id }}","select": "channel","channelId": {"__rl": true,"mode": "list","value": "C09V55TL5JN","cachedResultName": "manyreach"},"otherOptions": {"mrkdwn": true,"includeLinkToWorkflow": false},"authentication": "oAuth2"},"credentials": {"slackOAuth2Api": {"id": "DXnTKGQlu2nCPWj3","name": "bhavy.imedia"}},"typeVersion": 2.3},{"id": "8619ad60-4d30-461e-8903-86c948bd3988","name": "Schedule Trigger","type": "n8n-nodes-base.scheduleTrigger","position": [-928,448],"parameters": {"rule": {"interval": [{"field": "weeks","triggerAtDay": [1]}]}},"typeVersion": 1.2},{"id": "9e622711-fb52-4ae1-9beb-b48ecc6c795f","name": "Sticky Note2","type": "n8n-nodes-base.stickyNote","position": [-992,320],"parameters": {"color": 6,"width": 496,"height": 304,"content": "## 1. Weekly Trigger\n```Fetch All Campaigns every week and fetched campaign used for further nodes```"},"typeVersion": 1},{"id": "99eb65df-55f8-41b0-b234-c6dc6475cb1b","name": "Sticky Note3","type": "n8n-nodes-base.stickyNote","position": [-432,320],"parameters": {"color": 5,"width": 448,"height": 304,"content": "## 2. Filter Data\n```Process Only Active & also Completed Campaign for Generate Report```"},"typeVersion": 1},{"id": "146dcd2a-d715-4353-b8fc-1709b256233b","name": "Sticky Note4","type": "n8n-nodes-base.stickyNote","position": [80,336],"parameters": {"color": 2,"width": 1744,"height": 464,"content": "## 3. Loop for \n```It process all Campaign individually```"},"typeVersion": 1},{"id": "41db9f75-f0f9-4e3c-a3c1-a45eb8ae5f2d","name": "Campaign Report Agent","type": "@n8n/n8n-nodes-langchain.agent","position": [592,464],"parameters": {"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 }}","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."},"promptType": "define"},"typeVersion": 3},{"id": "ef10b14b-774d-4cfc-8507-1e0ed514e312","name": "Fetch One Campaign","type": "n8n-nodes-base.httpRequest","position": [416,464],"parameters": {"url": "=https://app.manyreach.com/api/campaigns/{{ $json.campaignID }}","options": {},"authentication": "genericCredentialType","genericAuthType": "httpQueryAuth"},"credentials": {"httpQueryAuth": {"id": "E8eXoDHCV2wWrAlg","name": "ManyReach"}},"typeVersion": 4.3}],"pinData": {},"connections": {"4.1": {"ai_languageModel": [[{"node": "Campaign Report Agent","type": "ai_languageModel","index": 0}]]},"Split Out": {"main": [[{"node": "Filter Active & Completed Campaign","type": "main","index": 0}]]},"Upload Doc": {"main": [[{"node": "Send a Doc Link","type": "main","index": 0}]]},"Set Details": {"main": [[{"node": "HTML -> Magic 🪄","type": "main","index": 0}]]},"Loop Over Items": {"main": [[],[{"node": "Fetch One Campaign","type": "main","index": 0}]]},"Send a Doc Link": {"main": [[{"node": "Loop Over Items","type": "main","index": 0}]]},"Markdown -> HTML": {"main": [[{"node": "Set Details","type": "main","index": 0}]]},"Schedule Trigger": {"main": [[{"node": "Fetch All Campaign","type": "main","index": 0}]]},"Fetch All Campaign": {"main": [[{"node": "Split Out","type": "main","index": 0}]]},"Fetch One Campaign": {"main": [[{"node": "Campaign Report Agent","type": "main","index": 0}]]},"HTML -> Magic 🪄": {"main": [[{"node": "Upload Doc","type": "main","index": 0}]]},"Campaign Report Agent": {"main": [[{"node": "Markdown -> HTML","type": "main","index": 0}]]},"Filter Active & Completed Campaign": {"main": [[{"node": "Loop Over Items","type": "main","index": 0}]]}}}
في محرر n8n: الصق باستخدام Ctrl+V→سيتم إنشاء سير العمل