Leave Schedule Reader

Extract employee leave and duty schedules from Google Sheets documents.

Updated Mar 7, 2026
One-click install
npx skills add https://github.com/bibo1243/claw_memory --skill leave-schedule-reader
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Leave Schedule Reader
Source: https://github.com/bibo1243/claw_memory/tree/main/skills/leave_schedule_reader
Command: npx skills add https://github.com/bibo1243/claw_memory --skill leave-schedule-reader

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The Leave Schedule Reader reads the Foundation's leave schedule stored in Google Sheets to enable quick lookup of colleagues' leave and duty arrangements.

Core Features & Use Cases

  • Reads the sheet structure and naming rules, enabling consistent interpretation across months.
  • Maps each employee to their corresponding row and symbol codes to determine leave status and duty assignments.
  • Use cases include planning coverage, roster auditing, and answering questions like who is on leave or who has a specific duty on a given date.

Quick Start

Query the current month's schedule in the Google Sheet to list who is on leave and who is on duty.

Frequently Asked Questions about Leave Schedule Reader

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query a Google Sheets leave schedule to see who is on duty?

To query a Google Sheets leave schedule, this Skill reads the spreadsheet structure and maps employee rows with symbol codes to determine leave status and duty assignments for any given date. You can then list who is on duty or on leave without manual re-entry.

What is the best way to automate employee shift planning and roster inquiries?

Automating employee shift planning and roster inquiries is achieved by parsing the Google Sheets document structure and mapping rows and symbols to duty assignments. This enables automated querying across teams for monthly planning and shift coverage decisions.

Can I use this to extract leave status and duty assignments for monthly planning?

Yes, you can extract leave status and duty assignments for monthly planning. The Skill identifies and extracts employee schedules from the Google Sheets document, applying consistent interpretation of naming rules and symbol codes across different months.

Does this approach work with Google Sheets documents containing custom symbol codes for leave schedules?

Yes, it works with Google Sheets documents containing custom symbol codes. The Skill maps each employee to their corresponding row and interprets the specific symbol codes to determine leave status and duty assignments accurately.

How do I handle shift coverage decisions when querying a roster from a spreadsheet?

To handle shift coverage decisions from a spreadsheet, the Skill extracts employee leave and duty schedules by mapping rows and symbols to assignments. This enables quick lookup of colleagues' arrangements to identify available personnel for coverage.