A powerful skill enabling AI agents to programmatically read, write, and format spreadsheet data inside Obsidian via the Sheet Plus REST API.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install obsidian-sheet-plus-skill
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 obsidian-sheet-plus-skill 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 Obsidian Sheet Plus?
The Obsidian Sheet Plus skill provides developers and AI agents with a comprehensive REST API integration to manipulate Excel-like spreadsheets directly within Obsidian. Built on top of the Sheet Plus plugin, this tool bridges the gap between text-based personal knowledge management and structured data analysis. By employing this skill, agents can seamlessly read, write, and execute formulas inside Obsidian notebooks, turning passive notes into dynamic data hubs.
With Openclaw Skills like this, users can automate repetitive spreadsheet workflows without leaving their markdown environment. Whether you are generating reports, maintaining trackers, or running complex calculations, this integration provides the speed of local execution combined with the flexibility of modern API-driven automation.
Obsidian Sheet Plus Use Cases
- Automated report generation and financial tracking directly inside your Obsidian vault.
- Real-time data syncs from external APIs into localized .sheet files using Openclaw Skills.
- Auto-formatting and applying conditional rules to make personal knowledge graphs visually intuitive.
- Cleaning up, filtering, and organizing multi-column datasets without manual Excel imports.
How Obsidian Sheet Plus Works
- Status Initialization: The AI agent queries the
GET /endpoint to verify that the Sheet Plus REST API is active and reachable locally. - Workbook Inspection: The agent fetches the directory of worksheets using
GET /get_sheet_listto find the target spreadsheet file. - Safe Execution: Upon matching the required range or document, the agent executes bulk reads, updates, styles, or data validations via dedicated endpoints.
Obsidian Sheet Plus Setup
Ensure Obsidian is running with the Sheet Plus plugin enabled. By default, the API binds to port 3000.
Configure the base URL using an environment variable if your setup differs:
export OBSIDIAN_SHEET_PLUS_BASE_URL=\"http://127.0.0.1:3000\"
If you have authentication enabled inside the plugin, pass your custom token via the standard header config:
# Example of using the endpoint with an API key
curl -H \"X-API-KEY: your-api-key\" http://127.0.0.1:3000/
Obsidian Sheet Plus Data Schema & Taxonomy
The Sheet Plus plugin API structures operations based on classic Excel components. Data can be accessed or styled globally using range coordinates.
Key API Structures
| Object | Type | Description |
|---|---|---|
| Range | A1 Notation (e.g., A1:C10) |
Defines the coordinate boundaries for data selection |
| Workbook | JSON Array | The collection containing sheet configurations and values |
| Styling | JSON Object | Maps properties such as fonts, colors, borders, and alignments |
Obsidian Sheet Plus Advanced Features
- Three-Step Safety Check: Guarantees high reliability by checking connectivity and catalog lists before executing destructive writes.
- Conditional Formatting Rules: Programmatically assign visually alerting styles to cell ranges dynamically based on context.
- Dynamic Filter Configurations: Easily inject filters or modify existing criteria to filter out unwanted rows instantly inside your local vault using Openclaw Skills.
SKILL.md
Loading
Related Openclaw Skills
AlphaGBM Duan Yongping Analysis
An AI-driven options analysis tool implementing the Duan Yongping seller framework to calculate Sell Put entry options, Covered Call yields, and VIX-based fear signals.
AlphaGBM Compare
A stock and options comparison tool that analyzes up to five tickers across metrics like technicals, valuations, and GBM Five Pillars to identify winning trades.
AlphaGBM Earnings IV Panel
AlphaGBM Earnings IV Panel provides real-time implied volatility (IV) crush analysis, implied stock moves, and ready-to-trade Iron Condor pricing for earnings-season strategies.
E-commerce Video Script Generator
An automated e-commerce video script generator that translates product selling points into highly localized 10-second and 15-second multi-language storyboard scripts.
Sensitive Word Checker
An automated scanning utility for PDF, Word, and Excel files designed to detect, isolate, and precisely highlight sensitive or prohibited terms.
AlphaGBM Company Profile
Automate personal investment workspace management with self-updating company profiles, 8-year valuation bands, and financial health red flags.
Featured*
