Consolidate spreadsheets
Merge spreadsheet exports into a single refreshable workbook.
Provide your spreadsheet exports along with the join keys, any targets, how segments are defined, and the reporting rules. ZeroTwo then assembles one combined workbook featuring cleaned joins, charts, takeaways, stated assumptions, refresh steps, and a list of mismatches to review.
Related links
Skills & Plugins
- SpreadsheetsJoins and validates the exports, then builds the workbook, formulas, and charts (
$spreadsheets). - Google DriveReads the source files and reporting templates kept in Drive.
- DocumentsRecords assumptions and refresh steps (
$documents).
Starter prompt
Establish the join and reporting rules
Fix the key, field definitions, targets and duplicate rule up front, and make ZeroTwo surface non-matching records rather than guess. Inspect formulas and mismatches, and rerun checks after any change.
Validate the refresh path
Ask ZeroTwo to walk through the next refresh by hand. The workbook is a file, so refreshing means replacing the inputs and re-running the documented steps.
Test the refresh: report what updates cleanly, mismatched keys, undocumented assumptions and rows needing manual review.
Related use cases
Analyze KPI root causes
Account for a surprising shift in a metric, backed by evidence and follow-up steps.
Analyze product feedback across tools
Cluster feedback from Slack threads, issue queues, and survey exports into themes with clear next steps.
Build a dashboard that stays up to date
Build a private dashboard from your data that refreshes itself.


