How to Automate a Quarterly Business Review (QBR) Using Paradime and OpenClaw

Introduction

Automating a Quarterly Business Review (QBR) involves two core capabilities: (1) transforming, scheduling, and monitoring analytics data pipelines, and (2) orchestrating AI-driven tasks like data summarization, document generation, and delivery. Paradime and OpenClaw can be combined to build an end-to-end automated QBR workflow.

What Is Paradime?

Paradime is an all-in-one AI platform that replaces dbt Cloud™. It provides a dbt™-native workspace for analytics teams to code, ship, fix, and scale data pipelines for analytics and AI. Key components include:

• Code IDE (DinoAI): AI-native IDE that cuts dbt™ and Python development time by 83%+, with inline data samples, lineage, and AI-assisted code writing.

• Bolt: A scheduler purpose-built for dbt™ and Python pipelines, supporting cron-based scheduling, CI/CD (TurboCI), deferred schedules, and API triggers. Bolt also features AI-powered debugging (DinoAI) for failed production runs.

• Radar: FinOps tool for Snowflake/BigQuery cost optimization.

• Monitoring & Alerts: Anomaly detection (via Elementary integration), Slack/email/PagerDuty notifications, and SLA tracking.

What Is OpenClaw?

OpenClaw is an open-source AI agent that runs locally on your hardware and orchestrates tasks across chat apps, files, the web, and your operating system. It connects to LLMs (like Claude or GPT) via API and uses plugins/skills to act. Key capabilities:

• Cron Jobs: Built-in scheduler for recurring AI agent tasks with cron expressions, timezone support, and retry policies.

• Skills & Plugins: Extensible system for integrating with Google Workspace (Sheets, Docs, Gmail, Calendar), Slack, and other tools.

• Secrets Management: SecretRef system supporting env vars, file-based secrets, and exec providers (1Password, Vault, sops).

• Multi-Channel Delivery: Output to WhatsApp, Telegram, Slack, Discord, email, and more.

Architecture for an Automated QBR

Step 1: Data Transformation with Paradime (dbt™ + Bolt)

Use Paradime's Bolt to schedule dbt™ models that aggregate quarterly metrics:

paradime_schedules.yml (in your dbt project root):

Environment variables for warehouse credentials are configured in Paradime Settings → Workspaces → Environment Variables → Bolt Schedules section. Sensitive values (API keys, DB passwords) are stored there and accessed in Python scripts via os.environ['KEY'].

Step 2: Python Scripts in Bolt for Data Export

Paradime Bolt supports Python scripts in scheduled pipelines. Use Poetry for dependency management:

This schedule triggers after the dbt models succeed, running a Python script that queries the warehouse and writes results to Google Sheets using the Google Sheets API.

Step 3: OpenClaw Cron Job for AI-Powered QBR Generation

Set up an OpenClaw cron job to generate the QBR document:

OpenClaw Configuration (~/.openclaw/openclaw.json):

Secrets are managed via SecretRefs:

Step 4: Google Workspace Integration via GOG Skill

Install the GOG skill for Google Workspace access:

1. Set up a Google Cloud project with Sheets API, Docs API, and Drive API enabled.

2. Create OAuth 2.0 credentials.

3. Install the GOG skill: openclaw skills install gog

4. Authenticate: gog auth login

This gives OpenClaw's agent read/write access to Google Sheets (for reading QBR data) and Google Docs (for creating the QBR document).

Monitoring & Troubleshooting

Paradime Side:

• Monitor Bolt schedule runs in the Bolt UI dashboard.

• DinoAI provides AI-powered debugging for failed dbt runs, suggesting fixes directly.

• Set up SLA alerts and PagerDuty/Datadog integrations for critical pipeline failures.

OpenClaw Side:

• Check cron job status: openclaw cron list and openclaw cron runs

• View logs: openclaw logs --follow

• Run diagnostics: openclaw doctor and openclaw status --all

• Common issues: Ensure cron is enabled, verify API key scopes, check channel connectivity with openclaw channels status --probe.

Summary

This architecture combines Paradime's robust dbt™ orchestration with OpenClaw's AI agent capabilities to fully automate the QBR lifecycle—from raw data transformation through polished document delivery.