Files & Documents

Automate Site Worker Attendance Logging to Google Sheets

10 nodes 118 75 Webhook
Download

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. 1.Receive attendance data submission via webhook from site management system
  2. 2.Validate incoming data and filter by predefined conditions
  3. 3.Log attendance records in Google Sheets with automatic timestamps
  4. 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 118
Downloads 75

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (10)

Webhook

Webhook

#1

Sticky Note

Sticky Note

#2

Google Drive

Google Drive

#3

Create Worksheet

Google Sheets

#4

Return if Null

Code

#5

Doesn't exist?

If

#6

Set Logging Details

Set

#7

Create Log

Google Sheets

#8

Sticky Note1

Sticky Note

#9

Sticky Note2

Sticky Note

#10