Skip to main content
skill Claude Code CX Codex Cursor GitHub Copilot official · Google

recipe-backup-sheet-as-csv — Claude skill: export Google Sheets to CSV

This skill exports a Google Sheets spreadsheet as a CSV file for local backup or processing. Useful when you need the data on your own disk.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add googleworkspace/cli --skill recipe-backup-sheet-as-csv -a claude-code
Open on GitHub

What recipe-backup-sheet-as-csv does

The skill walks through three ways to pull data out of a sheet using the gws CLI. First it fetches spreadsheet details with gws sheets spreadsheets get. Then it exports the file as CSV via gws drive files export with mimeType: text/csv. The third option reads values directly: gws sheets +read with --spreadsheet, --range and --format csv.

Two other skills must be loaded first — gws-sheets and gws-drive. The gws binary has to be on your system. Without it none of the commands run, so check that before you start.

Worth installing if you back up sheets on a schedule or feed the data into scripts. For a one-off download, just grab the CSV from the Google Sheets UI.

What it helps with

  • export a Google Sheets spreadsheet to a CSV file
  • back up sheet data to a local file
  • read sheet values in CSV format
  • pull sheet data for a script to process

Example prompts for the agent

  • Export spreadsheet SHEET_ID to CSV with gws
  • Back up Sheet1 from this spreadsheet as CSV
  • Read range Sheet1 and return it as csv

How to install recipe-backup-sheet-as-csv

1Skills CLI (Vercel)

npx skills add googleworkspace/cli --skill recipe-backup-sheet-as-csv -a claude-code

2Manually: put the files in place

~/.claude/skills/recipe-backup-sheet-as-csv/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/recipe-backup-sheet-as-csv/

From the same set95

The whole set →
gws-gmail official googleworkspace This skill hands your agent Gmail: send mail, read the inbox, reply in a thread. Useful when email work already runs through the gws CLI. Claude Code CX Codex Cursor +1 81,900installs gws-gmail-send official googleworkspace A skill that teaches your agent to send Gmail from the terminal: recipients, subject, body, attachments and drafts. Claude Code CX Codex Cursor +1 74,700installs gws-drive official googleworkspace This skill hands your agent Google Drive through the gws CLI: files, folders, shared drives, comments and access requests. Useful when docs move through code. Claude Code CX Codex Cursor +1 74,500installs gws-shared official googleworkspace This skill gives agents shared rules for gws CLI authentication, flags, and output formats. Use it when working with gws commands. Claude Code CX Codex Cursor +1 66,000installs gws-calendar official googleworkspace Manage Google Calendar events, access rules, and schedules through the gws CLI tool. Claude Code CX Codex Cursor +1 61,100installs gws-sheets official googleworkspace This skill lets an agent read and edit Google Sheets through the CLI. Use it when a coding workflow needs spreadsheet data or table updates. Claude Code CX Codex Cursor +1 58,800installs gws-docs official googleworkspace This skill lets an agent read and update Google Docs through gws. Use it when document changes should happen from an agent chat. Claude Code CX Codex Cursor +1 58,300installs gws-sheets-read official googleworkspace Reads cell values and sheets from Google Spreadsheets via CLI. Useful when an agent needs spreadsheet data without risk of altering it. Claude Code CX Codex Cursor +1 50,600installs

Similar

Questions about recipe-backup-sheet-as-csv

How do I install recipe-backup-sheet-as-csv in Claude?

Run npx skills add googleworkspace/cli --skill recipe-backup-sheet-as-csv -a claude-code. The skill lands in ~/.claude/skills/recipe-backup-sheet-as-csv/SKILL.md.

What does recipe-backup-sheet-as-csv do?

It exports a Google Sheets spreadsheet as a CSV file. You can fetch spreadsheet details, export the whole file, or read a specific range.

What do I need for this skill to work?

The gws binary on your system, plus the gws-sheets and gws-drive skills loaded. Without them the commands fail.

Source text

SKILL.md · Apache-2.0
---
name: recipe-backup-sheet-as-csv
description: "Export a Google Sheets spreadsheet as a CSV file for local backup or processing."
metadata:
  version: 0.22.5
  openclaw:
    category: "recipe"
    domain: "productivity"
    requires:
      bins:
        - gws
      skills:
        - gws-sheets
        - gws-drive
---

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

© googleworkspace · Apache-2.0 · googleworkspace/cli

See also

Project sponsors

Companies that keep this analytics open
Gold sponsor

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor