Recipe Generate Report From Sheet

by googleworkspacea3768d0e82adNo licenseListed Oct 8, 2026Updated Oct 8, 2026

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

AI-generated overview

Reads data from a Google Sheet and produces a formatted Google Docs report, then shares it with stakeholders.

What it does: This recipe walks through reading a range of data from a Google Sheet, creating a new Google Docs document, writing a formatted report into it, and granting read access to a specified person. It produces a shareable Google Docs report built from spreadsheet data. The steps are given as command-line invocations of the gws tool.
When to use it: Use it when you need to turn spreadsheet figures into a formatted document report for others to read. It suits recurring reporting tasks where the source data lives in Google Sheets and the output should be a Google Doc.
Requirements: Requires the gws command-line tool and the gws-sheets, gws-docs and gws-drive skills. It needs access to Google Sheets, Google Docs and Google Drive, including a spreadsheet ID, document ID and the email address of the person to share with. No scripts ship with the skill; it is instructions only.

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.

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

Total deals: 45 Revenue: $125,000

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]"}'

License: No license

Content belongs to its original authors. SourceWeft indexes it from a public repository.