recipe-compare-sheet-tabs
Installation
Summary
Compare data across two Google Sheets tabs to identify differences.
- Reads data from two separate sheet tabs using the
gws-sheetsskill - Requires the Google Workspace (
gws) bin andgws-sheetsskill as prerequisites - Follows a three-step workflow: read first tab, read second tab, then compare and report changes
- Supports flexible range selection (e.g.,
January!A1:D,February!A1:D) for targeted data extraction
SKILL.md
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
Related skills
More from googleworkspace/cli
gws-gmail
Gmail: Send, read, and manage email.
26.1Kgws-docs
Read and write Google Docs.
26.0Kgws-drive
Google Drive: Manage files, folders, and shared drives.
26.0Kgws-sheets
Google Sheets: Read and write spreadsheets.
24.6Kgws-calendar
Google Calendar: Manage calendars and events.
24.6Kgws-docs-write
Google Docs: Append text to a document.
21.8K