skills.rest
beam-ai-team
beam-ai-teamOFFICIAL
Explore all skills by this author →
GitHub

google-sheets

Read, write, and manage Google Sheets spreadsheets via the Sheets API.

Updated Aug 23, 2026
Search Tags:#automation#oauth#spreadsheet#drive#google-sheets#google-api
One-click install
npx skills add https://github.com/beam-ai-team/beam-next-skills --skill google-sheets-beam-ai-team
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/beam-ai-team/beam-next-skills/tree/main/skills/integrations/google/google-sheets
Command: npx skills add https://github.com/beam-ai-team/beam-next-skills --skill google-sheets-beam-ai-team

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires google-auth, google-auth-oauthlib, google-api-python-client, and includes scripts (resource) components.

What problem does it solve?

Streamline programmatic access to Google Sheets, enabling read, write, and management of spreadsheets from AI-enabled workflows, without manual spreadsheet manipulation.

Core Features & Use Cases

  • Read data from ranges and retrieve sheet metadata
  • Write or append data to sheets and create new spreadsheets
  • List spreadsheets in Drive and manage sheets within a workbook
  • Use Case: automatically sync a tracking sheet with CRM events or intake forms, updating status and totals in real time.

Quick Start

Authenticate with Google Sheets and start performing read, write, or append operations from your AI workflow.

Frequently Asked Questions about google-sheets

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

FAQPage Schema
How do I automate Google Sheets workflows from an AI application?▼

Automate Google Sheets workflows by using a Sheets API integration to programmatically read, write, and manage spreadsheets. This enables automated tasks like reading ranges, updating cells, and appending rows without manual spreadsheet manipulation.

Do I need Google OAuth credentials to read and write spreadsheets via the API?▼

Yes, you need Google OAuth credentials to authorize API access. The integration requires the google-auth, google-auth-oauthlib, and google-api-python-client libraries to authenticate and interact with your Drive-connected spreadsheets.

Can I create a new spreadsheet and append rows from AI-driven events?▼

Yes, you can create new spreadsheets and append rows from AI-driven events. The integration supports writing data to sheets, appending new rows, and managing sheets within a workbook across your connected Google Drive account.

What's the best way to sync a tracking sheet with CRM events in real time?▼

Sync a tracking sheet with CRM events by programmatically appending rows and updating cell values. This approach automatically updates statuses and totals in real time, eliminating manual data entry from intake forms or CRM platforms.

How does programmatic spreadsheet management handle existing sheets in Google Drive?▼

Programmatic spreadsheet management lists spreadsheets in Drive and retrieves sheet metadata. It allows AI workflows to locate existing workbooks, read data ranges, and manage individual sheets across the connected account.

Related Skills

Explore More Data & Analytics Skills→
abdullahbeamabdullahbeam
2

google-integration

Authenticate once across Google Workspace services via unified OAuth.

Community
Advanced
cellarwoodcellarwood

gws-sheets-read

Read cell values from Google Sheets via the gws CLI.

Official
Basic
zapierzapier
114

google-sheets

Automate read, write, and manage operations in Google Sheets via API v4.

Official
Intermediate
refly-airefly-ai
199

google-sheets

Manage Google Sheets data, formatting, and charts via the API.

Official
Intermediate