N8N Daily Report

What This Skill Does

The N8N Daily Report skill automates the labor-intensive process of manual construction reporting. By integrating directly with site data sources—such as Procore for imagery, OpenWeather for environmental logs, and external labor spreadsheets—this skill leverages n8n to aggregate, normalize, and format site activity. The workflow triggers automatically on a daily schedule or via webhook, processes the collected data points into a structured summary, and generates a professional PDF report ready for distribution to stakeholders and project managers.

Installation

To integrate this skill into your OpenClaw environment, execute the following command in your terminal: clawhub install openclaw/skills/skills/datadrivenconstruction/n8n-daily-report Ensure you have configured your environment variables, specifically WEATHER_API_KEY, PROCORE_API, and PDF_SERVICE_URL, within your n8n instance to allow the workflow to authenticate and process data correctly.

Use Cases

• Project Management Oversight: Automatically generate end-of-day site summaries for project managers without requiring field superintendents to perform manual entry.
• Regulatory Compliance: Maintain consistent weather and labor documentation for safety audits and insurance verification.
• Stakeholder Updates: Automatically email or upload PDF reports to a shared cloud drive, ensuring clients receive daily updates on project progress, staffing levels, and site conditions.

Example Prompts

1. "OpenClaw, please run the N8N Daily Report for the 'Downtown High-Rise' project using today's data."
2. "Show me a status report on the labor efficiency metrics from the most recent N8N generated report."
3. "Check if the Daily Report automation for the East Wing site has finished generating the PDF for today."

Tips & Limitations

• Data Integrity: Ensure your source spreadsheets for labor data follow a consistent header schema to prevent calculation errors in the Process Report Data node.
• Rate Limiting: If managing multiple projects, stagger the schedule trigger to avoid hitting Procore or weather API rate limits.
• Workflow Customization: The current logic calculates totals; if your project requires granular data (e.g., individual contractor hours), modify the JavaScript block to group by trade category rather than summing totals.