template-engine

What This Skill Does

The template-engine skill is a powerful automation utility for OpenClaw that automates document generation by merging structured data into predefined templates. It functions similarly to traditional mail merge software but with significantly higher flexibility, supporting complex document types like Microsoft Word, Excel, and PowerPoint. By utilizing a Jinja2-based syntax, the engine allows users to define placeholders (e.g., {{ name }}) within their files, which the skill then programmatically populates with dynamic content. It handles both simple text replacement and sophisticated logical operations, such as conditional formatting, loops for generating tables, and date filtering, making it an essential tool for high-volume document workflows.

Installation

To integrate this skill into your agent workspace, use the command: clawhub install openclaw/skills/skills/lijie420461340/template-engine

Use Cases

• Automated Communication: Generate hundreds of personalized letters, invitations, or email drafts from a single CSV contact list.
• Business Reporting: Automatically pull database output into formatted Excel templates to produce consistent, branded internal reports.
• Operations: Create certificates of completion, invoices, or formal contracts by filling placeholders with client-specific metadata.
• Bulk Documentation: Use loops to generate dynamic table rows for inventory lists or multi-project summaries within documents.

Example Prompts

1. "Mail merge my 'Project_Proposal_Template.docx' using the data in 'client_list.csv' and save the output to the /contracts folder."
2. "Generate a monthly performance report by filling the 'Sales_Report.xlsx' template with data from my last three weeks of logs."
3. "Create personalized certificate PDFs for every name listed in this spreadsheet using my existing company template."

Tips & Limitations

• Syntax: Ensure all placeholders match the Jinja2 format strictly, or they will be ignored by the engine.
• Data Structure: When using bulk generation, verify that your CSV headers match the variable names used in your templates exactly.
• File Security: Since this skill performs file-write operations, ensure your input data is sanitized and the target directory has appropriate write permissions.
• Complexity: While the skill supports advanced logic like conditional statements, keep templates clean to avoid rendering errors in complex layouts.