AutoGineer
Generated banner for Recipe Generate Report From Sheet
Generated logo for Recipe Generate Report From Sheet

Recipe Generate Report From Sheet

Google WorkspaceOfficialPublished by Google Workspace

  • Skill
  • Workflow
  • Automation and integrations
  • Apache-2.0
  • No issues found
Download ZIP

From the author

Read data from a Google Sheet and create a formatted Google Docs report.
— the description by Google Workspace

AutoGineer summary

Written by AutoGineer from the skill’s own files, not by the author

This workflow automates the process of generating business reports by pulling raw data from a Google Sheet and populating a new Google Doc. It streamlines reporting tasks by handling data retrieval, document creation, content insertion, and permission management in a single sequence.

What it does

  • Reads structured data from a specified Google Sheet range.
  • Creates a new Google Doc with a custom title.
  • Populates the document with formatted text and data summaries.
  • Configures sharing permissions for stakeholders via Google Drive.

When to use it

  • When you need to generate recurring status reports from spreadsheet data.
  • When you want to automate the distribution of reports to specific stakeholders.
  • When you need to transform raw tabular data into a readable document format.

Advantages

  • Reduces manual effort in data entry and document formatting.
  • Ensures consistent report structure across multiple iterations.
  • Integrates data retrieval and document sharing into one automated flow.

Usage examples

“Generate a sales report from the January spreadsheet.”
The agent reads the sales data, creates a new Google Doc titled Sales Report - January 2025, populates it with the summary and top deals, and shares it with the CFO.

Install

  1. Download the skill as a ZIP:

    https://mp-staging.autogineer.com/agent-skills/googleworkspace/recipe-generate-report-from-sheet/download

  2. Unzip it into the cross-client skills folder of your project:

    mkdir -p .agents/skills && unzip recipe-generate-report-from-sheet.zip -d .agents/skills

Documentation by Google Workspace

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'`

  3. Share with stakeholders: gws drive permissions create --params '{"fileId": "DOC_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "[email protected]"}'

Files

SKILL.md

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'`

  3. Share with stakeholders: gws drive permissions create --params '{"fileId": "DOC_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "[email protected]"}'

Requirements and compatibility

Works with: Claude Code, Claude apps, OpenAI Codex, GitHub Copilot, Cursor, Gemini CLI, Kiro, OpenCode, Goose, Amp, Roo Code, JetBrains Junie, Factory Droid, Devin (ex-Windsurf), Mistral Vibe, OpenHands, Letta

“Works with” means the tool reads the open Agent Skills format; a skill written for one tool may use features others lack.

Security

No issues found by our static scan· No issues found

A static scan is not a guarantee. Skills are third-party content: review a skill before you let an agent use it.

Attribution and licence

Published by
Google Workspace
Publisher
Google Workspace (Official)
Source
googleworkspace/cli · skills/recipe-generate-report-from-sheet · commit cd3697e
Licence
Apache License 2.0 (redistribution allowed)
  • LICENSE (added by AutoGineer from LICENSE)
  • ATTRIBUTION.md (written by AutoGineer)
Synced

AutoGineer is not affiliated with or endorsed by Google Workspace.

Download ZIP

The ZIP holds the skill’s files, its licence files and an ATTRIBUTION.md. Download recipe-generate-report-from-sheet.zip