# Recipe Generate Report From Sheet

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

Source: https://skillsagentes.com/skills/googleworkspace/cli/recipe-generate-report-from-sheet
Repository: https://github.com/googleworkspace/cli
Author: googleworkspace
License: Apache-2.0
Updated: hace 4 meses
Context cost: 18 tok installed, 287 tok once triggered, 287 tok with every bundled file
Bundle: 1 file, 1 KB
Permissions requested: none declared

## Install

```bash
npx -y skills add googleworkspace/cli --skill recipe-generate-report-from-sheet --agent claude-code
```

## What it does

- Lee datos de un rango en Google Sheets
- Crea un nuevo documento en Google Docs con un título dado
- Escribe el contenido del informe formateado en el documento
- Comparte el documento con permisos de lectura para un usuario específico

## Use it when

- Se necesita generar un informe en Google Docs a partir de datos almacenados en una hoja de cálculo de Google Sheets

## What triggers it

- "Genera un informe en Google Docs con los datos de ventas de esta hoja de cálculo"
- "Crea un reporte de Google Docs a partir del rango Sales!A1:D y compártelo con el CFO"

## Before you install

- Requiere el binario gws y las skills gws-sheets, gws-docs y gws-drive cargadas.

## Files

- SKILL.md — 1 KB

## SKILL.md

Reproduced verbatim from googleworkspace/cli under Apache-2.0. This section is the upstream document and is in English.

# 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

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

### Summary
Total deals: 45
Revenue: $125,000

### Top Deals
1. Acme Corp - $25,000
2. Widget Inc - $18,000'`
4. Share with stakeholders: `gws drive permissions create --params '{"fileId": "DOC_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "cfo@company.com"}'`

---

Skills Agentes — https://skillsagentes.com/skills/googleworkspace/cli/recipe-generate-report-from-sheet