skills.rest
oresttokovenko
oresttokovenkoCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

recipe-compare-sheet-tabs

Compares data from two tabs in a Google Sheet to identify differences.

Updated Nov 9, 2023
Search Tags:#data analysis#spreadsheet#diff#tabs#google sheets#compare#gws
One-click install
npx skills add https://github.com/oresttokovenko/dot-files --skill recipe-compare-sheet-tabs-oresttokovenko
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: recipe-compare-sheet-tabs
Source: https://github.com/oresttokovenko/dot-files/tree/main/chezmoi/dot_agents/skills/recipe-compare-sheet-tabs
Command: npx skills add https://github.com/oresttokovenko/dot-files --skill recipe-compare-sheet-tabs-oresttokovenko

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Manually comparing two tabs in a Google Sheet to spot changes between periods or versions is tedious and error-prone. This Skill reads both tabs and identifies the differences for you. ## Core Features & Use Cases - Tab Data Reading: Reads a specified range from two tabs in the same Google Sheet using the gws CLI. - Difference Identification: Compares the two datasets and highlights what changed between them. - Use Case: Compare a January budget tab against a February budget tab in the same spreadsheet to quickly see which line items were added, removed, or modified. ## Quick Start Ask the assistant to compare the January and February tabs in your Google Sheet and list the differences, providing the spreadsheet ID.

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 two tabs in a Google Sheet?▼

Read each tab's range with the gws sheets +read command using the same spreadsheet ID, then compare the returned datasets. This Skill reads ranges like January!A1:D and February!A1:D and identifies the changes between them.

What tool reads Google Sheets data from the command line?▼

The gws CLI reads Google Sheets data via the sheets +read subcommand, accepting a spreadsheet ID and an A1-notation range. This Skill depends on gws and the gws-sheets skill being available.

Can I compare tabs from different spreadsheets?▼

This Skill is designed for two tabs within the same Google Sheet, using one spreadsheet ID with different tab ranges. Comparing across separate spreadsheets would require adjusting the read commands to use two different spreadsheet IDs.

What are the prerequisites for comparing Google Sheet tabs?▼

You need the gws binary installed and the gws-sheets skill loaded before running this recipe. You also need the spreadsheet ID and the tab names with the cell ranges you want to compare.

What are the limitations of comparing sheet tabs by range?▼

The comparison is limited to the explicit A1 ranges you specify, such as A1:D, so data outside those ranges is ignored. Structural differences like row insertions may also require manual interpretation of the results.

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
TelepotchTelepotch

edi-communication

Summarize git diffs and commits into recipient-specific plain-text status reports.

Official
Intermediate
vikingokftvikingokft

recipe-compare-sheet-tabs

Compare two Google Sheets tabs row by row and output a structured diff report.

Official
Intermediate
73ai73ai
4

recipe-compare-sheet-tabs

Compare two Google Sheets tabs and produce a structured diff.

Official
Intermediate