Google Sheets Interaction Skill

Overview

This skill provides patterns and best practices for automating Google Sheets interactions through browser automation. Google Sheets is a canvas-based web app — standard DOM element references are often unreliable; prefer keyboard shortcuts and coordinate clicks.

Agent Workflow (Always Follow This Order)

Orient — Take a screenshot. Confirm you're on the right tab/sheet. Identify existing data range.
Plan — Decide what cells to read or write, in what order.
Execute in small steps — One logical action at a time (one row, one format operation, etc.).
Verify — Take a screenshot after each meaningful action to confirm the result before continuing.
Recover if needed — If something looks wrong, Cmd+Z immediately before doing anything else.

1. Session Setup / Opening a Sheet

Starting from scratch:

Navigate to https://sheets.google.com
Click "Blank spreadsheet" to create new, or click an existing file
After clicking, wait for the new tab — Sheets often opens in a new tab. Switch to it before proceeding.

Opening an existing file:

Navigate to https://drive.google.com, search for the file, and open it
Or navigate directly via a known URL

Before acting on any sheet:

Take a screenshot to confirm the sheet is loaded (look for the grid and toolbar)
Confirm which sheet tab is active (bottom of screen)
Use Cmd+Home to go to A1 and orient yourself

2. Reading / Understanding Existing Data

Before writing anything, read what's already there:

Screenshot first — Get a visual overview of the data layout
browser_get_text — Extracts cell text content; useful for reading values without clicking
Cmd+End — Jumps to the last cell with data; tells you the extent of the dataset
Cmd+Home — Returns to A1

To read a specific cell's value: Click the cell and read the formula bar (visible in screenshot), or use browser_get_text and parse the result.

3. Navigation & Cell Selection

DO NOT type cell references into the Name Box — it often enters text into cells instead of navigating.

Preferred navigation methods:

Goal	Method
Go to A1	`Cmd+Home`
Go to start of row	`Home`
Go to last data cell	`Cmd+End`
Move right	`Tab`
Move down	`Enter`
Move by one cell	Arrow keys
Select entire row	Click the row number on the left (e.g., "2")
Select entire column	Click the column letter at top (e.g., "A")
Select a range	Click start cell, then `Shift+click` end cell
Select column range (for resize)	Click first column letter, `Shift+click` last

Confirming current cell location:

Take a screenshot and look at the Name Box (top-left, shows current cell address like "A1")
Look at the formula bar (top center) which shows the selected cell's content
The selected cell has a blue/green border — visible in screenshots

4. Data Entry

Basic pattern for tabular data:

1. Click on the starting cell (e.g., A1)
2. Type value → Tab (moves right)
3. Type value → Tab → Tab → ...
4. At end of row: press Enter (moves to next row, returns to column where you started)
5. Press Home to ensure you're at column A
6. Repeat

Entering a single value:

1. Click the target cell
2. Type the value
3. Press Enter or Tab to confirm (don't leave it unconfirmed)

Pasting multi-line data:

Prepare data as tab-separated text (TSV)
Click the target starting cell
Paste with Cmd+V
Verify result with a screenshot

Avoid:

Typing tab characters inside a string to separate columns — they won't work as cell separators
Leaving a cell in edit mode (blinking cursor) before navigating away — always confirm with Enter or Tab

5. Formulas

Entering a formula:

1. Click target cell
2. Type = followed by the formula (e.g., =SUM(A1:A10))
3. Press Enter to confirm

Common formulas:

Formula	Purpose
`=SUM(A1:A10)`	Sum a range
`=AVERAGE(B2:B20)`	Average
`=COUNT(C2:C100)`	Count non-empty cells
`=IF(A1>10,"Yes","No")`	Conditional
`=VLOOKUP(key,range,col,0)`	Lookup
`=A1&" "&B1`	Concatenate cells
`=TODAY()`	Today's date

Copying a formula down a column:

1. Click the cell with the formula
2. Press Cmd+C to copy
3. Select the range below (click first cell, Shift+click last)
4. Press Cmd+V to paste

Or: click the cell, then double-click the small blue square in the cell's bottom-right corner (auto-fill handle) — this fills down to match adjacent data.

6. Formatting

Bold / Italic / Underline:

1. Select cell(s) or row (click row number)
2. Cmd+B (bold), Cmd+I (italic), Cmd+U (underline)

Header row formatting (recommended pattern):

1. Click the row number to select the entire row
2. Cmd+B for bold
3. Click the Fill Color button (paint bucket in toolbar) → choose a color
4. View > Freeze > 1 row (so header stays visible when scrolling)

Number formatting:

Format > Number > choose format (Currency, Percent, Date, etc.)

Text wrapping:

Format > Wrapping > Wrap (or Overflow / Clip)

Column width auto-fit:

1. Click first column letter, Shift+click last column letter to select range
2. Right-click on any selected column header
3. "Resize columns A - X"
4. Choose "Fit to data" → OK

7. Sheet Tabs (Multiple Sheets)

Sheet tabs appear at the bottom of the screen.

Action	Method
Switch to a sheet	Click its tab at the bottom
Add a new sheet	Click the + button at the bottom left
Rename a sheet	Double-click the tab, type new name, Enter
Duplicate a sheet	Right-click the tab → "Duplicate"
Delete a sheet	Right-click the tab → "Delete"

Always confirm which sheet tab is active before reading or writing data.

8. Menus Reference

Menu	Useful For
View > Freeze	Freeze rows/columns
Format > Number	Number/date formatting
Format > Wrapping	Text wrap in cells
Data > Sort range	Sort by column
Data > Filter	Add filter dropdowns
Data > Split text to columns	Split delimited text
Insert > Row / Column	Insert rows or columns

9. Common Keyboard Shortcuts

Action	Shortcut
Bold	`Cmd+B`
Italic	`Cmd+I`
Undo	`Cmd+Z`
Redo	`Cmd+Shift+Z`
Select All	`Cmd+A`
Copy	`Cmd+C`
Paste	`Cmd+V`
Go to A1	`Cmd+Home`
Go to last data cell	`Cmd+End`
Go to start of row	`Home`
Move right	`Tab`
Move down	`Enter`
Delete cell contents	`Delete`
Find & Replace	`Cmd+H`
Insert row above	`Cmd+Option+Shift+=` (with row selected)

10. Error Recovery

Something went wrong — act immediately:

Cmd+Z — Undo the last action (do this before anything else)
Take a screenshot to assess current state
Re-orient: Cmd+Home to go to A1
Re-read the data before retrying

Common problems and fixes:

Problem	Fix
Text entered into wrong cell	`Cmd+Z`, then navigate correctly and re-enter
Formula shows as text (starts with `=` but not computing)	Click cell, press F2 to edit, confirm cell is not formatted as plain text
Dialog appeared unexpectedly	Screenshot to read it, then press `Escape` or respond appropriately
Sheet opened in new browser tab	Use `browser_tabs` / tabs tool to switch to the new tab
Cell stuck in edit mode	Press `Escape` to cancel edit, or `Enter` to confirm

11. Saving

Google Sheets auto-saves continuously. You do not need to manually save.

Watch for "Saving..." → "All changes saved" in the top bar to confirm
If you see a "Save" prompt, the file may be a non-Google format (e.g., .xlsx) — click Save to keep changes

12. Browser Automation Tips

Google Sheets is a canvas app — DOM element references (ref_id) often don't work for cells. Use coordinate clicks instead.
Always screenshot before and after significant actions
Use keyboard shortcuts over toolbar button clicks whenever possible — more reliable
Toolbar buttons can be clicked by coordinate if needed; take a screenshot to locate them first
Name Box (top-left showing cell address): Read it in screenshots to confirm position, but don't type into it for navigation
After creating a new sheet, wait for the new browser tab to open, then switch to it before interacting

google-sheets