Data Flow

How data moves through the platform

Ingest → Transform → Output
🔌
Connector
Query external API
→
📊
Google Sheets
Formulas compute business logic
INPUT FORMULA OUTPUT
→
🚀
Dispatcher
Export or push results
Spreadsheet Cell Map
Example structure — your template defines the actual columns
A-B
Dates
Labels Write
C-G
External
Data Write
H-S
Formulas
(Your Logic) Never Touch
T
Results Read
W
Config
Params Config
Example Use Cases
📊 Marketing Spend Forecast
Ingest: Google Ads → daily spend, conversions
Transform: Formulas calculate weighted forecasts
Output: Export daily budget recommendations
💰 Revenue Reconciliation
Ingest: Stripe → charges, refunds
Transform: Formulas match with accounting
Output: Discrepancy report, GL entries
📦 Inventory Planning
Ingest: Shopify → orders, stock levels
Transform: Formulas calculate reorder points
Output: Purchase orders, alerts
🎯 Lead Attribution
Ingest: HubSpot → contacts, deals
Transform: Formulas attribute revenue to sources
Output: ROI by channel, dashboard refresh
📈 Cross-Channel Marketing
Ingest: Google Ads + Meta Ads → all spend
Transform: Formulas consolidate, calculate blended ROAS
Output: Unified report, budget reallocation
👥 Sales Pipeline
Ingest: Salesforce → opportunities, stages
Transform: Formulas weight by probability
Output: Forecast report, Google Chat notifications
INPUT — App writes data here
FORMULA — Your business logic (never touched)
OUTPUT — App reads results here
CONFIG — User parameters