Google Sheets Append Row

这是一个原子型 Skill：当需要向 Google Sheet 追加新数据行时，执行本机终端命令 gog sheets append <spreadsheetId> <range> --values-json '[[]]'，成功时返回确认追加结果的 JSON。需预装 gog 二进制并具备访问该表格的授权；不含建表、读取或改写既有单元格的能力。

zvirb

热度 42.04

最近更新 2026-05-11 17:46:09

分类：自动化依赖：代码执行 / 第三方 API应用场景：工作流

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add google-sheets-append-row

Metadata

name: Google Sheets Append Row
description: Atomic node skill to append a row in Google Sheets using the gog CLI.
os: all
requires: {"bins":["gog"]}

Lean Philosophy (Principles)

Kaizen (改善): This skill is an atomic node, broken down into its simplest, smallest component to eliminate waste and ensure perfection.
Standardized Work (Hyojun Sagyo): This node represents the most efficient, standardized path for this specific task before automation.
Jidoka (自働化): This node includes autonomous defect detection. It relies on the CLI's self-healing loop and will report errors if the append fails.

Google Sheets Append Row

This skill allows the agent to append values to a range in a Google Sheet using the native CLI.

Cognitive Directives

WHEN [New data rows need to be appended to a Google Sheet] THEN [Execute the native terminal command gog sheets append <spreadsheetId> <range> --values-json '[["..."]]']

Schema Example

{
  "command": "gog sheets append sheet_id_123 \"Tab1!A:C\" --values-json '[[\"Val1\", \"Val2\", \"Val3\"]]' --json"
}

Expected Output

A JSON object confirming the appended rows.