recipe-backup-sheet-as-csv

SKILL.md

Export Google Sheets spreadsheets as CSV files for backup or local processing.

Requires gws-sheets and gws-drive skills as prerequisites

Offers three export approaches: retrieve spreadsheet metadata, export via Drive API with MIME type specification, or read sheet values directly in CSV format

Supports flexible range selection and sheet targeting for granular control over exported data

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