Back to Details

recipe-backup-sheet-as-csv

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Export a Google Sheet as CSV

将Google Sheet导出为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.
前提条件: 执行此方案需加载以下技能：
gws-sheets
, 
gws-drive
将Google Sheets电子表格导出为CSV文件，用于本地备份或处理。

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-id SHEET_ID --range 'Sheet1' --format csv
  1. 获取电子表格详情：
    gws sheets spreadsheets get --params '{"spreadsheetId": "SHEET_ID"}'
  2. 导出为CSV文件：
    gws drive files export --params '{"fileId": "SHEET_ID", "mimeType": "text/csv"}'
  3. 或直接读取数据：
    gws sheets +read --spreadsheet-id SHEET_ID --range 'Sheet1' --format csv