skilld
All skills
googleworkspace avatar

/recipe-create-expense-tracker

@705fb0e
by Google Workspacegoogleworkspace/cli31k stars
1,856

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

Ask your Agent

Use this Skill: https://skilld.dev/gh/googleworkspace/cli/recipe-create-expense-tracker

This session only. Nothing lands on disk.

SKILL.md

≈30 tokens always: the name and description. ≈209 when used: this file.

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": "manager@company.com"}'

Source: SKILL.md on GitHub

Third-party checks

1 warning16d5 checks · Risk SAFE
  • Gen Agent Trust Hub16d

    The skill is safe. It provides standard procedural steps for setting up an expense tracker spreadsheet using Google Workspace tools without any security risks.

  • Socket16d

    No alerts

  • Snyk16d

    Risk: LOW · No issues

  • Runlayer6mo

    1/1 file flagged

  • ZeroLeaks5mo

    Score: 93/100 · 2 sections analyzed

Provenance

Signed by skilld at 705fb0e. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 2 months ago.

Activeupdated 6 months ago

Capability

Other metadata
metadata
{
  "version": "0.22.5",
  "openclaw": {
    "category": "recipe",
    "domain": "productivity",
    "requires": {
      "bins": [
        "gws"
      ],
      "skills": [
        "gws-sheets",
        "gws-drive"
      ]
    }
  }
}

Topics

  • google-workspace
  • sheets
  • expense-tracking
  • spreadsheet
  • gws
  • drive
  • recipe

README badge

README badge for googleworkspace/cli/recipe-create-expense-tracker

What it does

Sets up a Google Sheets spreadsheet with headers and sample expense entries using the gws CLI. The recipe demonstrates Google Drive file creation, Sheets data append, and permission sharing workflows.

Generated from the current SKILL.md.

Frequently asked

What skills do I need to install first?
Load gws-sheets and gws-drive before running this recipe. The skill also requires the gws CLI binary.
Does this create a new spreadsheet or use an existing one?
It creates a new spreadsheet named 'Expense Tracker 2025' in Google Drive from scratch.
Can I modify the headers or initial data?
Yes. The recipe shows the exact gws commands used; you can edit the values array in each command to customize headers, categories, amounts, or dates before executing.
What permissions can I grant when sharing?
The recipe demonstrates sharing as 'reader' role with a specific user email, but the gws drive permissions command supports other roles and sharing types as needed.

Generated from the current SKILL.md. These answers refresh after source changes.