recipe-backup-sheet-as-csv
Export a Google Sheets spreadsheet as a CSV file for local backup or processing.
By googleworkspace · 28,389 installs
npx skills add googleworkspace/cli --skill recipe-backup-sheet-as-csv
Source repository · Upstream listing
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