Skill

Pass

Audit score 90

recipe-backup-sheet-as-csv

googleworkspace/cli

Export Google Sheets to CSV for backup and local processing.

What is recipe-backup-sheet-as-csv?

This recipe exports a Google Sheets spreadsheet as a CSV file for local backup or data processing. Use it when you need to download sheet data offline or integrate it with other tools.

Export entire spreadsheets to CSV format
Retrieve spreadsheet metadata before export
Read sheet values directly in CSV format
Enable local backup of Google Sheets data
Support integration with external data processing tools

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

npx skills add null --skill recipe-backup-sheet-as-csv

Prerequisites

gws-sheets skill installed
gws-drive skill installed
gws CLI tool available
Valid Google Sheets spreadsheet ID

Claude Code

Cursor

Windsurf

Cline

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

1.Identify the spreadsheet ID of the sheet you want to export
2.Run `gws sheets spreadsheets get --params '{"spreadsheetId": "SHEET_ID"}'` to retrieve spreadsheet details
3.Export as CSV using `gws drive files export --params '{"fileId": "SHEET_ID", "mimeType": "text/csv"}'`
4.Alternatively, read values directly with `gws sheets +read --spreadsheet SHEET_ID --range 'Sheet1' --format csv`
5.Save or process the CSV output as needed

Use cases

Good for

Back up important Google Sheets data locally
Export sheet data for use in Excel or other applications
Prepare sheet data for import into databases or analytics tools
Create offline copies of collaborative spreadsheets
Extract data from sheets for custom processing pipelines

Who it's for

Data analysts
Productivity teams using Google Workspace
Developers integrating Google Sheets with other systems
Anyone needing regular backups of sheet data

recipe-backup-sheet-as-csv FAQ

What are the prerequisites for this recipe?

You need the gws-sheets and gws-drive skills installed, plus the gws CLI tool available.

How do I find my spreadsheet ID?

The spreadsheet ID is in the URL of your Google Sheet: `https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit`

Can I export specific sheets or ranges?

Yes, you can specify the range parameter (e.g., 'Sheet1' or 'Sheet1!A1:C10') when using the read method.

What format options are available?

The recipe supports CSV export via the drive API or direct CSV format reading via the sheets API.

Full instructions (SKILL.md)

Source of truth, from googleworkspace/cli.

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

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

Related skills

More from googleworkspace/cli and the wider catalog.

gws-gmail

googleworkspace/cli

Send, read, and manage Gmail emails via Google Workspace CLI.

40k installs

gws-drive

googleworkspace/cli

Manage Google Drive files, folders, and shared drives via CLI.

37k installs

gws-docs

googleworkspace/cli

Read and write Google Docs via command line.

37k installs

gws-calendar

googleworkspace/cli

Manage Google Calendar events, calendars, and access control via CLI.

36k installsAudited

gws-sheets

googleworkspace/cli

Read and write Google Sheets spreadsheets via CLI.

35k installs

gws-gmail-send

googleworkspace/cli

Send emails via Gmail with attachments, CC/BCC, HTML support, and draft options.

31k installsAudited