This workflow follows the Emailsend → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "IPTV_current",
"nodes": [
{
"parameters": {
"method": "POST",
"url": "http://10.18.200.198:8000/download-iptv",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "start_date",
"value": "={{ $json.today_dmy }}"
},
{
"name": "end_date",
"value": "={{ $json.tomorrow_dmy }}"
},
{
"name": "=filename",
"value": "={{ $json.today_ymd }}_{{ $json.tomorrow_ymd }}.csv"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
-1200,
-368
],
"id": "e326104d-3f07-4cc3-b4c4-08d7f6ca52f4",
"name": "Extract IPTV Data"
},
{
"parameters": {
"method": "POST",
"url": "http://10.18.200.198:8000/merge-to-excel",
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"iptv_path\": \"{{ $('Extract IPTV Data').item.json.filename }}\",\n \"infosite_path\": \"{{ $('Extract-infosite').item.json.file_path }}\",\n \"output_filename\": \"{{ $('Code').item.json.today_ymd }}_{{ $('Code').item.json.tomorrow_ymd }}\"\n} ",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
-1200,
-144
],
"id": "6db97b80-7214-4493-8791-56c6ab2aaa53",
"name": "Merge to Excel"
},
{
"parameters": {
"url": "=http://10.18.200.198:8000/download-excel",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "data_type",
"value": "merge"
},
{
"name": "filename",
"value": "={{ $('Code').item.json.today_ymd }}_{{ $('Code').item.json.tomorrow_ymd }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
-992,
-144
],
"id": "57a9531f-b750-4ba6-a5a3-647385dee4f0",
"name": "Get Execel"
},
{
"parameters": {
"jsCode": "const today = new Date();\n\n// \u2795 8 \u5c0f\u6642\nconst todayPlus8 = new Date(today.getTime() + 8 * 60 * 60 * 1000);\n\n// \u660e\u5929\nconst tomorrow = new Date();\ntomorrow.setDate(todayPlus8.getDate() + 1);\n\n// \u683c\u5f0f\u5316 yyyy-mm-dd\nfunction formatYYYYMMDD(date) {\n return date.toISOString().split(\"T\")[0];\n}\n\n// \u683c\u5f0f\u5316 dd/mm/yyyy\nfunction formatDDMMYYYY(date) {\n const dd = String(date.getDate()).padStart(2, '0');\n const mm = String(date.getMonth() + 1).padStart(2, '0');\n const yyyy = date.getFullYear();\n return `${dd}/${mm}/${yyyy}`;\n}\n\n// \u56db\u500b\u7d50\u679c\nconst result = {\n today_ymd: formatYYYYMMDD(todayPlus8), // 2025-09-17 (UTC+8 \u5f8c\u7684\u65e5\u671f)\n tomorrow_ymd: formatYYYYMMDD(tomorrow), // 2025-09-18\n today_dmy: formatDDMMYYYY(todayPlus8), // 17/09/2025\n tomorrow_dmy: formatDDMMYYYY(tomorrow) // 18/09/2025\n};\n\n// \u56de\u50b3\u7d66 n8n\nreturn [{ json: result }];"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
-944,
-640
],
"id": "b6410b55-565f-4ba7-b15c-5ec4a4da4a31",
"name": "Code"
},
{
"parameters": {
"fromEmail": "taiwan-demo@starific.net ",
"toEmail": "robert.tseng@onelab.tw, ben.chen@onelab.tw,rdrd33@gmail.com,lientruong0508@gmail.com,sukyfeng87@gmail.com,rdrd33@gmail.com",
"subject": "test",
"emailFormat": "text",
"text": "=Hi All \nThis is Up2 Data from {{ $('Code').item.json.today_ymd }} to {{ $('Code').item.json.tomorrow_ymd }}",
"options": {
"attachments": "data"
}
},
"type": "n8n-nodes-base.emailSend",
"typeVersion": 2.1,
"position": [
-816,
-144
],
"id": "01a8dc92-f2d3-4eda-bbb3-31204fa91e67",
"name": "Send Result",
"credentials": {
"smtp": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"method": "POST",
"url": "http://10.18.200.198:8000/check-leagues",
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"start_time\": \"{{ $('Code').item.json.today_ymd }}\",\n \"end_time\": \"{{ $('Code').item.json.tomorrow_ymd }}\",\n \"filename\": \"{{ $('Code').item.json.today_ymd }}_{{ $('Code').item.json.tomorrow_ymd }}\",\n \"league_groups\": [\n \"Soccerway\",\n \"IMG\",\n \"Virtual\",\n \"RB Upload\",\n \"RTS Upload\",\n \"BG Upload\",\n \"BETRADAR Upload\"\n ]\n}",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
-1040,
-368
],
"id": "e824ecd7-05cd-4926-9e9d-7145f224e1d5",
"name": "League_Name"
},
{
"parameters": {
"amount": "={{ $('Extract League').item.json.batches }}",
"unit": "minutes"
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
-560,
-368
],
"id": "515ab37a-761d-4c38-94ed-1f2fd0f47815",
"name": "Wait"
},
{
"parameters": {
"jsCode": "const raw = String($input.first().json.leagues);\n\nlet items = raw.split(\",\")// \n .map(item => `\"${item}\"`); // \u52a0\u4e0a\u5f15\u865f\nconst count = items.length;\nconst batches = Math.ceil(count / 50); \nreturn {\n result: `[${items.join(\", \")}]`,\n batches: batches*4\n};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
-880,
-368
],
"id": "800dff87-e5ca-419b-8a8f-16ab686dea43",
"name": "Extract League"
},
{
"parameters": {
"method": "POST",
"url": "http://10.18.200.198:8000/download-infosite",
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"start_time\": \"{{ $('Code').item.json.today_ymd }}\",\n \"end_time\": \"{{ $('Code').item.json.tomorrow_ymd }}\",\n \"filename\": \"{{ $('Code').item.json.today_ymd }}_{{ $('Code').item.json.tomorrow_ymd }}\",\n \"leagues\": {{ $json.result }},\n \"league_groups\": [\n \"Soccerway\",\n \"IMG\",\n \"Virtual\",\n \"RB Upload\",\n \"RTS Upload\",\n \"BG Upload\",\n \"BETRADAR Upload\"\n ],\n \"sports\": [\n \"Soccer\"\n ],\n \"save_features\": [],\n \"batch_size\": 50\n}",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
-704,
-368
],
"id": "8edea509-e61e-499d-971b-06f226e2fe9a",
"name": "Extract-infosite"
},
{
"parameters": {
"content": "## Extract IPTV and Infosite Data",
"height": 240,
"width": 832
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-1264,
-464
],
"id": "17e21b25-3a2c-4bb2-8b1d-bd50c0f6ecbd",
"name": "Sticky Note"
},
{
"parameters": {
"content": "## Merge to formula and Send Email ",
"height": 224,
"width": 832,
"color": 5
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-1264,
-224
],
"id": "f6b9b9da-2dd6-4d2f-bde6-e77b389184f9",
"name": "Sticky Note1"
},
{
"parameters": {
"content": "## Execute Workflow",
"height": 272,
"width": 832,
"color": 6
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-1264,
-736
],
"id": "78706b24-86c1-4473-bdc2-c68b36f355bd",
"name": "Sticky Note2"
},
{
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "1 5,17 * * *"
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
-1216,
-640
],
"id": "5143a12a-18af-491c-a6b8-4385719b95e0",
"name": "Schedule Trigger_morning"
}
],
"connections": {
"Extract IPTV Data": {
"main": [
[
{
"node": "League_Name",
"type": "main",
"index": 0
}
]
]
},
"Merge to Excel": {
"main": [
[
{
"node": "Get Execel",
"type": "main",
"index": 0
}
]
]
},
"Get Execel": {
"main": [
[
{
"node": "Send Result",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Extract IPTV Data",
"type": "main",
"index": 0
}
]
]
},
"League_Name": {
"main": [
[
{
"node": "Extract League",
"type": "main",
"index": 0
}
]
]
},
"Extract League": {
"main": [
[
{
"node": "Extract-infosite",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Merge to Excel",
"type": "main",
"index": 0
}
]
]
},
"Extract-infosite": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger_morning": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
}
},
"active": true,
"settings": {
"executionOrder": "v1",
"saveExecutionProgress": true,
"callerPolicy": "workflowsFromSameOwner",
"saveDataErrorExecution": "all",
"saveDataSuccessExecution": "all",
"errorWorkflow": "Bk0glFoKTLLbjUeJ",
"saveManualExecutions": true
},
"versionId": "40d27339-05ed-41db-a94e-edc1f028064e",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "Bk0glFoKTLLbjUeJ",
"tags": []
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
smtp
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
IPTV_current. Uses httpRequest, emailSend. Scheduled trigger; 13 nodes.
Source: https://gitlab.com/starixvn/operation-automation_n8n-workflow/-/blob/feature/BWF_new_method/IPTV/IPTV_current.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Birthday Automation - Production (Fixed). Uses stopAndError, httpRequest, emailSend, bannerbear. Scheduled trigger; 86 nodes.
Stop And Error, HTTP Request, Email Send +1
This workflow is an improvement of this workflow by Greg Brzezinka.
HTTP Request, Email Send, XML +1
N8N-Self-Updater. Uses ssh, emailSend, httpRequest. Scheduled trigger; 27 nodes.
Ssh, Email Send, HTTP Request
> An automated n8n workflow originally built for DigitalOcean-based n8n deployments, but fully compatible with any VPS or cloud hosting (e.g., AWS, Google Cloud, Hetzner, Linode, etc.) where n8n ru
Ssh, Email Send, HTTP Request
What if you could spot a major sales problem—or a winning campaign—the very next morning, instead of weeks later? Imagine receiving a beautiful, data-rich alert directly in your inbox the moment your
QuickBooks, HTTP Request, Email Send