This n8n workflow automates the creation of a comprehensive timesheet report in Markdown format, enhanced with user avatars, and is designed to streamline project management and time tracking. The process begins with a manual trigger, allowing users to initiate the report generation as needed. It fetches predefined timesheet data, which includes user names, avatars, task details, dates, notes, and hours worked.
The workflow then sorts these records by user name, task title, and date to organize the data logically. A custom Function node constructs a detailed Markdown report, grouping entries by user and task, embedding user avatars in Base64 format, and calculating total hours per task with styled tables for better readability. The generated Markdown content is converted into HTML for presentation.
Additionally, the workflow fetches user avatar images asynchronously via HTTP requests, ensuring each user’s avatar is embedded correctly in the report. The final HTML report, which combines all formatted data and images, is moved into a binary format, ready to be sent via email or stored.
This setup is ideal for project managers or team leads who need to quickly generate visually appealing, detailed timesheet summaries for review or sharing with stakeholders. It reduces manual effort, improves report clarity, and maintains an organized overview of work hours across multiple users and tasks.
Reviews
There are no reviews yet.