recipe-compare-sheet-tabs

작성자: Google

구글 시트의 두 탭에서 데이터를 읽어 비교하고 차이점을 식별합니다.

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

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