Files & Documents
Automate Site Worker Attendance Logging to Google Sheets
10 nodes
119
75
Webhook
Workflow Description
Workflow captures attendance data via webhook and records it directly in Google Sheets, with backup copies saved to Google Drive. Includes data validation and conditional filtering before storage.
How it works
- 1.Receive attendance data submission via webhook from site management system
- 2.Validate incoming data and filter by predefined conditions
- 3.Log attendance records in Google Sheets with automatic timestamps
- 4.Archive completed records and generate reports in Google Drive
Use cases
- Track construction site worker check-in and check-out times automatically
- Generate daily and monthly attendance reports without manual data entry
- Monitor work hours and calculate payroll based on logged attendance data
Requirements
- Google Workspace account with permissions to create sheets and files
- Active webhook endpoint connected to your attendance tracking system
- Pre-configured Google Sheet with required column headers for attendance data
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Google Drive
Google Sheets
Details
Trigger
Webhook
Nodes
10
Apps
2
Views
119
Downloads
75
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (10)
Webhook
Webhook
Sticky Note
Sticky Note
Google Drive
Google Drive
Create Worksheet
Google Sheets
Return if Null
Code
Doesn't exist?
If
Set Logging Details
Set
Create Log
Google Sheets
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note