mcpbeat

Recipe Generate Report From Sheet

googleworkspace/recipe-generate-report-from-sheet

Read data from a Google Sheet and create a formatted Google Docs report.

287 tokens
context cost
the whole folder, loaded on every use
1
files
instructions only
0
copies elsewhere
how many repositories repackaged it
30175
stars on the repo
on the repository, not the skill itself

Install

one command, takes just this skill from the repository
npx skills add https://github.com/googleworkspace/cli --skill recipe-generate-report-from-sheet

The instruction itself

4 sections, as written by the author

Generate a Google Docs Report from Sheet Data

> PREREQUISITE: Load the following skills to execute this recipe: gws-sheets, gws-docs, gws-drive

Read data from a Google Sheet and create a formatted Google Docs report.

Steps

  • Read the data: gws sheets +read --spreadsheet SHEET_ID --range "Sales!A1:D"
  • Create the report doc: gws docs documents create --json '{"title": "Sales Report - January 2025"}'
  • Write the report: `gws docs +write --document-id DOC_ID --text '## Sales Report - January 2025

Summary

Total deals: 45

Revenue: $125,000

Top Deals

  • Acme Corp - $25,000
  • Widget Inc - $18,000'`
  • Share with stakeholders: gws drive permissions create --params '{"fileId": "DOC_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "[email protected]"}'

How to use it

Copy the folder

Take googleworkspace/recipe-generate-report-from-sheet from the repository into ~/.claude/skills for personal use, or into .claude/skills inside a project.

Check the name does not clash

The agent identifies a skill by the name field in its header. Two skills with the same name cannot sit side by side — one of them will be ignored.