{"id":"83cff5b8-5114-4d13-966b-662cd753c5b9","shortId":"8PXCqC","kind":"skill","title":"recipe-create-expense-tracker","tagline":"Set up a Google Sheets spreadsheet for tracking expenses with headers and initial entries.","description":"# Create a Google Sheets Expense Tracker\n\n> **PREREQUISITE:** Load the following skills to execute this recipe: `gws-sheets`, `gws-drive`\n\nSet up a Google Sheets spreadsheet for tracking expenses with headers and initial entries.\n\n## Steps\n\n1. Create spreadsheet: `gws drive files create --json '{\"name\": \"Expense Tracker 2025\", \"mimeType\": \"application/vnd.google-apps.spreadsheet\"}'`\n2. Add headers: `gws sheets +append --spreadsheet SHEET_ID --range 'Sheet1' --values '[\"Date\", \"Category\", \"Description\", \"Amount\"]'`\n3. Add first entry: `gws sheets +append --spreadsheet SHEET_ID --range 'Sheet1' --values '[\"2025-01-15\", \"Travel\", \"Flight to NYC\", \"450.00\"]'`\n4. Share with manager: `gws drive permissions create --params '{\"fileId\": \"SHEET_ID\"}' --json '{\"role\": \"reader\", \"type\": \"user\", \"emailAddress\": \"manager@company.com\"}'`","tags":["recipe","create","expense","tracker","cli","googleworkspace","agent-skills","ai-agent","automation","discovery-api","gemini-cli-extension","google-admin"],"capabilities":["skill","source-googleworkspace","skill-recipe-create-expense-tracker","topic-agent-skills","topic-ai-agent","topic-automation","topic-cli","topic-discovery-api","topic-gemini-cli-extension","topic-google-admin","topic-google-api","topic-google-calendar","topic-google-chat","topic-google-docs","topic-google-drive"],"categories":["cli"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/googleworkspace/cli/recipe-create-expense-tracker","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add googleworkspace/cli","source_repo":"https://github.com/googleworkspace/cli","install_from":"skills.sh"}},"qualityScore":"0.700","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 26371 github stars · SKILL.md body (834 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T18:52:33.266Z","embedding":null,"createdAt":"2026-04-18T20:25:23.322Z","updatedAt":"2026-05-18T18:52:33.266Z","lastSeenAt":"2026-05-18T18:52:33.266Z","tsv":"'-01':100 '-15':101 '1':56 '2':70 '2025':67,99 '3':86 '4':107 '450.00':106 'add':71,87 'amount':85 'append':75,92 'application/vnd.google-apps.spreadsheet':69 'categori':83 'creat':3,20,57,62,114 'date':82 'descript':84 'drive':40,60,112 'emailaddress':124 'entri':19,54,89 'execut':32 'expens':4,14,24,49,65 'file':61 'fileid':116 'first':88 'flight':103 'follow':29 'googl':9,22,44 'gws':36,39,59,73,90,111 'gws-drive':38 'gws-sheet':35 'header':16,51,72 'id':78,95,118 'initi':18,53 'json':63,119 'load':27 'manag':110 'manager@company.com':125 'mimetyp':68 'name':64 'nyc':105 'param':115 'permiss':113 'prerequisit':26 'rang':79,96 'reader':121 'recip':2,34 'recipe-create-expense-track':1 'role':120 'set':6,41 'share':108 'sheet':10,23,37,45,74,77,91,94,117 'sheet1':80,97 'skill':30 'skill-recipe-create-expense-tracker' 'source-googleworkspace' 'spreadsheet':11,46,58,76,93 'step':55 'topic-agent-skills' 'topic-ai-agent' 'topic-automation' 'topic-cli' 'topic-discovery-api' 'topic-gemini-cli-extension' 'topic-google-admin' 'topic-google-api' 'topic-google-calendar' 'topic-google-chat' 'topic-google-docs' 'topic-google-drive' 'track':13,48 'tracker':5,25,66 'travel':102 'type':122 'user':123 'valu':81,98","prices":[{"id":"419bd2c2-5bb2-4a5f-8010-c6d12d643637","listingId":"83cff5b8-5114-4d13-966b-662cd753c5b9","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"googleworkspace","category":"cli","install_from":"skills.sh"},"createdAt":"2026-04-18T20:25:23.322Z"}],"sources":[{"listingId":"83cff5b8-5114-4d13-966b-662cd753c5b9","source":"github","sourceId":"googleworkspace/cli/recipe-create-expense-tracker","sourceUrl":"https://github.com/googleworkspace/cli/tree/main/skills/recipe-create-expense-tracker","isPrimary":false,"firstSeenAt":"2026-04-18T21:52:26.784Z","lastSeenAt":"2026-05-18T18:52:33.266Z"},{"listingId":"83cff5b8-5114-4d13-966b-662cd753c5b9","source":"skills_sh","sourceId":"googleworkspace/cli/recipe-create-expense-tracker","sourceUrl":"https://skills.sh/googleworkspace/cli/recipe-create-expense-tracker","isPrimary":true,"firstSeenAt":"2026-04-18T20:25:23.322Z","lastSeenAt":"2026-05-07T22:40:15.970Z"}],"details":{"listingId":"83cff5b8-5114-4d13-966b-662cd753c5b9","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"googleworkspace","slug":"recipe-create-expense-tracker","github":{"repo":"googleworkspace/cli","stars":26371,"topics":["agent-skills","ai-agent","automation","cli","discovery-api","gemini-cli-extension","google-admin","google-api","google-calendar","google-chat","google-docs","google-drive","google-sheets","google-workspace","oauth2","rust"],"license":"apache-2.0","html_url":"https://github.com/googleworkspace/cli","pushed_at":"2026-05-12T16:46:11Z","description":"Google Workspace CLI — one command-line tool for Drive, Gmail, Calendar, Sheets, Docs, Chat, Admin, and more. Dynamically built from Google Discovery Service. Includes AI agent skills.","skill_md_sha":"86edb3c7b34025e949a11eddd8b55525f2199a05","skill_md_path":"skills/recipe-create-expense-tracker/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/googleworkspace/cli/tree/main/skills/recipe-create-expense-tracker"},"layout":"multi","source":"github","category":"cli","frontmatter":{"name":"recipe-create-expense-tracker","description":"Set up a Google Sheets spreadsheet for tracking expenses with headers and initial entries."},"skills_sh_url":"https://skills.sh/googleworkspace/cli/recipe-create-expense-tracker"},"updatedAt":"2026-05-18T18:52:33.266Z"}}