← Back to Skills Marketplace
27
Downloads
0
Stars
1
Active Installs
1
Versions
Install in OpenClaw
/install andrew-google-sheets
Description
Google Sheets API ���� ������� �기/�기, ��, ��맷� �리. OAuth 2.0 �� ��. ���� 구� ����� ����를 조��고 ���� � ��.
README (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!
Usage Guidance
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.
Capability Analysis
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.
Capability Tags
Capability Assessment
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.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install andrew-google-sheets - After installation, invoke the skill by name or use
/andrew-google-sheets - Provide required inputs per the skill's parameter spec and get structured output
Version History
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.
Metadata
Frequently Asked Questions
What is Andrew Google Sheets?
Google Sheets API ���� ������� �기/�기, ��, ��맷� �리. OAuth 2.0 �� ��. ���� 구� ����� ����를 조��고 ���� � ��. It is an AI Agent Skill for Claude Code / OpenClaw, with 27 downloads so far.
How do I install Andrew Google Sheets?
Run "/install andrew-google-sheets" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Andrew Google Sheets free?
Yes, Andrew Google Sheets is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Andrew Google Sheets support?
Andrew Google Sheets is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Andrew Google Sheets?
It is built and maintained by 김현곤 (@ibluewind); the current version is v1.0.0.
More Skills