Create a Google Sheets Expense Tracker

SkillFiles & storage

Sets up a Google Sheets spreadsheet with headers and starter rows for tracking your expenses.

Available today. Use it from your connected AI after setup.

No other account needed.

Connect ahel once, and every AI you use reads what you have installed.

Then ask your AI: use the Create a Google Sheets Expense Tracker skill

About this capability

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

What this skill tells your AI

The instructions your AI receives, as published by googleworkspace/cli in skills/recipe-create-expense-tracker/SKILL.md and read by ahel’s review.

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.

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

Advanced