How do I handle spreadsheet names with spaces in API calls?

Sheet names with spaces should be wrapped in single quotes within the A1 notation, and the exclamation mark ('!') must be URL encoded as '%21' when used in the API endpoint URL.

Can I use formulas when writing data to a sheet?

Yes, by using the 'USER_ENTERED' valueInputOption, you can write strings that Google Sheets will parse as formulas, just as if you typed them into the UI.

What authentication methods does this skill support?

The skill supports three primary methods: OAuth 2.0 (using Refresh Tokens), Service Account JSON keys, and API Keys for read-only access to public spreadsheets.

Is there a limit to how many requests I can make?

By default, the Google Sheets API has a quota of 300 requests per minute per project. Using batch operations included in this skill is recommended to stay within limits.

Google Sheets Integration

Name: Google Sheets Integration
Author: vm0-ai

byvm0-ai

•

Productivity & Workflow

Automates reading, writing, and managing Google Sheets data using direct API calls.

About

This skill enables Claude to interact directly with the Google Sheets API via curl, allowing for seamless programmatic manipulation of spreadsheet data. It supports a wide range of operations including reading specific cell ranges, appending new rows, batch updating multiple sheets, and creating entirely new spreadsheets. Whether you are automating reporting workflows, syncing data between applications, or using Google Sheets as a lightweight backend, this skill provides the necessary patterns to handle authentication and complex A1 notation queries efficiently.

Key Features

Execute batch updates to modify multiple ranges in a single request
18 GitHub stars
Manage spreadsheet structure including creating and deleting sheets
Read and write cell values using standard A1 notation
Support for OAuth 2.0, Service Accounts, and Public API Key authentication
Append rows dynamically to the end of existing spreadsheets

Use Cases

Automated reporting and data logging from local scripts or applications
Syncing project tasks or contact lists between developer tools and spreadsheets
Using Google Sheets as a collaborative, low-code database for prototype applications

About

Key Features

Execute batch updates to modify multiple ranges in a single request
18 GitHub stars
Manage spreadsheet structure including creating and deleting sheets
Read and write cell values using standard A1 notation
Support for OAuth 2.0, Service Accounts, and Public API Key authentication
Append rows dynamically to the end of existing spreadsheets

Use Cases

Automated reporting and data logging from local scripts or applications
Syncing project tasks or contact lists between developer tools and spreadsheets
Using Google Sheets as a collaborative, low-code database for prototype applications