SheetFlow

Google Sheets Orchestration Platform

Daily Operations Flow

Morning (6-8 AM)
🌅
Morning Flow
Archive yesterday's data, calculate real spend vs forecast
⚡
Morning Setup
Refresh SDLY, write today's forecast to L52W
Hourly (9 AM - 6 PM)
🔄
Hourly Update
Fetch current spend, update SDLY pacing
🎯
Adjustment Detector
Analyze pacing, recommend PUSH/PULL/HOLD
📝
Log Bid Change
Record decision to Historical Log
On-Demand
📊
BSP Calculator
L30D bid strategy performance analysis
📈
Weekly Pulse
GA4 traffic + Google Ads weekly summary

Connected Spreadsheets

📗
L52W Budget Tracker
Daily spend forecasting & pacing
📘
BSP Adjustment Calculator
Bid strategy target ROAS optimization

API Endpoints

# Morning Operations
POST /api/morning-flow
POST /api/morning-setup
# Hourly Updates
POST /api/hourly-update
GET /api/adjustment-detector
POST /api/log-bid-change
# BSP Calculator
GET /api/bsp-refresh
POST /api/bsp-refresh
# Weekly Report
POST /api/weekly-pulse