Data 1,678 installs

Compare Two Google Sheets Tabs

by googleworkspace/cli

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

Skill content

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

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