{"nodes":[{"name":"On clicking 'execute'","type":"n8n-nodes-base.manualTrigger","position":[120,560],"parameters":{},"typeVersion":1,"id":"node-a938b3b6"},{"name":"SortElements","type":"n8n-nodes-base.itemLists","position":[480,560],"parameters":{"options":{},"operation":"sort","sortFieldsUi":{"sortField":[{"fieldName":"UserName"},{"fieldName":"TaskTitle"},{"fieldName":"date"}]}},"typeVersion":1,"id":"node-428de790"},{"name":"Markdown","type":"n8n-nodes-base.markdown","position":[1340,580],"parameters":{"mode":"markdownToHtml","options":{"tables":true,"noHeaderId":true,"rawHeaderId":false,"simpleLineBreaks":true,"customizedHeaderId":false,"completeHTMLDocument":true},"markdown":"={{$json[\"mdreport\"]}}"},"typeVersion":1,"id":"node-6393bb10"},{"name":"CreateMDReport","type":"n8n-nodes-base.function","position":[1160,580],"parameters":{"functionCode":"// created report header and custom table style\nvar md_reporthead=\"#Timesheet report\\n\";\nvar md_style = (`\n\\n\\n`);\n\nvar md_reportbody=md_style+md_reporthead;\n\n//declare several variables that are used for report generation\nvar tablehead = \"| Date | Hours | Task Description |\\n|:---|:---:|---|\\n\";\n\nvar cur_user=\"\";\nvar cur_usernum=0;\n\nvar cur_task=\"\";\nvar cur_tasktotal=0;\n\n\nfor (item of items) {\n \n // Check if new user\n if (item.json.UserName != cur_user) {\n // Close previous user's task\n md_reportbody += (cur_tasktotal) ? \"\\n*\"+cur_tasktotal.toFixed(2)+\" - Total hours for this task*\\n\" : \"\";\n cur_tasktotal = 0; cur_task=\"\";\n\n // add new user and embed avatar as base64 image\n cur_user = item.json.UserName;\n md_reportbody += `\\n##![img](data:image/png;base64,${items[cur_usernum].binary.data.data}) ${cur_user}\\n`;\n cur_usernum += 1;\n } // Check for new user - ENDIF\n\n\n // Check if new task\n if (item.json.TaskTitle != cur_task) {\n\n // if not empty task - add total amount of hours for *previous* task\n md_reportbody += (cur_tasktotal) ? `\\n*${cur_tasktotal.toFixed(2)} - Total hours for this task*\\n` : \"\";\n\n // Add new task header and reset total hours counter\n cur_task = item.json.TaskTitle;\n md_reportbody += `\\n###${cur_task}\\n${tablehead}`;\n cur_tasktotal = 0;\n } // Check for new task - ENDIF\n\n // Add current task + update total hours\n md_reportbody += `| ${item.json.date.split('T',1)} | ${item.json.hours.toFixed(2)} | ${item.json.note} |\\n`;\n cur_tasktotal += item.json.hours;\n}\n\n// Let's not forget the last task's total hours:\nmd_reportbody += (cur_tasktotal) ? `\\n*${cur_tasktotal.toFixed(2)} - Total hours for this task*\\n` : \"\";\n\n// Finalise the report\nmd_reportbody += `\\n*Timesheet report generated on: ${$now.toISODate()}*`;\nmd_reporthead += \"\\n\";\n\nreturn [{mdreport: md_reportbody}];"},"typeVersion":1,"id":"node-c87cce30"},{"name":"Send Email","type":"n8n-nodes-base.emailSend","disabled":true,"position":[1760,580],"parameters":{"options":{"allowUnauthorizedCerts":false},"subject":"TimeSheet report","attachments":"data"},"credentials":{"smtp":{"id":"{{ $credentials.smtp.id }}","name":"info@stats.consult"}},"typeVersion":1,"id":"node-d549bce1"},{"name":"GetImg","type":"n8n-nodes-base.itemLists","position":[640,760],"parameters":{"compare":"selectedFields","options":{"removeOtherFields":true},"operation":"removeDuplicates","fieldsToCompare":{"fields":[{"fieldName":"UserAvatar"}]}},"typeVersion":1,"id":"node-6ac77f38"},{"name":"ImgBinary","type":"n8n-nodes-base.httpRequest","position":[820,760],"parameters":{"url":"{{ $env.BASE_URL }}","options":{},"responseFormat":"file"},"typeVersion":2,"id":"node-b46677be"},{"name":"Merge2","type":"n8n-nodes-base.merge","position":[980,580],"parameters":{"join":"outer","mode":"mergeByIndex"},"typeVersion":1,"id":"node-746e8f1b"},{"name":"Move Binary Data1","type":"n8n-nodes-base.moveBinaryData","position":[1520,580],"parameters":{"mode":"jsonToBinary","options":{"fileName":"report.html","mimeType":"text/html","useRawData":true},"convertAllData":false},"typeVersion":1,"id":"node-9ed0b381"},{"name":"GetTimesheetRecords","type":"n8n-nodes-base.function","position":[300,560],"parameters":{"functionCode":"return [{UserName: \"User 1 - Lead Programmer\",\n UserAvatar: \"https://www.gravatar.com/avatar/?d=robohash&s=32\",\n TaskTitle: \"Admin\",\n date: \"2022-05-31T00:00:00.0000000+02:00\",\n note: \"Creating invoices and submitting timesheets\",\n hours: 0.5},\n {UserName: \"User 1 - Lead Programmer\",\n UserAvatar: \"https://www.gravatar.com/avatar/?d=robohash&s=32\",\n TaskTitle: \"Admin\",\n date: \"2022-05-02T00:00:00.0000000+02:00\",\n note: \"Reporting last month's activity\",\n hours: 0.5},\n {UserName: \"User 2 - Designer\",\n UserAvatar: \"https://www.gravatar.com/avatar/?d=identicon&s=32\",\n TaskTitle: \"Admin\",\n date: \"2022-05-30T00:00:00.0000000+02:00\",\n note: \"Filling timesheets\",\n hours: 0.5},\n {UserName: \"User 2 - Designer\",\n UserAvatar: \"https://www.gravatar.com/avatar/?d=identicon&s=32\",\n TaskTitle: \"Admin\",\n date: \"2022-05-03T00:00:00.0000000+02:00\",\n note: \"Monthly retro meeting\",\n hours: 0.5},\n {UserName: \"User 1 - Lead Programmer\",\n UserAvatar: \"https://www.gravatar.com/avatar/?d=robohash&s=32\",\n TaskTitle: \"Client 1\",\n date: \"2022-05-26T00:00:00.0000000+02:00\",\n note: \"Weekly meeting\",\n hours: 0.5},\n {UserName: \"User 1 - Lead Programmer\",\n UserAvatar: \"https://www.gravatar.com/avatar/?d=robohash&s=32\",\n TaskTitle: \"Client 1\",\n date: \"2022-05-05T00:00:00.0000000+02:00\",\n note: \"Weekly meeting\",\n hours: 0.5},\n {UserName: \"User 1 - Lead Programmer\",\n UserAvatar: \"https://www.gravatar.com/avatar/?d=robohash&s=32\",\n TaskTitle: \"Client 1\",\n date: \"2022-05-19T00:00:00.0000000+02:00\",\n note: \"Weekly meeting\",\n hours: 0.5},\n {UserName: \"User 1 - Lead Programmer\",\n UserAvatar: \"https://www.gravatar.com/avatar/?d=robohash&s=32\",\n TaskTitle: \"Client 1\",\n date: \"2022-05-12T00:00:00.0000000+02:00\",\n note: \"Weekly meeting\",\n hours: 0.5},\n {UserName: \"User 1 - Lead Programmer\",\n UserAvatar: \"https://www.gravatar.com/avatar/?d=robohash&s=32\",\n TaskTitle: \"Client 1\",\n date: \"2022-05-12T00:00:00.0000000+02:00\",\n note: \"Programmed new feature\",\n hours: 4.5},\n {UserName: \"User 1 - Lead Programmer\",\n UserAvatar: \"https://www.gravatar.com/avatar/?d=robohash&s=32\",\n TaskTitle: \"Client 1\",\n date: \"2022-05-02T00:00:00.0000000+02:00\",\n note: \"Updated this and that\",\n hours: 2.75},\n {UserName: \"User 2 - Designer\",\n UserAvatar: \"https://www.gravatar.com/avatar/?d=identicon&s=32\",\n TaskTitle: \"Client 2\",\n date: \"2022-05-13T00:00:00.0000000+02:00\",\n note: \"Designed a new report template\",\n hours: 6.5},\n {UserName: \"User 2 - Designer\",\n UserAvatar: \"https://www.gravatar.com/avatar/?d=identicon&s=32\",\n TaskTitle: \"Client 2\",\n date: \"2022-05-23T00:00:00.0000000+02:00\",\n note: \"Presented the results\",\n hours: 1.5}\n ];"},"typeVersion":1,"id":"node-f414fdca"},{"id":"error-d80749e7","name":"Error Handler","type":"n8n-nodes-base.stopAndError","typeVersion":1,"position":[1000,400],"parameters":{"message":"Workflow execution error","options":{}}}],"connections":{},"name":"Production Workflow","settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3},"meta":{"instanceId":"workflow-ce7ccca6","versionId":"1.0.0","createdAt":"2025-09-29T07:07:48.710288","updatedAt":"2025-09-29T07:07:48.710296","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"description":"Production-ready workflow: Production Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}