← All use cases

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.

Intermediate
1h

Related links

Skills & Plugins

  • Spreadsheets
    Joins and validates the exports, then builds the workbook, formulas, and charts ($spreadsheets).
  • Google Drive
    Reads the source files and reporting templates kept in Drive.
  • Documents
    Records assumptions and refresh steps ($documents).

Starter prompt

Combine the three CSV exports in my Drive folder (orders, accounts, and regional targets) into one workbook, joining on account_id. Add a summary tab with charts for revenue by segment and attainment against target, plus a tab listing every record that failed to join and why. Write down your assumptions and the steps to refresh it next month, and don't modify the original files.

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