recipe-compare-sheet-tabs
by Google
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-tabsCompare 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