Skip to main content
skill CX Codex

n8n-daily-report — Claude Code skill: what it does, how to install

n8n-daily-report — an n8n workflow that gathers site data on a schedule and sends out a finished daily report.

MIT 115 installs ★ 434 updated 2026-10-19

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-daily-report -a claude-code
Open on GitHub

What n8n-daily-report does

The skill carries a JSON description of an n8n workflow for the daily site report. It starts from a cron rule (0 17 * * 1-5) or from a POST webhook on the daily-report-data path. Nodes then fetch weather for the site coordinates from OpenWeatherMap, photos from Procore over OAuth2, labor rows from an xlsx file, and a JS code node merges temperature, worker count, total hours and photo count into one object.

Two Python helpers come with it. trigger_daily_report posts project data to the webhook; format_labor_data reshapes crew entries into the fields the workflow reads. The PDF is produced by whatever service sits behind PDF_SERVICE_URL, and the result goes out by email plus an upload to a SharePoint folder.

Set WEATHER_API_KEY, PROCORE_API, PDF_SERVICE_URL and SHAREPOINT_SITE before importing. Otherwise the HTTP nodes fail on the first run. Weekdays only: a Saturday shift gets no report until you change the cron expression.

What it helps with

  • generate a daily site report without chasing data by hand
  • pull weather for the site coordinates into the report
  • roll xlsx labor rows into totals for workers and hours
  • email the PDF and drop a copy into a SharePoint folder
  • kick off the report from a Python script through the webhook

Example prompts for the agent

  • Build the n8n daily report workflow: weather, Procore photos, labor sheet, email.
  • Add a SharePoint upload step to the report workflow.
  • Wire format_labor_data to my timesheet export and check the field names.

How to install n8n-daily-report

1Skills CLI (Vercel)

npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-daily-report -a claude-code

2Manually: put the files in place

~/.claude/skills/n8n-daily-report/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/n8n-daily-report/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about n8n-daily-report

How do I install n8n-daily-report in Claude Code?

Run npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-daily-report -a claude-code. The skill file lands at ~/.claude/skills/n8n-daily-report/SKILL.md.

What does n8n-daily-report do?

It gives the agent the n8n workflow config that collects weather, photos and labor data on a schedule or webhook, builds a PDF report and distributes it.

What is required before the workflow runs?

A running n8n instance, Python 3 for the helpers, and four environment variables: WEATHER_API_KEY, PROCORE_API, PDF_SERVICE_URL, SHAREPOINT_SITE.

Source text

SKILL.md · MIT
---
name: "n8n-daily-report"
description: "Automate daily construction report generation using n8n workflow automation."
homepage: "https://datadrivenconstruction.io"
metadata: {"openclaw": {"emoji": "🔧", "os": ["darwin", "linux", "win32"], "homepage": "https://datadrivenconstruction.io", "requires": {"bins": ["python3"]}}}
---
# n8n Daily Report Automation

## Business Case

Daily reports are critical but time-consuming. This n8n workflow automates collection of site data from multiple sources and generates formatted daily reports.

## Workflow Overview

```
[Site Data Sources] → [n8n Webhook] → [Data Processing] → [Report Generation] → [Distribution]
```

## n8n Workflow Configuration

### 1. Trigger Node: Schedule + Webhook

```json
{
  "nodes": [
    {
      "name": "Daily Schedule",
      "type": "n8n-nodes-base.scheduleTrigger",
      "parameters": {
        "rule": {
          "interval": [{"field": "cronExpression", "expression": "0 17 * * 1-5"}]
        }
      }
    },
    {
      "name": "Webhook Input",
      "type": "n8n-nodes-base.webhook",
      "parameters": {
        "httpMethod": "POST",
        "path": "daily-report-data"
      }
    }
  ]
}
```

### 2. Data Collection Nodes

```json
{
  "nodes": [
    {
      "name": "Get Weather Data",
      "type": "n8n-nodes-base.httpRequest",
      "parameters": {
        "url": "https://api.openweathermap.org/data/2.5/weather",
        "qs": {
          "lat": "={{$json.site_lat}}",
          "lon": "={{$json.site_lon}}",
          "appid": "={{$env.WEATHER_API_KEY}}"
        }
      }
    },
    {
      "name": "Get Site Photos",
      "type": "n8n-nodes-base.httpRequest",
      "parameters": {
        "url": "={{$env.PROCORE_API}}/projects/{{$json.project_id}}/images",
        "authentication": "oAuth2"
      }
    },
    {
      "name": "Get Labor Data",
      "type": "n8n-nodes-base.spreadsheetFile",
      "parameters": {
        "operation": "read",
        "fileFormat": "xlsx"
      }
    }
  ]
}
```

### 3. Data Processing

```json
{
  "name": "Process Report Data",
  "type": "n8n-nodes-base.code",
  "parameters": {
    "jsCode": "const items = $input.all();\n\nconst weather = items[0].json;\nconst photos = items[1].json;\nconst labor = items[2].json;\n\nconst report = {\n  date: new Date().toISOString().split('T')[0],\n  project: $('Webhook Input').first().json.project_name,\n  weather: {\n    condition: weather.weather[0].main,\n    temp_high: Math.round(weather.main.temp_max - 273.15),\n    temp_low: Math.round(weather.main.temp_min - 273.15)\n  },\n  labor_summary: {\n    total_workers: labor.reduce((sum, l) => sum + l.workers, 0),\n    total_hours: labor.reduce((sum, l) => sum + l.hours, 0)\n  },\n  photo_count: photos.length\n};\n\nreturn [{json: report}];"
  }
}
```

### 4. Report Generation

```json
{
  "name": "Generate PDF Report",
  "type": "n8n-nodes-base.httpRequest",
  "parameters": {
    "method": "POST",
    "url": "={{$env.PDF_SERVICE_URL}}/generate",
    "body": {
      "template": "daily_report",
      "data": "={{$json}}"
    }
  }
}
```

### 5. Distribution

```json
{
  "nodes": [
    {
      "name": "Send Email",
      "type": "n8n-nodes-base.emailSend",
      "parameters": {
        "toEmail": "={{$json.distribution_list}}",
        "subject": "Daily Report - {{$json.project}} - {{$json.date}}",
        "attachments": "={{$node['Generate PDF Report'].json.file}}"
      }
    },
    {
      "name": "Upload to SharePoint",
      "type": "n8n-nodes-base.microsoftSharePoint",
      "parameters": {
        "operation": "upload",
        "siteId": "={{$env.SHAREPOINT_SITE}}",
        "folderId": "/Daily Reports/{{$json.date}}"
      }
    }
  ]
}
```

## Python Helper Functions

```python
import requests
from datetime import date

def trigger_daily_report(project_data: dict, webhook_url: str):
    """Trigger n8n daily report workflow."""
    payload = {
        "project_id": project_data['id'],
        "project_name": project_data['name'],
        "site_lat": project_data['latitude'],
        "site_lon": project_data['longitude'],
        "distribution_list": project_data['stakeholder_emails']
    }

    response = requests.post(webhook_url, json=payload)
    return response.status_code == 200


def format_labor_data(labor_entries: list) -> list:
    """Format labor data for n8n processing."""
    formatted = []
    for entry in labor_entries:
        formatted.append({
            'trade': entry['trade'],
            'company': entry['company'],
            'workers': entry['worker_count'],
            'hours': entry['total_hours'],
            'activities': entry.get('activities', [])
        })
    return formatted
```

## Quick Start

1. Import workflow to n8n
2. Configure environment variables:
   - `WEATHER_API_KEY`
   - `PROCORE_API`
   - `PDF_SERVICE_URL`
   - `SHAREPOINT_SITE`
3. Set schedule trigger for desired time
4. Configure email distribution list

## Resources
- **n8n Documentation**: https://docs.n8n.io
- **DDC Book**: Chapter 4.2 - Workflow Automation

© datadrivenconstruction · MIT · datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction

Similar skills

All skills for Automation and no-code: n8n, Zapier, Make →
n8n-workflow-patterns czlonkowski n8n-workflow-patterns provides six architectural patterns for n8n workflows: webhook, API, database, AI agent, scheduled tasks, batch processing. Guides pattern selection and required nodes. CX Codex +1 12,400installs n8n-error-handling-official n8n-io n8n-error-handling-official — a Claude skill that pushes your agent to wire real error handling in n8n: per-node error branches, status codes by cause, and a workflow-level error workflow. CX Codex +1 2,500installs n8n-trigger-testing-strategies proffesor-for-testing n8n-trigger-testing-strategies — a skill for testing how n8n workflows get triggered: webhooks, cron schedules, service events, polling. Useful when a workflow fires at the wrong moment or not at all. CX Codex +1 128installs sheets-automation claude-office-skills sheets-automation — a skill for automating Google Sheets: data sync, task reminders, reports and dashboards. Useful when spreadsheets are already part of your workflow. CX Codex +1 5,400installs n8n-mcp-tools-expert czlonkowski n8n-mcp-tools-expert is a Claude Code skill that guides agents using n8n-mcp tools. It triggers when searching nodes, validating parameters, editing workflows, and auditing instance security. CX Codex +1 8,800installs n8n-workflow-lifecycle-official n8n-io n8n-workflow-lifecycle-official is a Claude Code skill for building, checking, and publishing n8n workflows. It activates for workflow design, organization, and release tasks. CX Codex +1 2,900installs

From the same set156

The whole set →
progress-monitoring-cv The progress-monitoring-cv skill reads site photos and drone imagery to estimate construction progress, flag safety concerns, and compare built work with BIM plans. CX Codex +1 115installs cwicr-data-loader cwicr-data-loader is a Claude Code skill for loading the DDC CWICR database from Parquet, Excel, CSV, and Qdrant. It provides automatic schema detection and type validation. CX Codex +1 115installs open-data-integrator open-data-integrator connects open construction datasets to your coding agent: material cost indices, labor benchmarks, and weather records. CX Codex +1 115installs csv-handler The csv-handler skill detects CSV encodings and delimiters, cleans tables, and can combine or split files. It’s aimed at exports from construction software. CX Codex +1 115installs big-data-analysis big-data-analysis analyzes construction datasets using Pandas dataframes. Computes portfolio benchmarks and flags cost anomalies. CX Codex +1 115installs cwicr-unit-converter cwicr-unit-converter converts between metric and imperial construction units, normalizing BIM and CWICR data across different measurement systems. Eliminates conversion errors when working with mixed data sources. CX Codex +1 115installs clash-detection-analysis clash-detection-analysis detects geometric clashes between IFC BIM elements, identifying physical intersections and clearance violations before construction starts. CX Codex +1 115installs scenario-planner scenario-planner models construction scenarios and compares options by cost, schedule, and resources. Helps you see what happens if you double the crew or compress the timeline. CX Codex +1 115installs

Project sponsors

Companies that keep this analytics open