Compare Google Sheets tabs with AI
Read two ranges from one Google Sheets file and ask the agent to explain what changed. The supplied workflow leaves the source cells untouched.
To compare Google Sheets tabs with AI, tell the agent which column identifies the same item in both places. The recipe-compare-sheet-tabs skill reads each range separately. February’s row twelve may have nothing to do with January’s row twelve. An order number makes a better comparison key than the current position.
The skill retrieves each range separately. Matching and interpretation are left to the agent, so you can ask about a single field, missing entries or newly added records instead of accepting a fixed report format.
What it does
- Compare one field across two periods
- Identify keys present in only one tab
- Spot changed amounts for the same order
- Limit a comparison to selected columns
- Describe discrepancies without editing the sheet
Install and use
- Install the recipe, gws and the Sheets companion. Authorise a Google account with read access to the spreadsheet you want to compare.
- Specify the tab names and ranges. Try “Match these orders by order number and show only changes in amount.”
- Check ambiguous or duplicate keys against the original sheet.
FAQ
Source
Made by Google Workspace CLI contributors. Original skill: recipe-compare-sheet-tabs, published on GitHub under the Apache-2.0 licence.
View on GitHub