Daily Report Generator

What This Skill Does

The Daily Report Generator is an advanced automation skill for OpenClaw designed to streamline the administrative overhead of construction site management. It acts as a central data hub, pulling inputs from fragmented sources like foreman timesheets, project databases, and real-time weather APIs to synthesize them into a structured, professional PDF document. By automating the extraction, formatting, and distribution processes, the skill removes the manual burden of copy-pasting data and manually drafting reports, allowing site managers to focus on site operations and safety.

Installation

To integrate this skill into your OpenClaw agent, execute the following command in your terminal or command interface:

clawhub install openclaw/skills/skills/datadrivenconstruction/daily-report-generator

Ensure your agent has the necessary read/write permissions for your project management spreadsheet or database before triggering the first report.

Use Cases

• Project Management Optimization: Drastically reduce the time spent on end-of-day documentation from 45 minutes to under 10 minutes.
• Stakeholder Transparency: Automatically email consistent, professional PDFs to project owners and investors every evening.
• Data Integrity: Minimize manual entry errors by fetching workforce hours directly from logged timesheet systems.
• Incident Auditing: Maintain a perfect historical log of site progress matched with weather conditions, which is crucial for potential legal or insurance claims regarding site delays.

Example Prompts

1. "Generate today's construction report for the 'ЖК Солнечный' project and email it to the site manager and lead architect."
2. "Draft a daily report for project ID DCR-2026-024 based on the latest entries in the Google Sheets tracker and add a summary about the completed HVAC ductwork."
3. "Summarize the progress for the last three days into a cumulative report and highlight any discrepancies between planned and actual workforce hours."

Tips & Limitations

• Connectivity: The skill relies on external API integrations. Ensure your weather API keys and database credentials are kept up to date in the agent's configuration.
• Data Structure: For optimal performance, maintain consistent headers in your source spreadsheets. If the field names change, the skill may require a brief re-mapping.
• Photo Processing: While the skill aggregates data, ensure photos are uploaded to the specified bucket or directory by 4:00 PM for them to be included in the daily PDF export.
• Review: Always perform a quick final check of the narrative summary before the automatic distribution, especially if significant site incidents occurred during the day.