cotera

Google Docs Report Generator

Stop spending 45 minutes formatting the same report every week. Tell AI what you need and get a polished Google Doc with headers, sections, and tables.

Report generationStatus updatesDocumentationStructured writing

The Challenge

Weekly status reports, project updates, and meeting summaries all follow the same pattern: open a doc, write headers, fill in sections, format a table, and share. It's 45 minutes of structured writing that follows a template every single time — the kind of work that should be automated.

What This Prompt Does

Create Doc

Generates a new Google Doc with the right title and structure

Structure Content

Inserts headers, sections, and formatted text throughout

Add Tables

Builds data tables from structured inputs like metrics and action items

Format Output

Produces a polished, shareable document ready for distribution

The Prompt

The Prompt

Task

Create a structured Google Doc report based on the user's specification. Generate a new document with appropriate sections, headers, formatted text, and data tables, then return the document URL.

Input

The user will specify:

  1. The type of report (weekly update, project status, meeting summary, etc.)
  2. The content or data to include
  3. Any specific structure or template requirements

Example: "Create a weekly status report for the engineering team" or "Generate a project update doc with milestones and blockers"

Context

Strategy

  1. Determine the report type and appropriate structure:
    • Weekly Status Report: Summary, accomplishments, blockers, next week's plan
    • Project Update: Overview, milestones, timeline, risks, next steps
    • Meeting Summary: Attendees, agenda, discussion, decisions, action items
    • Custom: Follow the user's specified structure
  2. Use @Google Workspace/Docs - Create Document or @Google Workspace/Docs - Create Structured Document to create the document with the appropriate title
  3. Use @Google Workspace/Docs - Insert Text to add headers, sections, and formatted content
  4. Use @Google Workspace/Docs - Insert Table to build any data tables the user provides or that the report type requires
  5. Return the document URL to the user

Report Templates

Weekly Status Report:

  • Executive Summary (2-3 sentences)
  • Key Accomplishments (bulleted list)
  • Metrics / KPIs (table format)
  • Blockers & Risks
  • Plan for Next Week
  • Team Updates

Project Status Report:

  • Project Overview
  • Milestone Tracker (table: milestone, status, date)
  • Current Sprint Progress
  • Blockers & Dependencies
  • Budget / Resource Update
  • Next Steps & Timeline

Meeting Summary:

  • Meeting Info (date, attendees, duration)
  • Agenda Items Discussed
  • Key Decisions Made
  • Action Items (table: item, owner, due date)
  • Open Questions
  • Next Meeting Date

Formatting Guidelines

  • Use clear section headers for easy scanning
  • Keep bullet points concise (one line each)
  • Use tables for structured data (metrics, action items, milestones)
  • Include dates and owners wherever applicable

Output

A Google Docs document URL containing:

  • A properly structured report with all requested sections
  • Any data tables formatted and populated
  • Clear headers and consistent formatting throughout

Example Usage

Try asking:

  • →"Create a weekly status report for the engineering team"
  • →"Generate a project update doc with milestones and blockers"
  • →"Build a meeting summary document from these notes"