validate-spreadsheet

Overview

validate-spreadsheet checks any Google Sheet for missing or empty cells in the columns you specify, shows a scannable summary in chat, and can optionally send a Slack reminder mentioning the person responsible. It works with any Google Sheets URL — not just specific documents.

The sheet is fetched and parsed in the browser (via the Claude in Chrome extension), using your existing Google login — no API keys or service accounts needed.

What It Asks For

• Sheet URL — the full Google Sheets link
• Columns to check — by letter (B, C, F) or by header name (APPID, Country, HO Date)
• Start row — defaults to 2 (skips the header)
• Slack notification (optional) — channel ID and who to mention

Output

✅ Validation complete
Checked 120 rows from row 2, columns: B, C, F

3 rows with missing data:
• Row 12 — Acme Corp [B, F]
• Row 15 — PT Example [C]
...
117 rows fully complete.

The optional Slack message mentions the owner, names the sheet and columns, lists each incomplete row, and ends with a friendly call to action.

How to Access

Download the validate-spreadsheet.skill package from the shared Drive folder and import it into Claude Skills. Requires the Claude in Chrome extension with a browser logged into Google.

Example Prompts

Check if my sheet is fully filled in: [Sheets URL] — columns APPID,
Country, and HO Date, starting from row 10.

Validate this Google Sheet and send a reminder to #ops-data
mentioning @rina for any rows with missing data.