recipe-backup-sheet-as-csv

Name: recipe-backup-sheet-as-csv
Author: 73ai

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

by 73ai(0) 0 installs

Free

Free account. Installing gives you the manifest plus copy-paste snippets.

See reviews

About

Imported from 73ai/openbotkit (skills/recipe-backup-sheet-as-csv/SKILL.md). Install upstream with npx skills add 73ai/openbotkit --skill recipe-backup-sheet-as-csv. Copyright stays with the author.

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

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml

targets:
  - https://api.opensmartroute.ai/api/v1/registry/73ai-openbotkit-recipe-backup-sheet-as-csv/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

73ai-openbotkit-recipe-backup-sheet-as-csv.ocm.jsonjson

{
  "ocm": "1",
  "id": "73ai-openbotkit-recipe-backup-sheet-as-csv",
  "kind": "skill",
  "name": "recipe-backup-sheet-as-csv",
  "description": "Export a Google Sheets spreadsheet as a CSV file for local backup or processing.",
  "publisher": "73ai",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "data_analysis"
    ],
    "tags": [
      "skill-md",
      "github"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Export a Google Sheets spreadsheet as a CSV file for local backup or processing."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "github",
      "repository": "https://github.com/73ai/openbotkit",
      "path": "skills/recipe-backup-sheet-as-csv/SKILL.md",
      "ref": "4599c85961cfc0ed721026a95e0ac4d5648aca4b",
      "url": "https://github.com/73ai/openbotkit/blob/4599c85961cfc0ed721026a95e0ac4d5648aca4b/skills/recipe-backup-sheet-as-csv/SKILL.md",
      "key": "73ai/openbotkit/skills/recipe-backup-sheet-as-csv/SKILL.md"
    }
  },
  "instructions": "# Export a Google Sheet as CSV\n\n> **PREREQUISITE:** Load the following skills to execute this recipe: `gws-sheets`, `gws-drive`\n\nExport a Google Sheets spreadsheet as a CSV file for local backup or processing.\n\n## Steps\n\n1. Get spreadsheet details: `gws sheets spreadsheets get --params '{\"spreadsheetId\": \"SHEET_ID\"}'`\n2. Export as CSV: `gws drive files export --params '{\"fileId\": \"SHEET_ID\", \"mimeType\": \"text/csv\"}'`\n3. Or read values directly: `gws sheets +read --spreadsheet SHEET_ID --range 'Sheet1' --format csv`",
  "cost": {
    "context_tokens": 130
  }
}

Fetch it by URL: GET /api/v1/registry/73ai-openbotkit-recipe-backup-sheet-as-csv/manifest?version=1.0.0

About

Export a Google Sheet as CSV

Steps

Use it

Manifest

Reviews