Google Sheets

Overview

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

Setup

1. OAuth ������� �� ��

�미 구� �린�� ��� �� ��� ������:

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

������� �기

���� 조�:

��� ��� 조�:

������� �기

���� ��:

���� ��:

������� �리

� ������� ��:

��� 목� ��:

Usage Examples

�� 1: ������� 목� 조�

�� 2: ��� �� �기

�� 3: ���� �기

�� 4: ���� �� (Append)

�� 5: � ������� ��

Files Structure

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!