recipe-compare-sheet-tabs

googleworkspace/cli

Compare data across two Google Sheets tabs to identify differences and changes.

What is recipe-compare-sheet-tabs?

This recipe reads data from two tabs in a Google Sheet and compares them to identify differences. Use it when you need to track changes between versions, compare monthly reports, or audit data consistency across sheet tabs.

Read data from multiple tabs in a single Google Sheet
Compare datasets side-by-side to identify differences
Highlight changes and variations between tab versions
Support custom range selection for targeted comparisons
Work with structured tabular data across sheets

How to install recipe-compare-sheet-tabs

npx skills add null --skill recipe-compare-sheet-tabs

Prerequisites

gws-sheets skill installed
Access to a Google Sheet with multiple tabs
Google Workspace CLI (gws) configured

Claude Code

Cursor

Windsurf

Cline

How to use recipe-compare-sheet-tabs

1.Install the gws-sheets skill if not already installed
2.Identify the Google Sheet ID and the two tabs you want to compare
3.Use gws sheets +read to read the first tab with your desired range (e.g., January!A1:D)
4.Use gws sheets +read to read the second tab with the same or different range (e.g., February!A1:D)
5.Compare the returned data to identify differences, changes, and variations

Use cases

Good for

Compare monthly financial reports across different tabs to identify spending changes
Track inventory differences between two warehouse location sheets
Audit data consistency between a draft tab and a finalized tab
Compare employee records across different department sheets
Identify pricing changes between old and new product lists

Who it's for

Data analysts
Finance professionals
Operations managers
Quality assurance specialists
Anyone managing versioned data in Google Sheets

recipe-compare-sheet-tabs FAQ

Do I need to compare the exact same range in both tabs?

No, you can specify different ranges for each tab, but comparing the same range structure makes it easier to identify differences.

What data formats does this recipe support?

It works with any tabular data that can be read from Google Sheets, including text, numbers, dates, and formulas.

Can I compare more than two tabs?

This recipe is designed for two tabs, but you can run it multiple times to compare different tab pairs.

How do I specify which columns and rows to compare?

Use the range parameter in the gws sheets +read command (e.g., "TabName!A1:D10") to specify the exact area to read.

Full instructions (SKILL.md)

Source of truth, from googleworkspace/cli.

name: recipe-compare-sheet-tabs description: "Read data from two tabs in a Google Sheet to compare and identify differences." metadata: version: 0.22.5 openclaw: category: "recipe" domain: "productivity" requires: bins: - gws skills: - gws-sheets

Compare Two Google Sheets Tabs

PREREQUISITE: Load the following skills to execute this recipe: gws-sheets

Read data from two tabs in a Google Sheet to compare and identify differences.

Steps

Read the first tab: gws sheets +read --spreadsheet SHEET_ID --range "January!A1:D"
Read the second tab: gws sheets +read --spreadsheet SHEET_ID --range "February!A1:D"
Compare the data and identify changes