recipe-compare-sheet-tabs▌
googleworkspace/cli · updated Apr 8, 2026
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
1c:["$","div",null,{"className":"prose prose-invert max-w-none prose-headings:font-semibold prose-headings:tracking-tight prose-h1:text-4xl prose-h1:mb-2 prose-h2:text-2xl prose-h2:mb-2 prose-h3:text-lg prose-h3:mb-2 prose-p:text-muted-foreground prose-li:text-muted-foreground prose-code:bg-muted prose-code:text-foreground prose-code:px-1 prose-code:py-0.5 prose-code:rounded-sm prose-code:text-sm prose-code:before:content-none prose-code:after:content-none prose-pre:bg-muted prose-pre:text-foreground prose-pre:border prose-pre:border-border prose-pre:rounded-md [&_table]:!border-[color:var(--border)] [&_th]:!border-[color:var(--border)] [&_td]:!border-[color:var(--border)]","dangerouslySetInnerHTML":{"__html":"<p><strong>Compare data across two Google Sheets tabs to identify differences.</strong></p>\n<ul>\n<li>Reads data from two separate sheet tabs using the <code>gws-sheets</code> skill</li>\n<li>Requires the Google Workspace (<code>gws</code>) bin and <code>gws-sheets</code> skill as prerequisites</li>\n<li>Follows a three-step workflow: read first tab, read second tab, then compare and report changes</li>\n<li>Supports flexible range selection (e.g., <code>January!A1:D</code>, <code>February!A1:D</code>) for targeted data extraction</li>\n</ul>"}}] 1d:["$","div",null,{"className":"prose prose-invert max-w-none prose-headings:font-semibold prose-headings:tracking-tight prose-h1:text-4xl prose-h1:mb-2 prose-h2:text-2xl prose-h2:mb-2 prose-h3:text-lg prose-h3:mb-2 prose-p:text-muted-foreground prose-li:text-muted-foreground prose-code:bg-muted prose-code:text-foreground prose-code:px-1 prose-code:py-0.5 prose-code:rounded-sm prose-code:text-sm prose-code:before:content-none prose-code:after:content-none prose-pre:bg-muted prose-pre:text-foreground prose-pre:border prose-pre:border-border prose-pre:rounded-md [&_table]:!border-[color:var(--border)] [&_th]:!border-[color:var(--border)] [&_td]:!border-[color:var(--border)]","dangerouslySetInnerHTML":{"__html":"<h1>Compare Two Google Sheets Tabs</h1>\n<blockquote>\n<p><strong>PREREQUISITE:</strong> Load the following skills to execute this recipe: <code>gws-sheets</code></p>\n</blockquote>\n<p>Read data from two tabs in a Google Sheet to compare and identify differences.</p>\n<h2>Steps</h2>\n<ol>\n<li>Read the first tab: <code>gws sheets +read --spreadsheet SHEET_ID --range "January!A1:D"</code></li>\n<li>Read the second tab: <code>gws sheets +read --spreadsheet SHEET_ID --range "February!A1:D"</code></li>\n<li>Compare the data and identify changes</li>\n</ol>"}}] 18:[["$","meta","0",{"charSet":"utf-8"}],["$","meta","1",{"name":"viewport","content":"width=device-width, initial-scale=1"}]] 16:null