Recipe Backup Sheet As Csv

A straightforward recipe for getting your Google Sheets data out as CSV files. Shows three different approaches: using the Drive API export endpoint, getting spreadsheet metadata first, or reading values directly through the Sheets API. The direct read method with csv format is probably the cleanest for most use cases. Handy when you need local backups, want to process data with other tools, or just prefer working with CSV over the web interface. Requires the gws-sheets and gws-drive skills to handle the API calls.

skills.sh installs: 31.7K
GitHub stars: 32.2K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add googleworkspace/cli --skill recipe-backup-sheet-as-csv --agent claude-code

Installs into .claude/skills of the current project.

Files

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

Get spreadsheet details: gws sheets spreadsheets get --params '{"spreadsheetId": "SHEET_ID"}'
Export as CSV: gws drive files export --params '{"fileId": "SHEET_ID", "mimeType": "text/csv"}'
Or read values directly: gws sheets +read --spreadsheet SHEET_ID --range 'Sheet1' --format csv

SKILL.md on GitHub

Sponsors

Promote your product hereReach 125k+ visitors monthly Promote your product hereReach 125k+ visitors monthly