Update subtotal records hourly from shared sheet dataset
Update subtotal records hourly from shared sheet dataset
Your shared spreadsheet subtotal values can drift and leave datasets with outdated aggregates for analysis and reporting. Updated subtotals ensure reports and models use current data within an hour.
Overview
Stale subtotal values create friction for your data scientists and delay model runs; this flow pulls the latest subtotal from the shared sheet and updates the project table automatically. Teams get consistent aggregates without manual checks, and reports and models run on current data within an hour.