excel-workflow

What This Skill Does

The excel-workflow skill is a robust, automated solution for managing Excel files within your OpenClaw environment. It is designed to act as a bridge between your local file system, SQLite databases, and Google Drive, ensuring your data is both searchable and backed up. The skill excels at preserving complex spreadsheet logic—specifically formulas—when you need to perform cell-level updates. By utilizing openpyxl for high-precision file manipulation and rclone for secure cloud synchronization, it creates a seamless, professional-grade workflow for users who rely on Excel for business or personal tasks.

Installation

1. Install Prerequisites: Ensure Python 3.8+ and rclone are installed. On macOS, use brew install rclone.
2. Configure Drive: Run rclone config to link your Google Drive account, naming the remote gdrive.
3. Create Folder: Run rclone mkdir gdrive:Excel/ to establish your cloud storage target.
4. Install Skill: Run clawhub install openclaw/skills/skills/amaialex/excel-workflow in your terminal.
5. Environment Setup: The installation will automatically handle dependency management, setting up the SQLite tracker and CLI tools.

Use Cases

• Automated Backup: Keep every version of your work automatically synced to Google Drive.
• Formula-Safe Updates: Update thousands of cells via bulk commands while ensuring that formulas referencing those cells remain valid and functional.
• Data Auditing: Use the built-in SQLite tracker to search for historical files or analyze trends across multiple spreadsheets.
• Formula Documentation: Use the CLI to quickly extract and review all formulas within a workbook.

Example Prompts

1. "Open the sales report and update the Q4 revenue cell to 500,000, making sure to keep the tax calculation formula working."
2. "Process my latest project-tracker.xlsx file, upload it to my Google Drive Excel folder, and index it in the tracker."
3. "Query my inventory.xlsx file to tell me which items have a formula calculating a discount."

Tips & Limitations

• Formula Integrity: While this skill is designed to preserve formulas, always verify complex circular references if you are performing bulk updates.
• File Paths: Ensure your local file paths are accessible to the OpenClaw agent for smooth background processing.
• Drive Sync: The rclone sync process is asynchronous; allow a few seconds for the file to appear in your Google Drive after processing.