- name
- school-run
- description
- Manages the School Run Schedule Google Sheet. Use when reading or updating the school run drop-off schedule for Damian and Zachary (date, responsible person, marks).
School Run Sheet Management
This skill provides direct CLI access to the School Run Schedule Google Sheet: 1BCXLhckPWkpnTaRXPNF9j6c2ldWh5MeZ5KgVQVvOyt4.
Column Structure (MAR 2026 sheet)
- Column A: Date
- Column B: Who is responsible for dropping Damian and Zachary off at school
- Column C: Marks/Remarks
Usage Guidelines
- Always check current data before appending or updating.
- Use
gws sheets spreadsheets values getto inspect specific dates. - Use
gws sheets spreadsheets values updateto modify existing rows. - Dry-run first for any write operation.
Command Templates
Read Schedule for a Date (e.g., Row 11)
env GOOGLE_WORKSPACE_CLI_CREDENTIALS_FILE=/home/websterlinus615/.config/gws/service-account.json \
gws sheets spreadsheets values get \
--params '{"spreadsheetId": "1BCXLhckPWkpnTaRXPNF9j6c2ldWh5MeZ5KgVQVvOyt4", "range": "MAR 2026!A11:C11"}'Update Marks for a Date
env GOOGLE_WORKSPACE_CLI_CREDENTIALS_FILE=/home/websterlinus615/.config/gws/service-account.json \
gws sheets spreadsheets values update \
--params '{"spreadsheetId": "1BCXLhckPWkpnTaRXPNF9j6c2ldWh5MeZ5KgVQVvOyt4", "range": "MAR 2026!C11", "valueInputOption": "USER_ENTERED"}' \
--json '{"values": [["NEW_MARKS"]]}'Troubleshooting
- If API errors occur, verify
spreadsheetIdand sheet tab name ("MAR 2026"). - Ensure
service-account.jsonis accessible in~/.config/gws/.