Savings & HOS Calculator: Dual-Branch Airtable Pipeline with Apps Script Scoring

Problem:

The platform's two headline numbers, documented owner savings and the Home Operating Score, were computed manually from scattered records, making them stale the moment new data landed.

Solution:

Built a webhook-triggered Make.com scenario with a two-branch Router. The savings branch gets the Property, searches Curated Savings, creates the savings record, sums them with a Numeric Aggregator, then reads Landscaping, Cleaning, and Water amounts from Google Sheets cells creating a categorized savings record for each before re-searching, aggregating the totals, updating the Property, and deleting superseded rows. The scoring branch sleeps, then batch-collects Maintenance Tasks, Findings, Reviews, and existing HOS Scores through repeated Search → Array Aggregator → JSON transform passes, creates the HOS Scores record, fires a Google Apps Script to run the scoring model, and writes results back to the Property — with a Skip error handler preventing partial-data failures from blocking the run.

Result:

Owner savings totals and Home Operating Scores now recalculate automatically on trigger across all data sources, keeping both metrics live without any manual computation.