{"id":"69688246-9fa4-4f35-bb76-63aa01de2ba8","shortId":"9QYmur","kind":"skill","title":"recipe-generate-report-from-sheet","tagline":"Read data from a Google Sheet and create a formatted Google Docs report.","description":"# Generate a Google Docs Report from Sheet Data\n\n> **PREREQUISITE:** Load the following skills to execute this recipe: `gws-sheets`, `gws-docs`, `gws-drive`\n\nRead data from a Google Sheet and create a formatted Google Docs report.\n\n## Steps\n\n1. Read the data: `gws sheets +read --spreadsheet SHEET_ID --range \"Sales!A1:D\"`\n2. Create the report doc: `gws docs documents create --json '{\"title\": \"Sales Report - January 2025\"}'`\n3. Write the report: `gws docs +write --document-id DOC_ID --text '## Sales Report - January 2025\n\n### Summary\nTotal deals: 45\nRevenue: $125,000\n\n### Top Deals\n1. Acme Corp - $25,000\n2. Widget Inc - $18,000'`\n4. Share with stakeholders: `gws drive permissions create --params '{\"fileId\": \"DOC_ID\"}' --json '{\"role\": \"reader\", \"type\": \"user\", \"emailAddress\": \"cfo@company.com\"}'`","tags":["recipe","generate","report","from","sheet","cli","googleworkspace","agent-skills","ai-agent","automation","discovery-api","gemini-cli-extension"],"capabilities":["skill","source-googleworkspace","skill-recipe-generate-report-from-sheet","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-generate-report-from-sheet","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 (805 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:34.208Z","embedding":null,"createdAt":"2026-04-18T20:25:13.631Z","updatedAt":"2026-05-18T18:52:34.208Z","lastSeenAt":"2026-05-18T18:52:34.208Z","tsv":"'000':112,119,124 '1':60,115 '125':111 '18':123 '2':74,120 '2025':88,105 '25':118 '3':89 '4':125 '45':109 'a1':72 'acm':116 'cfo@company.com':143 'corp':117 'creat':14,53,75,82,132 'd':73 'data':8,27,47,63 'deal':108,114 'doc':18,23,42,57,78,80,94,99,135 'document':81,97 'document-id':96 'drive':45,130 'emailaddress':142 'execut':34 'fileid':134 'follow':31 'format':16,55 'generat':3,20 'googl':11,17,22,50,56 'gws':38,41,44,64,79,93,129 'gws-doc':40 'gws-drive':43 'gws-sheet':37 'id':69,98,100,136 'inc':122 'januari':87,104 'json':83,137 'load':29 'param':133 'permiss':131 'prerequisit':28 'rang':70 'read':7,46,61,66 'reader':139 'recip':2,36 'recipe-generate-report-from-sheet':1 'report':4,19,24,58,77,86,92,103 'revenu':110 'role':138 'sale':71,85,102 'share':126 'sheet':6,12,26,39,51,65,68 'skill':32 'skill-recipe-generate-report-from-sheet' 'source-googleworkspace' 'spreadsheet':67 'stakehold':128 'step':59 'summari':106 'text':101 'titl':84 'top':113 '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' 'total':107 'type':140 'user':141 'widget':121 'write':90,95","prices":[{"id":"b267c397-88fb-4914-a5b7-5fa9da0c0b53","listingId":"69688246-9fa4-4f35-bb76-63aa01de2ba8","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:13.631Z"}],"sources":[{"listingId":"69688246-9fa4-4f35-bb76-63aa01de2ba8","source":"github","sourceId":"googleworkspace/cli/recipe-generate-report-from-sheet","sourceUrl":"https://github.com/googleworkspace/cli/tree/main/skills/recipe-generate-report-from-sheet","isPrimary":false,"firstSeenAt":"2026-04-18T21:52:35.606Z","lastSeenAt":"2026-05-18T18:52:34.208Z"},{"listingId":"69688246-9fa4-4f35-bb76-63aa01de2ba8","source":"skills_sh","sourceId":"googleworkspace/cli/recipe-generate-report-from-sheet","sourceUrl":"https://skills.sh/googleworkspace/cli/recipe-generate-report-from-sheet","isPrimary":true,"firstSeenAt":"2026-04-18T20:25:13.631Z","lastSeenAt":"2026-05-07T22:40:15.718Z"}],"details":{"listingId":"69688246-9fa4-4f35-bb76-63aa01de2ba8","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"googleworkspace","slug":"recipe-generate-report-from-sheet","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":"62bd1ed5ac8f51e63504ba4cdb8f60fc59c40546","skill_md_path":"skills/recipe-generate-report-from-sheet/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/googleworkspace/cli/tree/main/skills/recipe-generate-report-from-sheet"},"layout":"multi","source":"github","category":"cli","frontmatter":{"name":"recipe-generate-report-from-sheet","description":"Read data from a Google Sheet and create a formatted Google Docs report."},"skills_sh_url":"https://skills.sh/googleworkspace/cli/recipe-generate-report-from-sheet"},"updatedAt":"2026-05-18T18:52:34.208Z"}}