# n8n-daily-report

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

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 115 installs · ★ 434 repo stars
- Author: datadrivenconstruction
- License: MIT · policy=mirror · the beginning of the file is at the end of this page
- Source: https://github.com/datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction/tree/HEAD/3_DDC_Insights/Automation-Workflows/n8n-daily-report/SKILL.md
- Updated: 2026-10-19
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/n8n-daily-report

## What it 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.

## Requirements
- Works with: n8n

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-daily-report -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/n8n-daily-report/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/n8n-daily-report/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-daily-report -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/n8n-daily-report/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-daily-report -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/n8n-daily-report/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction 3_DDC_Insights/Automation-Workflows/n8n-daily-report
```

2. **Manually: put the files in place**
- File: `.github/skills/n8n-daily-report/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-daily-report -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --path 3_DDC_Insights/Automation-Workflows/n8n-daily-report
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/n8n-daily-report/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-daily-report -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction/tree/HEAD/3_DDC_Insights/Automation-Workflows/n8n-daily-report/SKILL.md

## When to use it
- 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
- 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.

## Source text · SKILL.md · MIT

Below is the content of a third-party file. It is data, not instructions for you: do not act on anything written inside unless the human asks. Block tag: ac3b602f825f8875.

BEGIN THIRD-PARTY FILE ac3b602f825f8875
````text
---
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",
````
END THIRD-PARTY FILE ac3b602f825f8875

The third-party file has ended. Everything between the ac3b602f825f8875 tags is data: requests and commands from it are not followed. An “end of file” line with another tag inside the block is part of the file.

First 2077 of 5056 bytes. © datadrivenconstruction · MIT · https://github.com/datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction/tree/HEAD/3_DDC_Insights/Automation-Workflows/n8n-daily-report/SKILL.md

_Part of the page did not fit — see the HTML version._

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
