[Actual] WBR — sheet contract (weekly actuals)

Spreadsheet: Brainforge GTM Review
Tab: [Actual] WBR
MCP: Google Workspace; user_google_email per .cursor/rules/google-workspace-mcp-user-email.mdc.


Header layout (rows 1–6)

RowContent
1Title (GTM Weekly Business Review)
3Period in B; week indexes 1…52 from C rightward
4Month anchors (e.g. 1/1/26, 2/1/26) under period columns
5Date in B; each week column is labeled with the Monday that starts that reporting week (e.g. 1/5/26, 1/12/26, … 3/30/26, 4/6/26, …)
6Blank separator
7+A = owner / role (when set); B = metric label (hierarchy via indentation in text); C… = values per week

Resolving the week column

  1. Read '[Actual] WBR'!A1:BC6 (or at least row 5 through the last used column).
  2. In row 5, find the column whose header equals the target Monday in the same M/D/YY style as the sheet (e.g. 4/6/26).
  3. That column letter is the write target for that week.

Example (verified 2026): Header 4/6/26 → column P. The prior week is 3/30/26 → column O.
If the business week “3/31–4/6” is reported under the Monday 4/6 column, use 4/6/26 / column P.

Row semantics

  • Targets (e.g. “Target Meetings Booked”) — usually do not overwrite with automation unless explicitly requested; confirm in wbr-metric-source-map.
  • % Growth and similar — often formulas; do not overwrite unless the spec says they are manual.
  • Owner in column A (e.g. Rico, Robert, Hannah) — informational; not used as the metric key (use B text as the key).

Known sheet issues

  • Occasional 0! in metric cells (e.g. reported for N82) — skip or fix upstream formulas; do not assume automation can write those cells without human review.