{"id":"69688246-9fa4-4f35-bb76-63aa01de2ba8","shortId":"9QYmur","kind":"skill","title":"Recipe Generate Report From Sheet","tagline":"Cli skill by Googleworkspace","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"],"capabilities":["skill","source-googleworkspace","category-cli"],"categories":["cli"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/googleworkspace/cli/recipe-generate-report-from-sheet","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"install_from":"skills.sh"}},"qualityScore":"0.300","qualityRationale":"deterministic score 0.30 from registry signals: · indexed on skills.sh · published under googleworkspace/cli","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:v1","enrichmentVersion":1,"enrichedAt":"2026-04-22T05:40:14.676Z","embedding":null,"createdAt":"2026-04-18T20:25:13.631Z","updatedAt":"2026-04-22T05:40:14.676Z","lastSeenAt":"2026-04-22T05:40:14.676Z","tsv":"'000':102,109,114 '1':50,105 '125':101 '18':113 '2':64,110 '2025':78,95 '25':108 '3':79 '4':115 '45':99 'a1':62 'acm':106 'category-cli' 'cfo@company.com':133 'cli':6 'corp':107 'creat':43,65,72,122 'd':63 'data':17,37,53 'deal':98,104 'doc':13,32,47,68,70,84,89,125 'document':71,87 'document-id':86 'drive':35,120 'emailaddress':132 'execut':24 'fileid':124 'follow':21 'format':45 'generat':2,10 'googl':12,40,46 'googleworkspac':9 'gws':28,31,34,54,69,83,119 'gws-doc':30 'gws-drive':33 'gws-sheet':27 'id':59,88,90,126 'inc':112 'januari':77,94 'json':73,127 'load':19 'param':123 'permiss':121 'prerequisit':18 'rang':60 'read':36,51,56 'reader':129 'recip':1,26 'report':3,14,48,67,76,82,93 'revenu':100 'role':128 'sale':61,75,92 'share':116 'sheet':5,16,29,41,55,58 'skill':7,22 'source-googleworkspace' 'spreadsheet':57 'stakehold':118 'step':49 'summari':96 'text':91 'titl':74 'top':103 'total':97 'type':130 'user':131 'widget':111 'write':80,85","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-04-22T00:52:25.388Z"},{"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-04-22T05:40:14.676Z"}],"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","source":"skills_sh","category":"cli","skills_sh_url":"https://skills.sh/googleworkspace/cli/recipe-generate-report-from-sheet"},"updatedAt":"2026-04-22T05:40:14.676Z"}}