Recipe Backup Sheet As Csv
Export a live Google Sheet to CSV on disk for backups, ETL, or offline analysis without leaving the agent.
Overview
recipe-backup-sheet-as-csv is an agent skill for the Operate phase that exports a Google Sheets spreadsheet to a local CSV file via the gws CLI after loading gws-sheets and gws-drive.
Install
npx skills add https://github.com/googleworkspace/cli --skill recipe-backup-sheet-as-csvWhat is this skill?
- 3-step recipe: spreadsheet metadata, Drive export as text/csv, or Sheets +read with --format csv
- Hard prerequisite chain: load gws-sheets and gws-drive before any gws calls
- Uses gws CLI with spreadsheetId/fileId params for export and range reads
- Supports Sheet1 (or named ranges) for direct CSV materialization without Drive export
- OpenClaw recipe domain productivity at metadata version 0.22.5
- 2 prerequisite skills (gws-sheets, gws-drive)
Adoption & trust: 16.1k installs on skills.sh; 26.9k GitHub stars; 3/3 security scanners passed (skills.sh audits).
What problem does it solve?
You keep critical data in Google Sheets but lack a documented, agent-runnable way to pull an authoritative CSV backup on demand.
Who is it for?
Solo builders who already use gws for Google Workspace and want a copy-paste-safe backup recipe their agent can run before ETL or disaster recovery.
Skip if: Teams without gws installed, OAuth configured, or the gws-sheets/gws-drive skills loaded—skip until those prerequisites exist.
When should I use this skill?
Export a Google Sheets spreadsheet as a CSV file for local backup or processing.
What do I get? / Deliverables
After the recipe completes, you have CSV output from either Drive export or a direct range read, with the correct prerequisite skills loaded so exports do not fail mid-flow.
- Local CSV file or stdout CSV from sheets +read
- Confirmed spreadsheet metadata from spreadsheets get
Recommended Skills
Journey fit
Canonical shelf is Operate because scheduled or on-demand spreadsheet exports are production hygiene—backup, audit trails, and data handoff—not ideation or launch work. Infra fits file export, local artifacts, and integration glue that keeps workspace data durable outside Google’s cloud.
How it compares
Use this recipe-style skill instead of ad-hoc curl or browser export steps that omit Drive versus Sheets API differences.
Common Questions / FAQ
Who is recipe-backup-sheet-as-csv for?
Indie builders and small teams automating Google Workspace with the gws CLI who need repeatable Sheet-to-CSV exports for backups or downstream processing.
When should I use recipe-backup-sheet-as-csv?
Use it in Operate when you need infra-style data dumps; also during Build integrations when piping Sheet data into a local script, and during Grow analytics prep when freezing a tab as CSV for analysis.
Is recipe-backup-sheet-as-csv safe to install?
It invokes read/export Google APIs through gws after auth; review the Security Audits panel on this Prism page and scope OAuth tokens before granting filesystem write paths for CSV output.
Workflow Chain
Requires first: gws sheets, gws drive
SKILL.md
READMESKILL.md - Recipe Backup Sheet As Csv
# Export a Google Sheet as CSV > **PREREQUISITE:** Load the following skills to execute this recipe: `gws-sheets`, `gws-drive` Export a Google Sheets spreadsheet as a CSV file for local backup or processing. ## Steps 1. Get spreadsheet details: `gws sheets spreadsheets get --params '{"spreadsheetId": "SHEET_ID"}'` 2. Export as CSV: `gws drive files export --params '{"fileId": "SHEET_ID", "mimeType": "text/csv"}'` 3. Or read values directly: `gws sheets +read --spreadsheet SHEET_ID --range 'Sheet1' --format csv`