skills.rest
nuts-and-bolts-ai
nuts-and-bolts-aiOFFICIAL
Explore all skills by this author →
GitHub

google-sheets

Read and write Google Sheets data via the Sheets API v4.

Updated Mar 8, 2026
Search Tags:#automation#api#data management#crm#spreadsheet#google sheets
One-click install
npx skills add https://github.com/nuts-and-bolts-ai/nanoclaw-cheerful --skill google-sheets-nuts-and-bolts-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/nuts-and-bolts-ai/nanoclaw-cheerful/tree/main/container/skills/google-sheets
Command: npx skills add https://github.com/nuts-and-bolts-ai/nanoclaw-cheerful --skill google-sheets-nuts-and-bolts-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the process of reading from and writing to Google Sheets, eliminating the need for manual data entry and retrieval.

Core Features & Use Cases

  • Read/Write Scattered Cells: Update specific cells or ranges within a Google Sheet.
  • Search by Value: Find rows or data points based on specific criteria (e.g., email address).
  • Discover Sheet Structure: Understand the headers and layout of a Google Sheet.
  • Use Case: Update a customer status in a CRM spreadsheet, or pull a list of contacts for a marketing campaign.

Quick Start

Use the google-sheets skill to find the row with the email '[email protected]' in the provided Google Sheet.

Frequently Asked Questions about google-sheets

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate reading and writing Google Sheets data via API?▼

To automate Google Sheets data, this skill uses the Sheets API v4 to programmatically read and write spreadsheet values, discover sheet structure, and search for specific data within columns. It eliminates manual data entry by handling scattered cell updates and data retrieval directly.

What do I need to authenticate Google Sheets API requests for spreadsheet automation?▼

Google Sheets API authentication requires setting up a service account. You must configure this service account to generate the necessary credentials for securely accessing, reading, and writing spreadsheet data to your Google Sheets.

Can I search for a specific row in a Google Sheet by email address or column value?▼

Yes, you can search a Google Sheet by specific column values like an email address. This skill supports searching for targeted values within columns to find exact rows, enabling automated CRM updates and contact list filtering without manual lookup.

How do I update specific cells or ranges in multiple Google Sheets tabs?▼

Updating scattered cells or ranges in multiple Google Sheets tabs is supported through the Sheets API v4. You can programmatically target specific cells across different sheets to update CRM statuses or modify tab structures as needed.

Does this spreadsheet automation method work for managing CRM data and marketing contacts?▼

Yes, spreadsheet automation via the Google Sheets API is designed for CRM data management and marketing campaigns. You can programmatically pull contact lists, update customer statuses, and manage marketing data structures efficiently across tabs.

Related Skills

Explore More Marketing & Sales Skills→
CraftOS-devCraftOS-dev
375

google-sheet

Manage Google Sheets data, formatting, and sheets via the API with Node.js.

Community
Intermediate
73ai73ai
4

recipe-sync-contacts-to-sheet

Sync Google Contacts data into a Google Sheets spreadsheet.

Official
Intermediate
ajayatwal1105-emersonajayatwal1105-emerson

data-import

Import structured marketing and CRM data from CSV, JSON, or Google Sheets into connected platforms.

Community
Advanced
ClawLink-HQClawLink-HQ
117

attio

Automate Attio CRM contact, company, and deal management via OAuth.

Official
Advanced