FINANCE
Allocate Cloud Spend to Accounts and Write to BigQuery
Nightly pulls Vercel project-level spend, maps each project to the customer accounts it serves, allocates cost proportionally by usage.
How it runs
The automated pipeline, trigger to output.
- TriggerNightly schedule
- ActionPull project-level Vercel spendVercel
- ActionQuery per-account usage signalsBigQuery
- LogicAllocate cost by usage share
- OutputWrite per-account cost table to BigQueryBigQuery
What it does
Builds the foundational data layer for unit economics: a per-account cost-of-service table. It pulls infra spend at the project level, splits each project's cost across the accounts that consume it using a usage weight, and persists the allocation so any dashboard or report can join revenue to true cost.
When to use it
Use it when you've outgrown a single blended margin number and need cost attributed down to the account or cohort level — for example to find unprofitable accounts or price new tiers. This is the ETL job that powers the other margin workflows.
How it works
- 1A nightly schedule trigger starts the run.
- 2Pull project-level spend from Vercel for the prior day.
- 3Query BigQuery for each account's usage signal (requests, compute seconds) per project.
- 4A compute step allocates each project's cost across accounts by usage share.
- 5Write the resulting per-account cost-of-service rows back into a BigQuery table, partitioned by date.
Set it up
What you configure once, before turning it on.
- 1Connect VercelDeploys, runtime logs, analytics.
- 2Connect BigQueryDatasets, queries, schemas.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Finance workflows
Expense Submission Webhook Instant Triage and Routing
Receives each expense submission via webhook the instant it's filed, classifies it as in-policy, needs-review, or hard-violation, and routes it to auto-approval.
Monthly Vendor Spend Anomaly Brief for Finance Leads
Once a month, an agent analyzes the full expense ledger for vendor and category spend anomalies, drafts a narrative brief with the top outliers and likely causes.
Accrual Chase Board in Monday with Per-Owner Tasks
On a schedule it reads open uncoded expenses from Snowflake and creates or updates a Monday item per department owner.
Detect Annual-to-Monthly Downgrade Refunds Owed
Catches subscriptions switched from an annual term to monthly partway through the prepaid year, computes the unused prepaid balance owed back.
Detect Mid-Cycle Plan Change Mischarges and Queue Credit Memos
Listens for Stripe subscription plan changes, recomputes the correct prorated amount.
Overdue Accrual Escalation Emails to Owners and Managers
On a schedule it flags uncoded spend that has stayed open past the chase deadline and emails each delinquent owner via Gmail.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.