recipe-create-expense-tracker

googleworkspace/cli

Set up a Google Sheets expense tracker with headers and sample entries in minutes.

What is recipe-create-expense-tracker?

This recipe automates creation of a Google Sheets spreadsheet pre-configured for expense tracking. Use it to quickly establish a shared expense log with standard columns (Date, Category, Description, Amount) and an initial sample entry.

Creates a new Google Sheets spreadsheet named 'Expense Tracker 2025'
Adds column headers: Date, Category, Description, Amount
Populates a sample expense entry for reference
Shares the spreadsheet with a specified manager or team member

How to install recipe-create-expense-tracker

npx skills add null --skill recipe-create-expense-tracker

Prerequisites

Google Workspace account with Sheets and Drive access
gws-sheets skill installed
gws-drive skill installed
gws CLI tool available

Claude Code

Cursor

Windsurf

Cline

How to use recipe-create-expense-tracker

1.Run the drive create command to generate a new spreadsheet named 'Expense Tracker 2025'
2.Replace SHEET_ID in subsequent commands with the ID returned from the create step
3.Execute the append command to add column headers (Date, Category, Description, Amount)
4.Execute the second append command to add a sample expense entry
5.Run the permissions command to share the spreadsheet with your manager's email address

Use cases

Good for

Set up personal expense tracking for reimbursement submissions
Create a team expense log for project cost monitoring
Initialize a shared budget tracker for departmental spending
Establish a travel expense sheet for business trips
Generate a template for recurring expense reporting

Who it's for

Finance administrators
Project managers
Employees managing business expenses
Team leads tracking departmental budgets
Anyone needing quick expense documentation

recipe-create-expense-tracker FAQ

What if I want different column headers?

Modify the values array in step 2 to include your preferred headers instead of the default Date, Category, Description, Amount.

Can I share with multiple people?

Yes, run the permissions create command multiple times with different emailAddress values for each person you want to grant access.

How do I find the SHEET_ID?

The SHEET_ID is returned in the output of the drive files create command in step 1.

Can I customize the sample entry?

Yes, modify the values in step 3 to use your own date, category, description, and amount before running the command.

Full instructions (SKILL.md)

Source of truth, from googleworkspace/cli.

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

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