Agent skill · marketing growth · datadrivenconstruction
n8n-pto-pipeline
Create n8n workflow for daily task assignment from PTO engineer to foreman via Telegram bot with status reporting.
Why this skill is useful
Adds a complete n8n workflow with executable scripts for automating task assignments and status reporting via Telegram, which the AI cannot generate from existing knowledge.
What it needs
Requires google-sheets, n8n installed locally. Requires telegram account access. About 3k tokens when loaded. Last updated 2026-02-14. 265 stars on the source repository.
What this skill does
n8n PTO-Foreman Pipeline Business Case Problem Statement Daily work planning in construction involves: Manual task distribution from PTO (engineering) to field crews Paper-based or phone-based task assignment No systematic tracking of task completion Delayed reporting and status updates Solution Automated n8n pipeline connecting Google Sheets task lists with Telegram bots for real-time task distribution and status collection. Business Value Real-time distribution - Tasks delivered automatically at 8:00 AM Digital tracking - All assignments and statuses in one table Mobile-first - Foremen use familiar Telegram interface No app installation - Works with any phone with Telegram Technical Implementation Architecture n8n Pipeline Components 1. Morning Trigger (8:00 AM) 2. Get Tasks from Google Sheets 3. Filter Tasks by Foreman 4. Format and Send via Telegram 5. Status Update Handler Google Sheets Structure Tasks Sheet: Column Description -------- ------------- taskid Unique task identifier taskname Task title description Detailed description location Work location deadline Due date/time foremanchatid Telegram chat ID of assigned foreman status Current status comment Foreman comment Foremen Sheet: Column Description -------- ------------- name Foreman name chatid Telegram chat ID registeredat Registration timestamp Telegram Bot Setup 1. Create bot via @BotFather 2. Get bot token 3. Configure webhook in n8n 4. For local testing, use n8n tunnel: Usage Flow For PTO Engineer: 1. Open Google Sheets task list 2. Add tasks with foreman assignments 3. System automatically sends at 8:00 AM For Foreman: 1. Receive tasks via Telegram bot 2. Reply to task message with status 3. System updates Google Sheets automatically For Manager: 1. View real-time status in Google Sheets 2. Generate reports from historical data 3. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills datadrivenconstruction/n8n-pto-pipeline