recipe-create-expense-tracker
SolidSet up a Google Sheets spreadsheet for tracking expenses with headers and initial entries.
AI & Automation 26,720 stars
1406 forks Updated today Apache-2.0
Install
Quality Score: 94/100
Stars 20%
Recency 20%
Frontmatter 20%
Documentation 15%
Issue Health 10%
License 10%
Description 5%
Skill Content
# 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"}'`
Details
- Author
- googleworkspace
- Repository
- googleworkspace/cli
- Created
- 3 months ago
- Last Updated
- today
- Language
- Rust
- License
- Apache-2.0
Integrates with
Similar Skills
Semantically similar based on skill content — not just same category
AI & Automation Solid
recipe-create-events-from-sheet
Read event data from a Google Sheets spreadsheet and create Google Calendar entries for each row.
26,720 Updated today
googleworkspace AI & Automation Solid
recipe-copy-sheet-for-new-month
Duplicate a Google Sheets template tab for a new month of tracking.
26,720 Updated today
googleworkspace AI & Automation Solid
recipe-sync-contacts-to-sheet
Export Google Contacts directory to a Google Sheets spreadsheet.
26,720 Updated today
googleworkspace AI & Automation Solid
recipe-create-task-list
Set up a new Google Tasks list with initial tasks.
26,720 Updated today
googleworkspace Data & Documents Solid
recipe-generate-report-from-sheet
Read data from a Google Sheet and create a formatted Google Docs report.
26,720 Updated today
googleworkspace