Recipe Create Expense Tracker

by googleworkspacea3768d0e82adNo licenseListed Oct 8, 2026Updated Oct 8, 2026

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

AI-generated overview

Creates a Google Sheets expense tracker with headers, an initial entry, and manager sharing.

What it does: This recipe walks through setting up a Google Sheets spreadsheet for tracking expenses. It creates the spreadsheet, appends header columns for date, category, description, and amount, adds a first sample expense entry, and shares the file with a manager as a reader. It produces a ready-to-use expense tracking spreadsheet.
When to use it: Use this when you need a quick, structured expense tracking sheet in Google Sheets. It suits users who want headers and a starting entry already in place and who need to share the sheet with someone else.
Requirements: Requires the gws command-line tool plus the gws-sheets and gws-drive skills, and access to Google Drive and Google Sheets. It ships no scripts; it is instructions only.

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.

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": "[email protected]"}'

License: No license

Content belongs to its original authors. SourceWeft indexes it from a public repository.