Sven Flätchen This workflow corresponds to n8n.io template #15269 — we link there as the canonical source.
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": "Weekly smenso Project Status Report via Email",
"tags": [],
"nodes": [
{
"id": "c1d2e3f4-0001-0001-0001-000000000001",
"name": "Every Monday at 8am",
"type": "n8n-nodes-base.scheduleTrigger",
"notes": "Runs every Monday at 8:00 AM.\nAdjust the cron expression to your preferred day and time.",
"position": [
160,
208
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 8 * * 1"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "c1d2e3f4-0002-0002-0002-000000000002",
"name": "Get All Projects",
"type": "n8n-nodes-smenso.smenso",
"position": [
384,
208
],
"parameters": {
"resource": "project",
"operation": "getMany"
},
"credentials": {
"smensoApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "c1d2e3f4-0003-0003-0003-000000000003",
"name": "Build HTML Report",
"type": "n8n-nodes-base.code",
"position": [
608,
208
],
"parameters": {
"jsCode": "const projects = items.map(item => item.json);\nconst date = new Date().toLocaleDateString('en-GB', {\n weekday: 'long', year: 'numeric', month: 'long', day: 'numeric'\n});\n\nconst rows = projects.map(p => {\n const title = p.title ?? p.name ?? 'Unnamed Project';\n const start = p.startDate ? new Date(p.startDate).toLocaleDateString('en-GB') : '\u2014';\n const end = p.endDate ? new Date(p.endDate).toLocaleDateString('en-GB') : '\u2014';\n return `<tr><td style=\"padding:8px;border:1px solid #ddd;\">${title}</td><td style=\"padding:8px;border:1px solid #ddd;text-align:center;\">${start}</td><td style=\"padding:8px;border:1px solid #ddd;text-align:center;\">${end}</td></tr>`;\n}).join('');\n\nconst html = `\n<html><body style=\"font-family:Arial,sans-serif;color:#333;\">\n<h2 style=\"color:#1a1a2e;\">\ud83d\udcca Weekly smenso Project Report</h2>\n<p style=\"color:#666;\">${date}</p>\n<p>You have <strong>${projects.length} active project(s)</strong> in your smenso workspace.</p>\n<table style=\"border-collapse:collapse;width:100%;margin-top:16px;\">\n <thead>\n <tr style=\"background:#f0f0f0;\">\n <th style=\"padding:8px;border:1px solid #ddd;text-align:left;\">Project</th>\n <th style=\"padding:8px;border:1px solid #ddd;\">Start Date</th>\n <th style=\"padding:8px;border:1px solid #ddd;\">End Date</th>\n </tr>\n </thead>\n <tbody>${rows}</tbody>\n</table>\n<p style=\"margin-top:24px;color:#999;font-size:12px;\">This report was automatically generated by n8n + smenso.</p>\n</body></html>\n`;\n\nreturn [{ json: { html, projectCount: projects.length, date } }];"
},
"typeVersion": 2
},
{
"id": "c1d2e3f4-0004-0004-0004-000000000004",
"name": "Send Email",
"type": "n8n-nodes-base.gmail",
"notes": "Replace YOUR_EMAIL@company.com with the recipient email address.\nYou can also replace this node with Microsoft Outlook or SMTP.",
"position": [
832,
208
],
"parameters": {
"sendTo": "user@example.com",
"message": "={{ $json.html }}",
"options": {},
"subject": "=\ud83d\udcca Weekly smenso Project Report \u2013 {{ $json.date }}",
"emailType": "html"
},
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "c1d2e3f4-0005-0005-0005-000000000005",
"name": "README",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
420
],
"parameters": {
"color": 6,
"width": 620,
"height": 340,
"content": "## \ud83d\udcca Weekly smenso Project Status Report via Email\n\n**What this workflow does:**\nEvery Monday at 8:00 AM, it fetches all active projects from your smenso workspace and sends a formatted HTML status report via email \u2014 perfect for management reporting and weekly standups.\n\n**Setup:**\n1. Set your **smenso API** credentials\n2. Set your **Gmail** credentials (or replace with Outlook / SMTP node)\n3. Replace `YOUR_EMAIL@company.com` in the **Send Email** node with the recipient address\n\n**Customize:**\n- Change the schedule in **Every Monday at 8am** (cron: `0 8 * * 1`)\n- Add more project fields in **Build HTML Report** (e.g. status, budget)\n- Replace Gmail with **Microsoft Outlook** or **Send Email (SMTP)** node\n\n**Tip:** Run smenso \u2192 Project \u2192 Get Many manually first to see which fields are available in your workspace."
},
"typeVersion": 1
}
],
"settings": {
"executionOrder": "v1"
},
"versionId": "1",
"staticData": null,
"connections": {
"Get All Projects": {
"main": [
[
{
"node": "Build HTML Report",
"type": "main",
"index": 0
}
]
]
},
"Build HTML Report": {
"main": [
[
{
"node": "Send Email",
"type": "main",
"index": 0
}
]
]
},
"Every Monday at 8am": {
"main": [
[
{
"node": "Get All Projects",
"type": "main",
"index": 0
}
]
]
}
},
"triggerCount": 0
}
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.
gmailOAuth2smensoApi
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Weekly smenso Project Status Report via Email
Source: https://n8n.io/workflows/15269/ — 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.
YOUR_ID 4. Uses gmail, googleDrive, googleSheets, httpRequest. Scheduled trigger; 53 nodes.
The FamilyFlow Assistant is your n8n-powered 🚀 companion designed to streamline daily parenting tasks, reduce mental load, and bring a bit more organization and fun into your family life. This versati
Instead of providing a routine check, it focuses on significant movements by: Sending a Slack alert only if a query crosses a defined movement threshold. Emailing a structured report with the Top 25 i
Looking for a way to track GitHub bounty issues automatically and get notified in real time? This GitHub Bounty Tracker workflow monitors repositories for issues labeled 💎 Bounty, logs them in Google
This workflow gathers papers in Arxiv and specific arxiv category AI helps to make summarized form of newsletter and send it to subscriber using gmail Supabase Table schema user_email: Text - Mandator