Consultation Meeting Processor v0.15

Pick a consultation event, upload the audio or a text transcript, get a transcript, structured summary, suggested kit from your spreadsheet template, and a proposal draft.
Frazer · AVD TOOLS
Step 1 – Select consultation from Google Calendar
Step 1 Progress
Pending
Sign in and load events.
Workbook/proposal files are tied to the selected event.
Progress last saved: none
Status: Waiting for sign-in…
Same OAuth flow as the other tools.
Advanced date range (override last 3 months)
By default the tool loads events from the last 3 months plus today. Override the date range here if needed.
Both dates required. Clear override to return to the automatic last-3-months window.
Step 2 – Upload consultation audio & process
Step 2 Progress
Pending
Transcribe and summarise.
Export from DJI Mic / Voice Memos first, or upload a .txt transcript. Audio is converted to WAV in-browser for Whisper where possible. Whisper supports files up to ~25 MB per request; larger recordings will be split into chunks automatically.
Auto mode detects text files and common DJI/iPhone filename patterns.
If this box is non-empty, the tool will skip audio transcription and use the pasted text as the transcript.
Transcription progress: 0%
Uses your OpenAI key stored in this browser (see “API key” panel below).
Show full transcript
No transcript yet.

Consultation summary

No summary yet.

Key issues

Current equipment

Agreed / preferred solution

Debug view (structured AI JSON from transcript)
Editable. Changes here will be included in exported reports.

        
Step 3 – Populate your spreadsheet template (Guided + Products → Checklists)
Step 3 Progress
Pending
Populate Checklists.
The tool reads your latest uploaded template from Settings by default, or a local file selected in Settings.
Spreadsheet logic: Products (A3:H500 headers on row 3, data rows A4:H500) and Guided (frequent kit), then writes the chosen Product (col C) and Qty (col G) into the existing Checklists sheet (and uses MISC from row 278 for anything not in your Products list). It does not overwrite formula columns.
Default OFF (Be Strict). If OFF, unlisted items go into MISC with name + qty + justification, but price/link stay blank.
Workbook file: none saved for this event.
Category is guidance only — it must never block cross-category dependencies (e.g. routers for mixers).
Exact mode: read-only.
Fast preview source: none (select an event).
No products suggested yet.
Step 4 – Proposal generator (from priced spreadsheet)
Step 4 Progress
Pending
Generate proposal draft.
Step 4 first uses the event workbook saved on server (including OnlyOffice edits), then falls back to in-page Step 3 workbook. If unavailable, it pulls your latest uploaded priced sheet from Settings (or local file selected in Settings).
Outlook send: not started.
Client portal: not published.
Proposal file: none saved for this event.
Proposal source: unknown (run Step 4).
Proposal text includes non-empty checklist sections only, with product + quantity + generated notes, then sell price and labour estimate per section.
Fast preview is an approximate HTML render. Exact preview and PDF export use the saved OnlyOffice proposal document.
Detected non-empty checklist sections: (run proposal to detect)
Fast preview source: none (select an event).
Exact mode: read-only.
No proposal generated yet.

CMP Settings

Spreadsheet sources (template + priced) – hidden by default
Upload template and priced sheets here. Step 3 and Step 4 will use the latest server uploads when no local file is selected.
Template spreadsheet (Step 3)
Server template: checking…
Proposal generator spreadsheet (Step 4)
Import a spreadsheet for Proposal Generator and optionally save it to the selected event.
Proposal spreadsheet: none imported.
Priced spreadsheet (Step 4 fallback)
Server priced sheet: checking…
Proposal template (Step 4 output style)
Proposal template: checking…
Tool info (advanced)
Tool name
Consultation Meeting Processor
Version
v0.15
Last updated
2026-01-27 16:01:17
Tool code
CONSULT-MEET
Excalidraw flow
Generate the CMP flow diagram or save edits back through the MCP toolchain.
No diagram created yet.
No saved scenes yet.
API key (OpenAI) – hidden by default
OpenAI access is managed by token-authority. No API keys are stored in the browser.
Outlook send settings (Microsoft Graph)
Outlook app settings are managed by the server for all devices.
No user setup required. If unavailable, contact admin to configure CMP Outlook integration.
Outlook settings not saved yet.
Debug panel
Proposal debug: no runs captured yet.
(no proposal debug run yet)
(empty)
AI Debugger (Be Strict)
Sends the full current index.html, internal debug log, structured AI JSON, captured browser errors, and captured console output to the 5.1 model. Use the box below to describe what you think isn’t working (and optionally paste extra console output).
AI Debugger progress: 0%
Problem description (what you expected vs what happened) + optional pasted console:
AI Debugger output (summary, reasons, and outline of changes):

          
Codex prompt (from AI Debugger)
Paste this prompt into Codex to implement the AI Debugger’s recommended fixes.
(none yet)
Calendar / advanced (Calendar ID)
Usually this is your shared AVD consultations calendar. Same one you use in the other tools.
Change only if you know what you’re doing. The tool will use this for loading recent events.