数据与研究

recipe-compare-sheet-tabs

Name: recipe-compare-sheet-tabs
Author: googleworkspace

googleworkspace/cli

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

安装命令

$ npx skills add https://github.com/googleworkspace/cli --skill recipe-compare-sheet-tabs

要点

Compare data across two Google Sheets tabs to identify differences.

Reads data from two separate sheet tabs using the gws-sheets skill
Requires the Google Workspace (gws) bin and gws-sheets skill 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

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.

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