What does this flow do?

Usage-Billing Reconciler Scheduled + On-Demand Runs weekly and on-demand before invoicing. Queries BigQuery for actual consent volumes and enrichment usage per customer. Compares against contracted/bi

About this item

Usage-Billing Reconciler Scheduled + On-Demand Runs weekly and on-demand before invoicing. Queries BigQuery for actual consent volumes and enrichment usage per customer. Compares against contracted/billed amounts. Flags: under-billing (revenue leakage), over-billing (customer complaints), and customers approaching their next tier threshold. Google BigQuery Billing System / HubSpot Slack Cron (Wednesday) Weekly Cron (Wed) + on-demand BigQuery: actual usage per customer Pull contracted/billed amounts Compare + flag discrepancies >5% Post to #finance-ops Acceptance Criteria: Weekly report comparing BigQuery usage vs. billing for all active customers Flags: under-billed (>5% gap), over-billed, approaching next tier (>80% of current) Separate sections for consent volumes and enrichment volumes Calculates estimated revenue impact per discrepancy On-demand run via Slack command before invoice cycles

How to use this

Add to Library

Click 'Use Workflow' to add this automation to your library.

Customize Steps

Customize the workflow steps to match your specific business process.

Assign to Agent

Assign this workflow to an AI employee to execute automatically.

Automate

Trigger the workflow manually or set up automated triggers based on events.

Usage-Billing Reconciler (BigQuery)