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
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-daily-report -a claude-codeWhat 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_datato 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-code2Manually: put the files in place
~/.claude/skills/n8n-daily-report/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/n8n-daily-report/
1Skills CLI (Vercel)
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-daily-report -a codex2Manually: put the files in place
.agents/skills/n8n-daily-report/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-daily-report -a cursor2Manually: put the files in place
.cursor/skills/n8n-daily-report/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction 3_DDC_Insights/Automation-Workflows/n8n-daily-report2Manually: put the files in place
.github/skills/n8n-daily-report/SKILL.md1Skills CLI (Vercel)
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-daily-report -a gemini-cli2Platform CLI
gemini skills install https://github.com/datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --path 3_DDC_Insights/Automation-Workflows/n8n-daily-reportManually: put the files in place
.devin/skills/n8n-daily-report/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-daily-report -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
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