google-sheets
Google Sheets API integration with managed OAuth. Read and write spreadsheet data, create sheets, apply formatting, and manage ranges. Use this skill when users want to read from or write to Google Sheets. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway).
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/byungkyu/google-sheetsWhat This Skill Does
The google-sheets skill provides a seamless, authenticated bridge between the OpenClaw AI agent and your Google Sheets environment. By leveraging a managed OAuth architecture, this skill removes the friction of manual credential handling. It acts as a proxy, allowing you to interact with the Google Sheets API directly through the Maton gateway. Whether you need to pull live data for analysis, automate data entry into spreadsheets, or manage complex workbook structures such as adding sheets or applying specific formatting ranges, this skill handles the heavy lifting. It ensures that your interactions with external Google services are authenticated via your Maton API key, routing your requests securely to Google's infrastructure without exposing your local tokens.
Installation
To install this skill, use the following command in your terminal within your OpenClaw environment:
clawhub install openclaw/skills/skills/byungkyu/google-sheets
Once installed, ensure you have set your MATON_API_KEY as an environment variable to authorize your requests. Manage your OAuth connections at https://ctrl.maton.ai to link your Google account properly.
Use Cases
This skill is ideal for professionals and developers who rely on spreadsheets as a central data hub. Common use cases include:
- Automated reporting: Extracting data from multiple sheets to generate summaries or dashboard data.
- CRM integration: Updating lead lists or contact information directly from AI chat commands.
- Inventory tracking: Automatically incrementing or decrementing product counts in a shared sheet based on user requests.
- Data processing: Reading raw CSV-like inputs from a sheet, performing logic in the AI agent, and writing the processed results back into a new column.
Example Prompts
- "Read the data from 'Sheet1' in my project spreadsheet and calculate the average of column B."
- "Add a new row to my 'Inventory' sheet with the values: Widget A, 50, 10.99."
- "Create a new sheet called 'Q1 Results' and format the header row with a blue background."
Tips & Limitations
- URL encoding: Always ensure your range strings are URL-encoded (e.g., 'Sheet1!A1:D10' should be passed as 'Sheet1%21A1%3AD10') when calling the API via the gateway.
- Rate Limits: Be mindful of Google Sheets API quota limits when performing bulk batch operations.
- Connection Status: If your requests fail, check the status of your connection at
https://ctrl.maton.ai. If it is not 'ACTIVE', you may need to re-authenticate. - Non-Sheets Data: For non-Google third-party applications, use the general
api-gatewayskill instead of this specific integration.
Metadata
Not sure this is the right skill?
Describe what you want to build — we'll match you to the best skill from 16,000+ options.
Find the right skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-byungkyu-google-sheets": {
"enabled": true,
"auto_update": true
}
}
}Tags(AI)
Flags: network-access, external-api
Related Skills
apollo
Apollo.io API integration with managed OAuth. Search and enrich people and companies, manage contacts and accounts. Use this skill when users want to prospect, enrich leads, or manage sales data. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway).
hubspot
HubSpot CRM API integration with managed OAuth. Manage contacts, companies, deals, and associations. Use this skill when users want to create or update CRM records, search contacts, or sync data with HubSpot. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway).
squareup
Square API integration with managed OAuth. Process payments, manage customers, orders, catalog, inventory, invoices, loyalty programs, team members, and more. Use this skill when users want to accept payments, manage point-of-sale operations, track inventory, handle invoicing, manage loyalty programs, or create payment links through Square. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway). Requires network access and valid Maton API key.
signnow
SignNow API integration with managed OAuth. E-signature platform for sending, signing, and managing documents. Use this skill when users want to upload documents, send signature invites, create templates, or manage e-signature workflows. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway). Requires network access and valid Maton API key.
vimeo
Vimeo API integration with managed OAuth. Video hosting and sharing platform. Use this skill when users want to upload, manage, or organize videos, create showcases/albums, manage folders, or interact with the Vimeo community. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway). Requires network access and valid Maton API key.