---
name: "validate-spreadsheet"
description: "Check any Google Sheet for missing or incomplete fields — pick the columns and start row, get a scannable report, and optionally send a Slack reminder."
type: skill
roles: ["Operations", "Quality Assurance"]
activities: ["Data Validation", "Quality Assurance"]
tags: ["Spreadsheet", "Validation", "Google Sheets", "Slack"]
owner: "Zain"
sourceUrl: "https://drive.google.com/drive/folders/1_xtsnu5FxD_pEVFOuJc6yxOSubmG3GHX"
---

# validate-spreadsheet

> Check any Google Sheet for missing or incomplete fields — pick the columns and start row, get a scannable report, and optionally send a Slack reminder.

## 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](https://drive.google.com/drive/folders/1_xtsnu5FxD_pEVFOuJc6yxOSubmG3GHX) 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.
```