recipe-backup-sheet-as-csv

$npx mdskill add googleworkspace/cli/recipe-backup-sheet-as-csv

Export a Google Sheet as CSV for backup or processing.

  • Backup or process a Google Sheet locally as CSV.
  • Depends on gws-sheets and gws-drive skills.
  • Uses spreadsheet ID to fetch data or export file.
  • Returns CSV content via gws commands.

SKILL.md

.github/skills/recipe-backup-sheet-as-csvView on GitHub ↗
---
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`

More from googleworkspace/cli

SkillDescription
gws-admin-reportsGoogle Workspace Admin SDK: Audit logs and usage reports.
gws-calendarGoogle Calendar: Manage calendars and events.
gws-calendar-agendaGoogle Calendar: Show upcoming events across all calendars.
gws-calendar-insertGoogle Calendar: Create a new event.
gws-chatGoogle Chat: Manage Chat spaces and messages.
gws-chat-sendGoogle Chat: Send a message to a space.
gws-classroomGoogle Classroom: Manage classes, rosters, and coursework.
gws-docsRead and write Google Docs.
gws-docs-writeGoogle Docs: Append text to a document.
gws-driveGoogle Drive: Manage files, folders, and shared drives.