vacation-schedule

Query employee vacation schedules from Google Sheets by name and month.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

這個技能幫助團隊快速查詢基金會的假表,了解誰在休假、休假日期與當日排班狀態,避免人力衝突。

Core Features & Use Cases

  • 從 Google Sheets 的排班表中讀取資料並解讀各種符號(◎、〇、●、△、▽、▲、▼)對應的假別與排班狀態。
  • 支援以員工姓名查詢與月份區間查詢,並可跨分頁讀取動態欄位,顯示個人排班與衝突情況。
  • 使用情境:管理人員需要快速查看某位員工在特定月份的休假日,並評估是否需要調整排班以避免缺員。

Quick Start

直接執行指令以指定員工姓名與目標分頁,即可顯示該員工的假表。

Frequently Asked Questions about vacation-schedule

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

FAQPage Schema
How do I query an employee vacation schedule from Google Sheets?

To query a vacation schedule, use this Skill to read employee roster data from a Google Sheets-based roster and display individual schedules. It performs name-based lookups and monthly date range filtering across variable sheet columns.

How do I interpret schedule symbols in a Google Sheets vacation roster?

This Skill interprets schedule symbols like ◎, 〇, ●, △, ▽, ▲, and ▼ to reveal vacation types and shift statuses. It decodes these characters from your Google Sheets roster into a readable schedule showing who is off and potential conflicts.

Do I need Google Cloud OAuth to read vacation data from Google Sheets?

Yes, you need Google Cloud OAuth to generate an access token before querying the vacation schedule. This authentication flow is required to securely read sheet values across variable column counts from your Google Sheets roster.

Can I check for staffing conflicts when viewing a monthly vacation schedule?

Yes, viewing a monthly vacation schedule includes checking for potential staffing conflicts. The Skill queries individual employee schedules within a monthly date range and prints a human-readable schedule highlighting who is off and potential conflicts.

What's the best way to view individual employee time-off dates from a shared roster?

The best way to view individual employee time-off dates is by running a name-based lookup against your Google Sheets roster. This Skill reads dynamic sheet fields and prints a clear, human-readable schedule for the requested employee.

Why does the vacation schedule query not return data for the requested employee name?

A vacation schedule query may not return data if the requested employee name does not match the entries in the Google Sheets roster, or if the monthly date range and target sheet tab are incorrectly specified. Ensure the name matches the roster exactly.