aside-google-sheets

Google Sheets

Use the googleSheets global in the REPL tool. Cookie-only reads work without opening a tab; write operations open a Sheets tab automatically.

IMPORTANT: User may use multiple Google accounts. ALWAYS CALL console.log(await googleAccounts.list()) to identify the correct account UID when constructing URLs with /u/{uid}/.

Quick Reference

// Read spreadsheet metadata (cookie-only, no tab)
const info = await googleSheets.getSpreadsheetInfo('https://docs.google.com/spreadsheets/d/.../edit#gid=0');
console.log(info);
// → { docTitle: string, sheets: [{ name, gid, gridId, size: { rows, cols } }] }

// Read a single sheet (cookie-only, no tab)
const data = await googleSheets.readSheet('https://docs.google.com/spreadsheets/d/.../edit#gid=0');
console.log(data.cells.slice(0, 20));

// Read all sheets (cookie-only, no tab)
const allSheets = await googleSheets.readAllSheets(url);

// Write values (opens tab, clipboard paste)
await googleSheets.connect(url);
await googleSheets.writeMatrix('A1', [['Hello', 'World'], [1, 2]]);
await googleSheets.dispose();

// Navigate, notes, comments (opens tab)
await googleSheets.connect(url);
await googleSheets.navigateToCell('B5');
await googleSheets.setNote('A1', 'Remember to update');
await googleSheets.addComment('A1', 'Needs review');
await googleSheets.dispose();

Methods

Cookie-only operations (no tab needed)

googleSheets.getSpreadsheetInfo(url): Promise<SpreadsheetInfo>

Discover all sheets in a spreadsheet: names, gids, sizes.

googleSheets.readSheet(url, gid?): Promise<SheetData>

Read cell data from a specific sheet. Returns cells with values, formulas, formatting, notes, hyperlinks, images, merges, and dropdowns.

googleSheets.readAllSheets(url): Promise<SheetData[]>

Read ALL sheets in a spreadsheet. Fetches each sheet page separately.

Tab-based operations (opens browser tab)

Call connect(url) before using these, and dispose() when done.

googleSheets.connect(url): Promise<void>