recipe-compare-sheet-tabs

$npx mdskill add googleworkspace/cli/recipe-compare-sheet-tabs

Compare data from two Google Sheets tabs to identify differences.

  • Reads data from two tabs in a Google Sheet for comparison.
  • Depends on gws-sheets skill and gws binary.
  • Compares tabular data row by row to detect changes.
  • Outputs a list of differences between the two tabs.

SKILL.md

.github/skills/recipe-compare-sheet-tabsView on GitHub ↗
---
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

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

More from googleworkspace/cli

SkillDescription
gws-admin-reportsGoogle Workspace Admin SDK: Audit logs and usage reports.
gws-calendarGoogle Calendar: Manage calendars and events.
gws-calendar-agendaGoogle Calendar: Show upcoming events across all calendars.
gws-calendar-insertGoogle Calendar: Create a new event.
gws-chatGoogle Chat: Manage Chat spaces and messages.
gws-chat-sendGoogle Chat: Send a message to a space.
gws-classroomGoogle Classroom: Manage classes, rosters, and coursework.
gws-docsRead and write Google Docs.
gws-docs-writeGoogle Docs: Append text to a document.
gws-driveGoogle Drive: Manage files, folders, and shared drives.