google-sheets

Name: google-sheets
Availability: InStock
Author: xztxy

Automate Google Sheets data entry, formulas, and formatting via browser automation.

5|1|Updated Jan 19, 2026

Search Tags:#automation #browser automation #formulas #spreadsheet #data entry #google sheets

Ready to run

npx skills add https://github.com/xztxy/openwork --skill google-sheets-xztxy

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/xztxy/openwork/tree/main/apps/desktop/bundled-skills/google-sheets
Command: npx skills add https://github.com/xztxy/openwork --skill google-sheets-xztxy

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates tedious interactions with Google Sheets, allowing for efficient data entry, formula application, and formatting without manual clicking and typing.

Core Features & Use Cases

Automated Data Entry: Input tabular data row by row or paste multi-line data.
Formula Application: Easily insert and copy complex formulas like SUM, AVERAGE, and VLOOKUP.
Formatting & Styling: Apply bold, italics, and custom number formats, and auto-fit columns.
Use Case: Automatically populate a sales report spreadsheet with new data, apply currency formatting, and add a SUM formula to the total column.

Quick Start

Use the google-sheets skill to enter the following data into a new spreadsheet starting at cell A1: Name, Age, City, then "Alice", 30, "New York", then "Bob", 25, "Los Angeles".

Frequently Asked Questions about google-sheets

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

FAQPage Schema

How do I automate data entry in Google Sheets?▼

You can automate data entry in Google Sheets via browser automation, which inputs tabular data row by row or pastes multi-line data directly into cells. This eliminates manual clicking and typing by using keyboard shortcuts and coordinate clicks.

Can I automatically apply formulas like VLOOKUP and SUM to a spreadsheet?▼

Yes, you can automatically apply formulas like VLOOKUP and SUM to a spreadsheet through browser automation. The process inserts complex formulas into target cells and copies them across columns to calculate totals or look up data automatically.

What is the best way to format cells and apply number formats in Google Sheets automatically?▼

The best way to format cells automatically is through browser automation that applies bold, italics, custom number formats, and auto-fits columns. This visual styling is executed via simulated keyboard shortcuts and coordinate clicks on the target cells.

Does browser automation for Google Sheets require any external dependencies or API setups?▼

Browser automation for Google Sheets requires no external dependencies or API setups. It manages spreadsheet interactions, session setup, and error recovery directly through the browser interface without needing additional components.

How do I handle error recovery when automating Google Sheets interactions?▼

Error recovery during Google Sheets automation is handled directly within the browser automation process. It manages session setup, data reading, and navigation to ensure robust spreadsheet management when inputting data or applying formulas encounters issues.