AI Response Report

Goal: Summarize multiple form responses with AI into a stakeholder-ready report. Fields: Respondent email address, Response body, and Score. Extract theme, sentiment, importance, and next action for each response. Rules: Treat high-importance and low-score responses individually, and aggregate the rest by theme. Actions: Confirm the target form and scope, then use the AI client to produce per-response summaries, theme totals, risks, and recommended actions. Save through Google Sheets MCP and add ai_report_created only after a successful write. Do not fill gaps with unseen responses or data from other forms. Execution: Run this reusable prompt in an AI chat connected to FORMLOVA. Pasting it does not start continuous monitoring or recurring execution. Only settings saved and verified through actual tools run automatically. Request missing targets, dates, or evidence instead of inventing them. Records: update_response accepts only new / in_progress / resolved / spam for status. Use status="in_progress" for new open work; do not reopen existing resolved/spam responses, and use resolved only when the work is verified complete. Immediately before changing business tags or notes, read their current values with search_responses. Pass the deduplicated full set of existing plus added tags (at most 20 tags, 50 characters each), or the full existing notes with the addition appended. If current values cannot be read or limits would be exceeded, ask instead of overwriting. Keep schedules and drafts separate from verified sends, writes, and attendance. External connections: Separate Google Sheets MCP connections and write access to the specified destinations are required. If the connected MCP lacks a required operation, stop at a draft or review note. External service terms are separate from the FORMLOVA plan.