n8n-photo-report — Claude Code skill: what it does, how to install
n8n-photo-report automates construction site photo reports using n8n workflows and AI image analysis. Gathers incoming site photos and highlights safety concerns.
MIT 116 installs ★ 434 updated 2026-10-19
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-photo-report -a claude-codeWhat n8n-photo-report does
This skill provides an n8n automation pipeline tailored for construction site monitoring. Incoming photos arrive via webhook triggers or a monitored Dropbox folder, then pass to Claude Vision to detect ongoing tasks, approximate completion, weather, and safety concerns.
A JavaScript node parses the response, tags records with categories such as CONCRETE or MEP, and stores everything in an Airtable table. On a weekday schedule, n8n compiles the daily photos, tallies safety incidents, and dispatches an HTML report by email. A Python helper script is included for batch file uploads.
Without an active ANTHROPIC_API_KEY and an existing Airtable base, the workflow cannot process incoming images or record results. The local environment must also have python3 available.
What it helps with
- ingest construction photos automatically through webhooks or Dropbox
- detect jobsite safety issues from images using Claude Vision
- categorize site tasks and store metadata in Airtable
- dispatch daily photo summary emails on a weekday schedule
Example prompts for the agent
- Set up the n8n workflow for construction photo reporting
- Show the Python helper script to batch upload images to the n8n webhook
- Help configure the scheduled daily photo report email in n8n
How to install n8n-photo-report
1Skills CLI (Vercel)
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-photo-report -a claude-code2Manually: put the files in place
~/.claude/skills/n8n-photo-report/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/n8n-photo-report/
1Skills CLI (Vercel)
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-photo-report -a codex2Manually: put the files in place
.agents/skills/n8n-photo-report/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-photo-report -a cursor2Manually: put the files in place
.cursor/skills/n8n-photo-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-photo-report2Manually: put the files in place
.github/skills/n8n-photo-report/SKILL.md1Skills CLI (Vercel)
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-photo-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-photo-reportManually: put the files in place
.devin/skills/n8n-photo-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-photo-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-photo-report
How to install n8n-photo-report in Claude Code?
Run npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill n8n-photo-report -a claude-code in your terminal.
What does n8n-photo-report do?
It configures an n8n automation flow that receives jobsite photos, extracts activity and safety observations with Claude Vision, updates Airtable, and emails summary reports.
What prerequisites are required before using this workflow?
You need a running n8n instance, an ANTHROPIC_API_KEY, an Airtable base with a Site Photos table, and email credentials for delivery.
Source text
SKILL.md · MIT
---
name: "n8n-photo-report"
description: "Automate construction photo report generation using n8n with AI-powered image analysis."
homepage: "https://datadrivenconstruction.io"
metadata: {"openclaw": {"emoji": "🔧", "os": ["darwin", "linux", "win32"], "homepage": "https://datadrivenconstruction.io", "requires": {"bins": ["python3"]}}}
---
# n8n Photo Report Automation
## Business Case
Site photos require organization, analysis, and reporting. This workflow automates photo collection, AI analysis, and report generation.
## Workflow Overview
```
[Photo Upload] → [AI Analysis] → [Categorization] → [Report Generation] → [Distribution]
```
## n8n Workflow Configuration
### 1. Photo Input Triggers
```json
{
"nodes": [
{
"name": "Photo Webhook",
"type": "n8n-nodes-base.webhook",
"parameters": {
"httpMethod": "POST",
"path": "photo-upload",
"options": {
"binaryData": true
}
}
},
{
"name": "Watch Dropbox Folder",
"type": "n8n-nodes-base.dropbox",
"parameters": {
"operation": "listFolder",
"path": "/SitePhotos/{{$today}}"
}
}
]
}
```
### 2. AI Image Analysis
```json
{
"name": "Analyze with Claude Vision",
"type": "n8n-nodes-base.httpRequest",
"parameters": {
"method": "POST",
"url": "https://api.anthropic.com/v1/messages",
"headers": {
"x-api-key": "={{$env.ANTHROPIC_API_KEY}}",
"anthropic-version": "2023-06-01"
},
"body": {
"model": "claude-3-5-sonnet-20241022",
"max_tokens": 1024,
"messages": [{
"role": "user",
"content": [
{
"type": "image",
"source": {
"type": "base64",
"media_type": "image/jpeg",
"data": "={{$binary.data.toString('base64')}}"
}
},
{
"type": "text",
"text": "Analyze this construction site photo. Identify: 1) Work activity visible, 2) Approximate completion status, 3) Any safety concerns, 4) Weather conditions. Return JSON format."
}
]
}]
}
}
}
```
### 3. Categorize and Store
```json
{
"nodes": [
{
"name": "Parse AI Response",
"type": "n8n-nodes-base.code",
"parameters": {
"jsCode": "const response = JSON.parse($json.content[0].text);\n\nreturn [{\n json: {\n filename: $('Photo Webhook').first().json.filename,\n timestamp: new Date().toISOString(),\n activity: response.work_activity,\n completion: response.completion_status,\n safety_issues: response.safety_concerns,\n weather: response.weather,\n category: response.work_activity.includes('concrete') ? 'CONCRETE' :\n response.work_activity.includes('steel') ? 'STEEL' :\n response.work_activity.includes('mep') ? 'MEP' : 'GENERAL'\n }\n}];"
}
},
{
"name": "Store in Airtable",
"type": "n8n-nodes-base.airtable",
"parameters": {
"operation": "create",
"table": "Site Photos",
"fields": {
"Filename": "={{$json.filename}}",
"Date": "={{$json.timestamp}}",
"Activity": "={{$json.activity}}",
"Category": "={{$json.category}}",
"Completion": "={{$json.completion}}",
"Safety Issues": "={{$json.safety_issues}}"
}
}
}
]
}
```
### 4. Generate Photo Report
```json
{
"nodes": [
{
"name": "Schedule Report",
"type": "n8n-nodes-base.scheduleTrigger",
"parameters": {
"rule": {"interval": [{"field": "cronExpression", "expression": "0 18 * * 1-5"}]}
}
},
{
"name": "Get Today Photos",
"type": "n8n-nodes-base.airtable",
"parameters": {
"operation": "list",
"table": "Site Photos",
"filterByFormula": "IS_SAME({Date}, TODAY(), 'day')"
}
},
{
"name": "Generate Report",
"type": "n8n-nodes-base.code",
"parameters": {
"jsCode": "const photos = $input.all();\n\nconst byCategory = {};\nlet safetyIssues = [];\n\nphotos.forEach(p => {\n const cat = p.json.fields.Category;\n if (!byCategory[cat]) byCategory[cat] = [];\n byCategory[cat].push(p.json.fields);\n \n if (p.json.fields['Safety Issues'] && p.json.fields['Safety Issues'] !== 'None') {\n safetyIssues.push({\n photo: p.json.fields.Filename,\n issue: p.json.fields['Safety Issues']\n });\n }\n});\n\nreturn [{\n json: {\n date: new Date().toISOString().split('T')[0],\n total_photos: photos.length,\n by_category: byCategory,\n safety_issues: safetyIssues,\n safety_count: safetyIssues.length\n }\n}];"
}
}
]
}
```
### 5. Distribution
```json
{
"name": "Send Report Email",
"type": "n8n-nodes-base.emailSend",
"parameters": {
"toEmail": "={{$env.PHOTO_REPORT_RECIPIENTS}}",
"subject": "Site Photo Report - {{$json.date}} ({{$json.total_photos}} photos)",
"html": "<h2>Daily Photo Report</h2><p>Total Photos: {{$json.total_photos}}</p><h3>Safety Issues: {{$json.safety_count}}</h3>{{#if $json.safety_issues.length}}<ul>{{#each $json.safety_issues}}<li>{{photo}}: {{issue}}</li>{{/each}}</ul>{{/if}}"
}
}
```
## Python Helper
```python
import requests
import base64
def upload_photo_to_workflow(image_path: str, webhook_url: str, metadata: dict):
"""Upload photo to n8n workflow."""
with open(image_path, 'rb') as f:
image_data = base64.b64encode(f.read()).decode()
payload = {
'filename': image_path.split('/')[-1],
'image_data': image_data,
'project_id': metadata.get('project_id'),
'location': metadata.get('location'),
'captured_by': metadata.get('captured_by')
}
response = requests.post(webhook_url, json=payload)
return response.json()
def batch_upload_photos(photo_paths: list, webhook_url: str, project_id: str):
"""Batch upload multiple photos."""
results = []
for path in photo_paths:
result = upload_photo_to_workflow(path, webhook_url, {'project_id': project_id})
results.append(result)
return results
```
## Quick Start
1. Import workflow to n8n
2. Configure API keys:
- `ANTHROPIC_API_KEY` for Claude Vision
- Airtable credentials
- Email configuration
3. Create Airtable base with "Site Photos" table
4. Test with sample photo upload
## Resources
- **n8n Documentation**: https://docs.n8n.io
- **Claude Vision API**: https://docs.anthropic.com
- **DDC Book**: Chapter 4.2 - Workflow Automation
© datadrivenconstruction · MIT · datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction