{ "edges": [ { "to": "6d86fedc-c291-43dd-b008-1e0395d48d9f", "from": "be2604f7-a5ca-46fe-b711-f53a81b1363e", "toPort": "0", "fromPort": "0" }, { "to": "3aa03862-f0a0-40e7-9d68-20d656a0d304", "from": "60dd3732-4a0f-4544-b52e-1b2b2cb969cb", "toPort": "0", "fromPort": "0" }, { "to": "2632242c-671b-4e26-a9f4-534ecf3cfea6", "from": "60dd3732-4a0f-4544-b52e-1b2b2cb969cb", "toPort": "0", "fromPort": "0" }, { "to": "29d8af43-2951-4c9e-80de-556f65588a65", "from": "3aa03862-f0a0-40e7-9d68-20d656a0d304", "toPort": "0", "fromPort": "0" }, { "to": "be2604f7-a5ca-46fe-b711-f53a81b1363e", "from": "2632242c-671b-4e26-a9f4-534ecf3cfea6", "toPort": "1", "fromPort": "0" }, { "to": "3cf0af49-6e80-4dbc-8395-9861ed371a69", "from": "6d86fedc-c291-43dd-b008-1e0395d48d9f", "toPort": "0", "fromPort": "0" }, { "to": "be2604f7-a5ca-46fe-b711-f53a81b1363e", "from": "29d8af43-2951-4c9e-80de-556f65588a65", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "2632242c-671b-4e26-a9f4-534ecf3cfea6", "name": "Get Toggle Projects", "type": "http", "params": { "url": "https://api.track.toggl.com/api/v9/workspaces/TOGGL_WORKSPACE_ID/projects", "options": { "pagination": { "pagination": { "parameters": { "parameters": [ { "name": "page", "value": "={{ $pageCount + 1 }}" } ] } } } }, "sendQuery": true, "authentication": "predefinedCredentialType", "queryParameters": { "parameters": [ {} ] }, "nodeCredentialType": "togglApi" }, "position": [ -304, -128 ] }, { "id": "60dd3732-4a0f-4544-b52e-1b2b2cb969cb", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "months", "triggerAtHour": 4 } ] } }, "position": [ -704, -240 ] }, { "id": "3aa03862-f0a0-40e7-9d68-20d656a0d304", "name": "Get Toggle Summary", "type": "http", "params": { "url": "https://api.track.toggl.com/reports/api/v3/workspace/TOGGL_WORKSPACE_ID/summary/time_entries", "method": "POST", "options": {}, "sendBody": true, "sendHeaders": true, "authentication": "predefinedCredentialType", "bodyParameters": { "parameters": [ { "name": "start_date", "value": "={{ $now.minus({ months: 1 }).startOf('month').toFormat('yyyy-MM-dd') }}" }, { "name": "end_date", "value": "={{ $now.minus({ months: 1 }).endOf('month').toFormat('yyyy-MM-dd') }}" }, { "name": "grouping", "value": "clients" }, { "name": "sub_grouping", "value": "projects" } ] }, "headerParameters": { "parameters": [ { "name": "Content-Type", "value": "application/json" } ] }, "nodeCredentialType": "togglApi" }, "position": [ -304, -352 ] }, { "id": "6d86fedc-c291-43dd-b008-1e0395d48d9f", "name": "Prepare html raport", "type": "code", "params": { "jsCode": "const data = $input.all().map(i => i.json);\nconst period = $json.period || \"Previous month\";\n\n// Group by clinet\nconst clients = {};\nfor (const i of data) {\n const clientId = i.client_id || i.cid;\n const clientName = i.client_name || \"(missing customer name)\";\n if (!clients[clientId]) {\n clients[clientId] = { name: clientName, projects: [] };\n }\n clients[clientId].projects.push({\n project_id: i.project_id,\n project_name: i.name || \"(bez nazwy projektu)\",\n seconds: Number(i.seconds) || 0\n });\n}\n\n// Sum clients time\nfor (const c of Object.values(clients)) {\n c.totalSeconds = c.projects.reduce((a, p) => a + p.seconds, 0);\n}\n\n// Sort clients\nconst sortedClients = Object.entries(clients)\n .sort(([, a], [, b]) => b.totalSeconds - a.totalSeconds);\n\n// Generate html raport\nlet totalSeconds = 0;\nlet html = \"\";\nhtml += \"

Time Report per Client and Project - \" + period + \"

\";\n\nfor (const [clientId, c] of sortedClients) {\n const clientHours = (c.totalSeconds / 3600).toFixed(2);\n totalSeconds += c.totalSeconds;\n\n html += \"

\" + c.name + \" – \" + clientHours + \" h

\";\n html += \"

\" + p.project_name + \" – \" + hours + \" h

\";\n}\n\nhtml += \"

Total hours: \" + (totalSeconds / 3600).toFixed(2) + \"

\";\nhtml += \"\";\n\nreturn [{\n json: {\n subject: \"Time Report per Client and Project - \" + period,\n html\n }\n}];\n" }, "position": [ 576, -240 ] }, { "id": "3cf0af49-6e80-4dbc-8395-9861ed371a69", "name": "Send email via Resend", "type": "http", "params": { "url": "https://api.resend.com/emails", "method": "POST", "options": {}, "jsonBody": "={\n \"from\": \"\",\n \"to\": [\"to@yourdomain.com\"],\n \"subject\": \"{{$json.subject}}\",\n \"html\": \"{{$json.html}}\"\n}\n", "sendBody": true, "sendHeaders": true, "specifyBody": "json", "headerParameters": { "parameters": [ { "name": "Authorization", "value": "Bearer YOUR_TOKEN_HERE" }, { "name": "Content-Type", "value": "application/json" } ] } }, "position": [ 864, -240 ] }, { "id": "be2604f7-a5ca-46fe-b711-f53a81b1363e", "name": "Merge data", "type": "merge", "params": { "mode": "combine", "options": {}, "advanced": true, "joinMode": "enrichInput1", "mergeByFields": { "values": [ { "field1": "project_id", "field2": "id" } ] } }, "position": [ 288, -240 ] }, { "id": "29d8af43-2951-4c9e-80de-556f65588a65", "name": "Prepare projects list", "type": "code", "params": { "jsCode": "const groups = $json.groups || [];\nconst result = [];\n\nfor (const g of groups) {\n const clientId = Number(g.id);\n const subs = g.sub_groups || [];\n for (const s of subs) {\n result.push({\n json: {\n client_id: clientId,\n project_id: Number(s.id),\n seconds: Number(s.seconds) || 0\n }\n });\n }\n}\n\nreturn result;\n" }, "position": [ -80, -352 ] } ] }

Send monthly Toggl time tracking summary via Resend email