Where can I find the Spreadsheet ID required for these commands?

The Spreadsheet ID is the unique string of characters found in the spreadsheet's URL, located between the '/d/' and '/edit' segments.

How do I write formulas to a cell using this skill?

To write formulas, use the --value-input USER_ENTERED option when running update or append commands. This tells Google Sheets to parse the string as if a user typed it.

Can I use this to create a spreadsheet with multiple tabs automatically?

Yes, the 'gws sheets create' command accepts a --sheets flag followed by a comma-separated list of names to create multiple tabs instantly.

Can I export a Google Sheet to a local CSV file?

Yes, you can use the drive files export command within the CLI, specifying the spreadsheet ID and setting the mime-type to 'text/csv'.

Does this skill support editing multiple ranges at once?

Yes, the batchUpdate and batchGet commands allow you to interact with multiple distinct ranges in a single API call for better performance.

Google Sheets CLI

Name: Google Sheets CLI
Author: nsheaps

bynsheaps

•

Productivity & Workflow

Manages Google Sheets data and metadata directly from the command line using the Google Workspace CLI.

The Google Sheets skill enables Claude to perform comprehensive spreadsheet operations via the Google Workspace CLI, allowing for seamless integration of spreadsheet data into development and automation workflows. It supports reading cell ranges, updating content with formula support, creating new spreadsheets, and managing individual tabs. This skill is particularly useful for developers needing to sync data between local environments and Google Sheets, automate report generation, or perform batch data updates without manual intervention.

Key Features

01Export spreadsheet data to CSV for local data processing

02Create new spreadsheets and manage individual sheet tabs programmatically

03Support for formula parsing via USER_ENTERED value input mode

041 GitHub stars

05Read and write spreadsheet data using standard A1 notation

06Perform batch updates and gets across multiple cell ranges

Use Cases

01Extracting specific data ranges as JSON for use in custom scripts or data pipelines

02Programmatically generating monthly financial reports or project templates

03Automating the sync of local application logs or build stats to a tracking sheet

Key Features

01Export spreadsheet data to CSV for local data processing

02Create new spreadsheets and manage individual sheet tabs programmatically

03Support for formula parsing via USER_ENTERED value input mode

041 GitHub stars

05Read and write spreadsheet data using standard A1 notation

06Perform batch updates and gets across multiple cell ranges

Use Cases

01Extracting specific data ranges as JSON for use in custom scripts or data pipelines

02Programmatically generating monthly financial reports or project templates

03Automating the sync of local application logs or build stats to a tracking sheet