How do I specify which spreadsheet to update?

You can provide a specific Spreadsheet ID directly, or use search skills to find the correct ID before running the update command.

Does this skill support adding data without overwriting?

Yes, it includes an 'append' sub-command specifically designed to add new rows to the bottom of an existing sheet.

What authentication is required for this skill?

The skill relies on the underlying Python script which typically requires Google Cloud credentials configured on your local machine to access the Sheets API.

Can I update multiple rows at once?

Yes, the skill supports range-based updates, allowing you to send nested arrays to update multiple rows and columns in a single operation.

Google Sheets Updater

Name: Google Sheets Updater
Author: shiiman

byshiiman

•

생산성 및 워크플로

Updates and appends data to Google Sheets spreadsheets directly via terminal commands.

소개

The Google Sheets Updater skill enables Claude to interact programmatically with Google Spreadsheets, allowing for seamless data synchronization and automated reporting. It provides the capability to update specific cells, modify entire ranges with structured data, and append new rows to the end of sheets without manual entry. This skill is particularly useful for developers who need to log script outputs, maintain project tracking sheets, or automate data entry tasks as part of their coding workflow.

주요 기능

Integration with Google Sheets API via CLI
Support for structured JSON value inputs
Single cell and multi-range cell updates
2 GitHub stars
Automated retrieval of edit URLs and update statuses
Append new rows to the end of a sheet automatically

사용 사례

Maintaining project management sheets by updating task statuses from the terminal.
Syncing local data analysis results or scraping outputs directly into Google Sheets.
Logging automated test results or build statuses to a shared team spreadsheet.

소개

주요 기능

Integration with Google Sheets API via CLI
Support for structured JSON value inputs
Single cell and multi-range cell updates
2 GitHub stars
Automated retrieval of edit URLs and update statuses
Append new rows to the end of a sheet automatically

사용 사례

Maintaining project management sheets by updating task statuses from the terminal.
Syncing local data analysis results or scraping outputs directly into Google Sheets.
Logging automated test results or build statuses to a shared team spreadsheet.