A specialized tool for sending high-volume, personalized emails by merging spreadsheet data with custom templates.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install batch-send-mail
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install batch-send-mail using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Batch Send Mail?
Batch Send Mail is a robust automation utility designed to simplify complex email outreach. It allows users to transform static spreadsheets into dynamic, personalized communication streams. By leveraging Openclaw Skills, this tool handles the heavy lifting of parsing recipient lists, mapping variables to placeholders, and ensuring secure delivery via SMTP.
This skill is built for reliability and precision, featuring a dedicated dry-run mode that lets developers and marketers preview their content before it hits an inbox. It supports both plain text and rich HTML formats, making it versatile enough for everything from technical notifications to branded marketing campaigns.
Batch Send Mail Use Cases
- Sending bulk personalized invitations for corporate events or webinars.
- Executing targeted digital marketing campaigns with customer-specific variables.
- Distributing automated notifications, such as payment confirmations or account updates.
- Delivering academic materials or course notifications to large groups of students.
- Automating the distribution of reports or documents with individualized attachments.
How Batch Send Mail Works
- The user prepares a data source in CSV or Excel format where the first column is the recipient email.
- An email template is created using placeholders like {variable1} or {v1} to indicate where dynamic data should be inserted.
- The skill reads the data source and maps each row's values to the corresponding placeholders in the template.
- If enabled, the dry-run mode generates a preview of the emails to verify that the variable replacement is accurate.
- Upon confirmation, the skill establishes a secure connection to the SMTP server (Gmail, Outlook, etc.).
- Emails are dispatched in a batch, and a final summary report is provided to the user.
Batch Send Mail Setup
To get started with this skill in your environment, ensure you have Python 3.6+ and the required libraries installed:
pip install pandas openpyxl
Run the script for the first time to trigger the interactive SMTP configuration, which is a key part of the setup for Openclaw Skills:
python scripts/batch_send_mail.py --table contacts.csv --template email_template.txt --subject "Your Subject Here" --dry-run
Your SMTP credentials (server, port, email, and auth code) will be automatically saved to config/config.ini for future use.
Batch Send Mail Data Schema & Taxonomy
| Requirement | Description | Note |
|---|---|---|
| Table Column 1 | Recipient Email Address | Required |
| Table Column 2 | CC Email Addresses | Optional (use |
| Table Column 3+ | Template Variables | Maps to {variable1}, {variable2}, etc. |
| Template File | .txt or .html file | Contains placeholders for injection |
| Config File | config/config.ini | Stores SMTP server and sender credentials |
Batch Send Mail Advanced Features
- Supports HTML rich-text templates for professional, branded email layouts.
- Integrated dry-run functionality to preview emails and prevent accidental bulk errors.
- Automated configuration persistence that saves SMTP settings across Openclaw Skills sessions.
- Universal attachment support allowing the same file to be sent to all recipients in a batch.
- Flexible variable mapping supporting both long-form {variableN} and short-form {vN} syntax.
SKILL.md
Loading
Related Openclaw Skills
WeChat Article to Markdown
Transform WeChat Official Account articles into high-quality, noise-free Markdown files with preserved formatting and local images.
Uniqlo Product Query
A specialized automation tool for querying Uniqlo's Chinese API to find and report on discounted clothing items by category and size.
Git Helper
A specialized AI assistant designed to streamline Git operations, resolve complex merge conflicts, and manage version control workflows.
LightRAG Memory
A high-performance semantic memory system for AI agents that combines vector embeddings with knowledge graphs for precise, context-aware information retrieval.
obclip
A specialized CLI utility designed to transform live web pages into clean, structured Markdown files or integrated Obsidian notes.
Hermes Agent Integration
Connect OpenClaw with the NousResearch Hermes Agent to leverage autonomous learning cycles and multi-platform agent orchestration.
Featured*
