← 返回 Skills 市场

Andrew Google Sheets

Name: Andrew Google Sheets
Author: ibluewind

作者 김현곤 · GitHub ↗ · v1.0.0 · MIT-0

cross-platform ✓ 安全检测通过

总下载

当前安装

版本数

在 OpenClaw 中安装

/install andrew-google-sheets

功能描述

Google Sheets API �� 기/�기, ��, ��맷� �리. OAuth 2.0 �� . �� 구� �� 를 조��고 �� .

使用说明 (SKILL.md)

Google Sheets

Overview

Google Sheets API 를 �� 를 조�, ��, �� . OAuth 2.0 �� Google Sheets � �근��.

Setup

1. OAuth ��

�미 구� �린�� :

# �� ��� �미 ���� ��면 ��
ls ~/.google-credentials.json

2. �존� ��

pip install google-api-python-client google-auth-httplib2 google-auth-oauthlib

3. ��

cd /Users/andrew/.openclaw/workspace/skills/google-sheets
python3 scripts/oauth_setup.py

첫 �� 리고 Google �� 그� � �� .

Capabilities

�� 기

�� 조�:

"���� ��� '�무��' � �근 10 � 보��"
"A1 ��� D10 �� ���� ���"

�� 조�:

"'2026 � 4 �' ���� 모� ���� 보��"

�� 기

�� :

"�무�� ���� � �목 ��: 'OpenClaw ��', ��� '2026-04-21', ��� '2026-04-21', ��� '100%'"

�� :

"�무��� 6 �째 � ���� '100%' � ��������"

�� 리

� �� :

"� ������� '����� �리' ����"

�� 목� ��:

"� 구� ��� 목� 보��"

Usage Examples

�� 1: �� 목� 조�

from scripts.sheets_ops import list_spreadsheets

# ���� 모� ������� 목�
sheets = list_spreadsheets()
for sheet in sheets:
    print(f"{sheet['name']} - {sheet['spreadsheetId']}")

�� 2: �� 기

from scripts.sheets_ops import read_range

# ��� ���� �� �기
data = read_range('SPREADSHEET_ID', 'Sheet1!A1:D10')
for row in data:
    print(row)

�� 3: �� 기

from scripts.sheets_ops import write_range

# ��� ��� ���� �기
write_range(
    spreadsheet_id='SPREADSHEET_ID',
    range_name='Sheet1!A1:D1',
    values=[['���', '���', '���', '���']]
)

�� 4: �� (Append)

from scripts.sheets_ops import append_rows

# � � ��
append_rows(
    spreadsheet_id='SPREADSHEET_ID',
    range_name='Sheet1!A:D',
    values=[['� ��', '2026-04-21', '', '0%']]
)

�� 5: � ��

from scripts.sheets_ops import create_spreadsheet

# � ������� ��
new_sheet = create_spreadsheet('�무��')
print(f"�� ��: {new_sheet['spreadsheetId']}")

Files Structure

google-sheets/
��� SKILL.md
��� scripts/
    ��� oauth_setup.py      # OAuth 2.0 �� � ���� �리
    ��� sheets_ops.py       # Sheets API �� ����

Security Notes

OAuth �� ~/.google-sheets-token.pickle � ��
�� ~/.google-credentials.json � �� (�린�� 공�)
� �� .gitignore � ��
�� : https://www.googleapis.com/auth/spreadsheets (�� 체 �근)

Troubleshooting

"OAuth �� " ��:

~/.google-credentials.json ��
구� �린� �� 미 ��

�� :

�� 고 ��: rm ~/.google-sheets-token.pickle

�� :

�� : rm ~/.google-sheets-token.pickle && python3 scripts/oauth_setup.py

Integration with Other Google Skills

Same OAuth credentials (~/.google-credentials.json) are shared with google-calendar and google-tasks skills, so you only need to authenticate once!

安全使用建议

This skill appears to do what it says: run an OAuth flow and call Google Sheets/Drive APIs. Before installing, consider: 1) You must create OAuth client credentials and place them at ~/.google-credentials.json as instructed. 2) The tool saves an OAuth token at ~/.google-sheets-token.pickle; ensure that file is created only by code you trust and keep its filesystem permissions restrictive (it contains sensitive credentials). 3) Pickle files can be dangerous if tampered with — do not reuse an untrusted token file. 4) The OAuth scope grants Sheets/Drive access to any code that can read those files (including other Google-* skills that share the same credential file), so limit scope in Google Cloud Console if you want finer permissions. 5) The SKILL.md contains a hard-coded example path (/Users/andrew/...) — adapt commands to your environment. If you want higher assurance, run these scripts in an isolated environment, review the included Python files (they are short and straightforward), and create a dedicated OAuth client with the minimum scope needed. If the skill attempted network calls to non-Google endpoints, asked for unrelated cloud keys, or used obfuscated code, reassess; none of those are present here.

功能分析

Type: OpenClaw Skill Name: andrew-google-sheets Version: 1.0.0 The skill bundle provides standard Google Sheets API integration, allowing an agent to read, write, and manage spreadsheets. It uses the official Google Python client libraries and implements a standard OAuth 2.0 flow in `scripts/oauth_setup.py`, storing credentials and tokens in the user's home directory (`~/.google-credentials.json` and `~/.google-sheets-token.pickle`). The code in `scripts/sheets_ops.py` contains straightforward wrapper functions for Google Sheets operations without any evidence of data exfiltration, malicious execution, or obfuscation. The broken text in `SKILL.md` appears to be a character encoding issue rather than a deliberate attempt at evasion.

能力标签

requires-oauth-tokenrequires-sensitive-credentials

能力评估

✓ Purpose & Capability

Name/description promise Google Sheets operations via OAuth 2.0. The included Python modules (oauth_setup.py, sheets_ops.py) implement exactly that (OAuth flow, token storage, Sheets and Drive API calls). No unrelated services, binaries, or credentials are requested.

ℹ Instruction Scope

SKILL.md instructs installing Google API client libs and running scripts that read/write credential files in the user's home (~/.google-credentials.json, ~/.google-sheets-token.pickle). It also references a user-specific workspace path (/Users/andrew/...) as an example — odd but not harmful. All runtime actions are limited to Google APIs; there are no instructions to read other system files or send data to non-Google endpoints.

✓ Install Mechanism

No install spec; it's instruction-only and includes local Python scripts. The SKILL.md asks the user to pip install google-api-python-client and related libs — a normal, low-risk approach. No downloads from arbitrary URLs or installer scripts that write unknown binaries.

ℹ Credentials

The skill requests no environment variables but relies on local OAuth files (~/.google-credentials.json for client secrets and ~/.google-sheets-token.pickle for the token). Sharing those credentials with other Google skills is explicit in the doc. Two points to consider: (1) storing credentials as a pickle is common in Google samples but can be dangerous if the pickle file is tampered with (pickle.load can execute code on malicious data); (2) the OAuth credential/token grant broad Sheets/Drive scope to any code that can read those files, so file permissions and trust in other skills matter.

✓ Persistence & Privilege

always:false (normal). The skill writes a token file to the user's home directory (expected for OAuth workflows). It does not attempt to modify other skills or system-wide settings. Note: because the skill can be invoked autonomously by the agent (default behavior), it will be able to access any spreadsheets permitted by the OAuth token — this is expected for a Sheets integration.

如何使用

确保已安装 OpenClaw（本地或 Docker 部署）
在对话框中输入安装命令：/install andrew-google-sheets
安装完成后，直接呼叫该 Skill 的名称或使用 /andrew-google-sheets 触发
根据 Skill 的参数说明提供必要输入，即可获得结构化输出

版本历史

v1.0.0

andrew-google-sheets 1.0.0 - Initial release. - Provides Google Sheets integration via the API, supporting spreadsheet reading, writing, and formatting. - OAuth 2.0 authentication setup with shared credentials across relevant Google skills. - Includes Python code examples and troubleshooting steps for setup and common issues. - Shares usage of OAuth credentials with `google-calendar` and `google-tasks` for streamlined authentication.

元数据

Slug andrew-google-sheets

版本 1.0.0

许可证 MIT-0

累计安装 1

当前安装数 1

历史版本数 1

常见问题