recipe-create-expense-tracker

$npx mdskill add googleworkspace/cli/recipe-create-expense-tracker

Create a Google Sheets expense tracker with headers and entries.

  • Set up a spreadsheet for tracking expenses automatically.
  • Depends on gws-sheets and gws-drive skills.
  • Uses predefined steps to create, populate, and share the sheet.
  • Returns a shared Google Sheet with headers and sample data.

SKILL.md

.github/skills/recipe-create-expense-trackerView on GitHub ↗
---
name: recipe-create-expense-tracker
description: "Set up a Google Sheets spreadsheet for tracking expenses with headers and initial entries."
metadata:
  version: 0.22.5
  openclaw:
    category: "recipe"
    domain: "productivity"
    requires:
      bins:
        - gws
      skills:
        - gws-sheets
        - gws-drive
---

# Create a Google Sheets Expense Tracker

> **PREREQUISITE:** Load the following skills to execute this recipe: `gws-sheets`, `gws-drive`

Set up a Google Sheets spreadsheet for tracking expenses with headers and initial entries.

## Steps

1. Create spreadsheet: `gws drive files create --json '{"name": "Expense Tracker 2025", "mimeType": "application/vnd.google-apps.spreadsheet"}'`
2. Add headers: `gws sheets +append --spreadsheet SHEET_ID --range 'Sheet1' --values '["Date", "Category", "Description", "Amount"]'`
3. Add first entry: `gws sheets +append --spreadsheet SHEET_ID --range 'Sheet1' --values '["2025-01-15", "Travel", "Flight to NYC", "450.00"]'`
4. Share with manager: `gws drive permissions create --params '{"fileId": "SHEET_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "[email protected]"}'`

More from googleworkspace/cli

SkillDescription
gws-admin-reportsGoogle Workspace Admin SDK: Audit logs and usage reports.
gws-calendarGoogle Calendar: Manage calendars and events.
gws-calendar-agendaGoogle Calendar: Show upcoming events across all calendars.
gws-calendar-insertGoogle Calendar: Create a new event.
gws-chatGoogle Chat: Manage Chat spaces and messages.
gws-chat-sendGoogle Chat: Send a message to a space.
gws-classroomGoogle Classroom: Manage classes, rosters, and coursework.
gws-docsRead and write Google Docs.
gws-docs-writeGoogle Docs: Append text to a document.
gws-driveGoogle Drive: Manage files, folders, and shared drives.