Recipe Create Expense Tracker

Creates a basic expense tracking spreadsheet in Google Drive with proper headers (Date, Category, Description, Amount) and includes a sample entry to get you started. Handles the tedious setup steps of creating the sheet, formatting columns, and setting initial permissions. Most useful when you need a quick personal or team expense tracker without the overhead of dedicated expense software. The recipe keeps it simple with just the essentials, though you'll likely want to add formulas for totals and maybe some basic formatting once it's running.

installs: 30K
GitHub stars: 31.9K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add googleworkspace/cli --skill recipe-create-expense-tracker --agent claude-code

Installs into .claude/skills of the current project.

Files

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"}'

SKILL.md on GitHub