skills.rest
temple-slope
temple-slopeCOMMUNITY
Explore all skills by this author →
GitHub

recipe-compare-sheet-tabs

Compare two Google Sheets tabs and report added, removed, or changed rows.

Updated May 25, 2025
Search Tags:#google-sheets#qa-checks#sheet-compare#two-tabs#data-reconciliation#data-diff
One-click install
npx skills add https://github.com/temple-slope/dotfiles --skill recipe-compare-sheet-tabs-temple-slope
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: recipe-compare-sheet-tabs
Source: https://github.com/temple-slope/dotfiles/tree/main/.agents/skills/recipe-compare-sheet-tabs
Command: npx skills add https://github.com/temple-slope/dotfiles --skill recipe-compare-sheet-tabs-temple-slope

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Read data from two Google Sheets tabs and identify differences between them.

Core Features & Use Cases

  • Read data from two specified tabs using standard ranges.
  • Compare row-by-row to surface added, removed, or changed rows.
  • Use cases include data reconciliation, version comparison, and QA checks across monthly tabs.

Quick Start

Provide the spreadsheet ID and the two tab ranges (e.g., January!A1:D and February!A1:D), then run the read-and-diff operation to generate a differences report.

Frequently Asked Questions about recipe-compare-sheet-tabs

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

FAQPage Schema
How do I compare data between two Google Sheets tabs to find differences?▼

To compare two Google Sheets tabs, you provide the spreadsheet ID and two tab ranges with identical columns. The tool reads both ranges and generates a differences report highlighting added, removed, or changed rows.

What is the best way to perform data reconciliation across monthly Google Sheets tabs?▼

Data reconciliation across monthly tabs requires specifying two tab ranges with identical columns. The tool reads both ranges and generates a differences report identifying added, removed, or changed rows for QA checks.

Do I need a specific Google Sheets read command to run a tab comparison?▼

Yes, running a tab comparison requires the gws-sheets skill as a prerequisite. It uses gws sheets read commands to fetch data from the specified tab ranges before performing the row-by-row diff operation.

Can I compare two tab ranges if their columns do not match exactly?▼

No, comparing two tab ranges requires identical columns in both tabs. The row-by-row comparison mechanism surfaces added, removed, or changed rows based on matching column structures across the selected ranges.

What information do I need to provide to generate a data diff report?▼

To generate a data diff report, you must provide the spreadsheet ID and two tab ranges, such as January!A1:D and February!A1:D. The tool then executes a read-and-diff operation to surface added, removed, or changed rows.

Are there limitations when performing QA checks on Google Sheets tabs with a data diff?▼

Limitations include requiring identical columns across both tab ranges for the data diff to function correctly. The tool performs row-by-row QA checks and does not support comparing completely differing spreadsheet schemas.

Related Skills

Explore More Data & Analytics Skills→
73ai73ai
4

gws-sheets-read

Read values from a Google Sheets spreadsheet using the Sheets API.

Official
Basic
niclasmartinsson-sysniclasmartinsson-sys
8

recipe-compare-sheet-tabs

Compare two Google Sheets tabs and detect added, removed, and changed rows.

Community
Intermediate
tankpkgtankpkg
1

@tank/google-sheets

Read, write, format, and analyze Google Sheets data via the API.

Official
Advanced
cellarwoodcellarwood

recipe-compare-sheet-tabs

Compare rows across two Google Sheets tabs and output a change log.

Official
Intermediate