Spreadsheets

Name: Spreadsheets
Author: tryshift-sh

tryshift-sh/skills-store

9 installs
Updated May 12, 2026
tryshift-sh/skills-store

Helps with ai & agent building tasks.

About

spreadsheets is a Claude Code skill for ai & agent building. It helps solo builders move faster with AI-assisted coding.

spreadsheets
AI & Agent Building
AI-coding skill

Spreadsheets by the numbers

9 all-time installs (skills.sh)
Ranked #12,152 of 16,546 AI & Agent Building skills by installs in the Skillselion catalog
Data as of Aug 5, 2026 (Skillselion catalog sync)

npx skills add https://github.com/tryshift-sh/skills-store --skill spreadsheets

Add your badge

Show developers this skill is listed on Skillselion. Paste this into your README.

[![Listed on Skillselion](https://skillselion.com/badge/skills/tryshift-sh/skills-store/spreadsheets.svg)](https://skillselion.com/skills/tryshift-sh/skills-store/spreadsheets)

Installs	9
Last updated	May 12, 2026
Repository	tryshift-sh/skills-store ↗

What it does

Helps with ai & agent building tasks.

Files

SKILL.mdMarkdownGitHub ↗

Google Sheets Spreadsheets

Use this skill to create a spreadsheet, inspect its structure, read a range, append rows, update cell values, or share a spreadsheet created through Shift.

When to use

create a new spreadsheet
inspect sheet names and spreadsheet metadata for a spreadsheet created through Shift
read values from a range
append rows to a range
update a fixed range with new values
share a spreadsheet with another person

Authentication

This skill uses the connected google-sheets provider credential for the current agent. It is intended for spreadsheets created through Shift.

Invocation

Call through Shift's Skill Router:

curl -X POST "$SHIFT_LOCAL_GATEWAY/skill-router/invoke" \
  -H "Content-Type: application/json" \
  -d '{
    "skillProvider": "google-sheets",
    "skill": "spreadsheets",
    "action": "read-range",
    "input": {
      "spreadsheetId": "SPREADSHEET_ID",
      "range": "Sheet1!A1:C10"
    }
  }'

Examples

Create a spreadsheet:

{
  "skillProvider": "google-sheets",
  "skill": "spreadsheets",
  "action": "create",
  "input": {
    "title": "Launch Tracker"
  }
}

Get spreadsheet metadata:

{
  "skillProvider": "google-sheets",
  "skill": "spreadsheets",
  "action": "get",
  "input": {
    "spreadsheetId": "SPREADSHEET_ID"
  }
}

Read a range:

{
  "skillProvider": "google-sheets",
  "skill": "spreadsheets",
  "action": "read-range",
  "input": {
    "spreadsheetId": "SPREADSHEET_ID",
    "range": "Sheet1!A1:C10"
  }
}

Append values:

{
  "skillProvider": "google-sheets",
  "skill": "spreadsheets",
  "action": "append-values",
  "input": {
    "spreadsheetId": "SPREADSHEET_ID",
    "range": "Sheet1!A:C",
    "values": [["2026-03-13", "Launch", "On track"]],
    "valueInputOption": "USER_ENTERED"
  }
}

Update a range:

{
  "skillProvider": "google-sheets",
  "skill": "spreadsheets",
  "action": "update-values",
  "input": {
    "spreadsheetId": "SPREADSHEET_ID",
    "range": "Sheet1!B2:C3",
    "values": [["Owner", "Status"], ["Wei", "Ready"]],
    "valueInputOption": "USER_ENTERED"
  }
}

Share a spreadsheet:

{
  "skillProvider": "google-sheets",
  "skill": "spreadsheets",
  "action": "share",
  "input": {
    "spreadsheetId": "SPREADSHEET_ID",
    "type": "user",
    "role": "writer",
    "emailAddress": "collab@example.com"
  }
}

{
  "id": "spreadsheets",
  "name": "Spreadsheets",
  "description": "Create spreadsheets, inspect sheet structure, read or update ranges, and share Google Sheets files created through Shift.",
  "actions": {
    "get": {
      "upstream": {
        "method": "GET",
        "baseUrl": "https://sheets.googleapis.com",
        "path": "/v4/spreadsheets/{spreadsheetId}",
        "auth": { "mode": "bearer" }
      },
      "input": {
        "queryTemplate": {
          "includeGridData": {
            "$value": "$input.includeGridData",
            "$default": false
          }
        }
      },
      "output": {
        "responseMap": {
          "spreadsheetId": "$response.spreadsheetId",
          "spreadsheetUrl": "$response.spreadsheetUrl",
          "title": "$response.properties.title",
          "locale": "$response.properties.locale",
          "timeZone": "$response.properties.timeZone",
          "sheets": {
            "$each": "$response.sheets",
            "map": {
              "sheetId": "$item.properties.sheetId",
              "title": "$item.properties.title",
              "index": "$item.properties.index",
              "sheetType": "$item.properties.sheetType",
              "rowCount": "$item.properties.gridProperties.rowCount",
              "columnCount": "$item.properties.gridProperties.columnCount"
            }
          }
        }
      }
    },
    "create": {
      "upstream": {
        "method": "POST",
        "baseUrl": "https://sheets.googleapis.com",
        "path": "/v4/spreadsheets",
        "auth": { "mode": "bearer" }
      },
      "input": {
        "bodyTemplate": {
          "properties": {
            "title": "$input.title"
          }
        }
      },
      "output": {
        "responseMap": {
          "spreadsheetId": "$response.spreadsheetId",
          "spreadsheetUrl": "$response.spreadsheetUrl",
          "title": "$response.properties.title"
        }
      }
    },
    "read-range": {
      "upstream": {
        "method": "GET",
        "baseUrl": "https://sheets.googleapis.com",
        "path": "/v4/spreadsheets/{spreadsheetId}/values/{range}",
        "auth": { "mode": "bearer" }
      },
      "input": {
        "queryTemplate": {
          "majorDimension": "$input.majorDimension",
          "valueRenderOption": "$input.valueRenderOption",
          "dateTimeRenderOption": "$input.dateTimeRenderOption"
        }
      },
      "output": {
        "responseMap": {
          "range": "$response.range",
          "majorDimension": "$response.majorDimension",
          "values": "$response.values"
        }
      }
    },
    "append-values": {
      "upstream": {
        "method": "POST",
        "baseUrl": "https://sheets.googleapis.com",
        "path": "/v4/spreadsheets/{spreadsheetId}/values/{range}:append",
        "auth": { "mode": "bearer" }
      },
      "input": {
        "queryTemplate": {
          "valueInputOption": {
            "$value": "$input.valueInputOption",
            "$default": "USER_ENTERED"
          },
          "insertDataOption": "$input.insertDataOption",
          "includeValuesInResponse": {
            "$value": "$input.includeValuesInResponse",
            "$default": false
          }
        },
        "bodyTemplate": {
          "majorDimension": {
            "$value": "$input.majorDimension",
            "$default": "ROWS"
          },
          "values": "$input.values"
        }
      },
      "output": {
        "responseMap": {
          "spreadsheetId": "$response.spreadsheetId",
          "tableRange": "$response.tableRange",
          "updatedRange": "$response.updates.updatedRange",
          "updatedRows": "$response.updates.updatedRows",
          "updatedColumns": "$response.updates.updatedColumns",
          "updatedCells": "$response.updates.updatedCells"
        }
      }
    },
    "update-values": {
      "upstream": {
        "method": "PUT",
        "baseUrl": "https://sheets.googleapis.com",
        "path": "/v4/spreadsheets/{spreadsheetId}/values/{range}",
        "auth": { "mode": "bearer" }
      },
      "input": {
        "queryTemplate": {
          "valueInputOption": {
            "$value": "$input.valueInputOption",
            "$default": "USER_ENTERED"
          },
          "includeValuesInResponse": {
            "$value": "$input.includeValuesInResponse",
            "$default": false
          }
        },
        "bodyTemplate": {
          "majorDimension": {
            "$value": "$input.majorDimension",
            "$default": "ROWS"
          },
          "values": "$input.values"
        }
      },
      "output": {
        "responseMap": {
          "spreadsheetId": "$response.spreadsheetId",
          "updatedRange": "$response.updatedRange",
          "updatedRows": "$response.updatedRows",
          "updatedColumns": "$response.updatedColumns",
          "updatedCells": "$response.updatedCells"
        }
      }
    },
    "share": {
      "upstream": {
        "method": "POST",
        "baseUrl": "https://www.googleapis.com",
        "path": "/drive/v3/files/{fileId}/permissions",
        "auth": { "mode": "bearer" }
      },
      "input": {
        "pathParams": {
          "fileId": "$input.spreadsheetId"
        },
        "queryTemplate": {
          "supportsAllDrives": true,
          "sendNotificationEmail": {
            "$value": "$input.sendNotificationEmail",
            "$default": true
          },
          "fields": "id, type, role, emailAddress, displayName"
        },
        "bodyTemplate": {
          "type": "$input.type",
          "role": "$input.role",
          "emailAddress": "$input.emailAddress"
        }
      },
      "output": {
        "responseMap": {
          "id": "$response.id",
          "type": "$response.type",
          "role": "$response.role",
          "emailAddress": "$response.emailAddress",
          "displayName": "$response.displayName"
        }
      }
    }
  }
}