Back to portfolio

Business Automation

Business Operations Automation System

An automated business operations system built with n8n to streamline employee attendance, payroll processing, and sales and expense reporting.

Built with n8n

01Overview

I built a multi-workflow business operations system using n8n to automate employee attendance tracking, working-hour calculations, weekly payroll reporting, and sales and expense reporting.

02Problem

Business operations often involve repetitive tasks such as recording employee attendance, checking clock-in and clock-out records, calculating working hours, preparing payroll information, and compiling sales and expense reports.

Handling these processes manually can require repeated data entry, calculations, and report preparation.

03Solution

I designed a set of automated n8n workflows that process operational data, perform calculations, organize records in Google Sheets, and generate recurring reports.

The system separates daily attendance processing from weekly payroll and recurring business reporting, making each process easier to manage and maintain.

04System Architecture

Employee Attendance

  • Employee Attendance
  • Attendance Processing
  • Working Hours
  • Weekly Payroll

Sales & Expenses

  • Sales Data + Expense Data
  • Data Processing
  • Daily Reporting
  • Monthly Reporting

The system uses separate workflows for different operational tasks while keeping the data organized across the business reporting process. This diagram only explains the system — the n8n screenshots below are the actual workflows.

0501 — Employee Attendance Automation

An automated workflow for processing employee attendance, clock-in and clock-out information, working hours, and attendance reporting.

Problem

Daily attendance tracking can require checking employee records, determining clock-in or clock-out status, and calculating working hours.

Solution

The workflow processes attendance information, checks clock-in and clock-out records, calculates worked hours, and updates the relevant attendance and time-log records. It also runs an automated attendance reporting step on a schedule.

Actual n8n Workflow

Employee Attendance Automation

How it works

  1. 1Employee Attendance
  2. 2Find Employee
  3. 3Prepare Attendance Data
  4. 4Check Clock In / Clock Out
  5. 5Find Today's Attendance
  6. 6Record Time Logs
  7. 7Calculate Worked Hours
  8. 8Update Worked Hours

0602 — Weekly Payroll & Salary Report

An automated workflow that processes employee time logs and prepares a weekly payroll and salary report.

Problem

Calculating employee salary from working-hour records can require repetitive data processing and calculations.

Solution

The workflow retrieves payroll-related time logs, filters the relevant records, groups the information by employee, calculates salary information, updates the total salary data, and builds a weekly payroll report.

Actual n8n Workflow

Weekly Payroll & Salary Report (bottom row of the attendance workflow)

How it works

  1. 1Get Time Logs
  2. 2Filter Payroll Time Logs
  3. 3Group Payroll by Employee
  4. 4Get Employee Information
  5. 5Combine Data
  6. 6Calculate Salary
  7. 7Total Salary
  8. 8Build Weekly Payroll Report
  9. 9Send Report

0703 — Sales & Expenses Reporting

An automated workflow that processes daily sales and expense information and generates a structured report.

Problem

Daily sales and expense reporting can require collecting information from separate records, calculating totals, and preparing a summary.

Solution

The workflow retrieves sales and expense records, calculates the day's totals, combines the information, builds a report, formats the message, and sends the report through Telegram.

Actual n8n Workflow

Sales & Expenses Reporting

How it works

  1. 1Sales Sheet
  2. 2Calculate Today's Sales
  3. 3Expenses Sheet
  4. 4Calculate Today's Expenses
  5. 5Merge
  6. 6Build Daily Report
  7. 7Format Telegram Message
  8. 8Send Message

0804 — Monthly Sales & Expenses Report

An automated monthly reporting workflow that calculates monthly sales and expenses and generates a consolidated report.

Problem

Preparing monthly sales and expense summaries can require collecting data, calculating totals, and manually preparing the final report.

Solution

The workflow retrieves monthly sales and expense data, calculates the relevant totals, builds the monthly report message, and records the report in Google Sheets while sending the report through Telegram.

Actual n8n Workflow

Monthly Sales & Expenses Report

How it works

  1. 1Monthly Report Trigger
  2. 2Calculate Monthly Report
  3. 3Get Sales Monthly
  4. 4Calculate Sales for Monthly Report
  5. 5Get Expenses Monthly
  6. 6Calculate Expenses for Monthly Report
  7. 7Build Monthly Report Message
  8. 8Send Report
  9. 9Save Monthly Sales & Report

——Workflow Screenshots

  • Employee Attendance & Weekly Payroll

  • Sales & Expenses Reporting

  • Monthly Sales & Expenses Report

09Tools Used

  • n8n

    Primary automation platform

  • Google Sheets

    Records and reporting data

  • Telegram

    Report delivery

  • JavaScript / Code

    Calculations and formatting

  • Schedule Triggers

    Recurring runs

  • Conditional Logic

    Clock-in / clock-out routing

  • Data Processing

    Merging and grouping records

  • Workflow Automation

    End-to-end orchestration

10Business Benefits

  • Automates repetitive attendance processing
  • Organizes employee time records
  • Automates recurring payroll calculations
  • Simplifies weekly payroll reporting
  • Automates sales and expense calculations
  • Creates recurring monthly reports
  • Centralizes operational information
  • Reduces repetitive manual data processing
Back to all workflows