OpenSkillIndex← back to search
claude-codeproductivity

Cli recipe-backup-sheet-as-csv

Export a Google Sheets spreadsheet as a CSV file for local backup or processing.

install
source · Clone the upstream repo
git clone https://github.com/googleworkspace/cli
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/googleworkspace/cli "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/recipe-backup-sheet-as-csv" ~/.claude/skills/googleworkspace-cli-recipe-backup-sheet-as-csv && rm -rf "$T"
manifest: skills/recipe-backup-sheet-as-csv/SKILL.md
tags
#google-sheets#csv#data-export#automation#gws
source content

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