Automated Weekly Status Reports: Connect Your Project Management Tool to AI

What This Builds

Instead of spending 1-2 hours every week per client pulling project status from Asana or Monday.com and formatting it into a status report, this automation does it for you: every Monday morning, it pulls your open tasks organized by client, sends them through AI for formatting, and delivers a polished draft status report to your email inbox, ready to review and send within 15 minutes.

Prerequisites

• Comfortable using ChatGPT or Claude for document drafting (Level 3)
• A Zapier account (free starter or $19.99/month for multi-step automations)
• An Asana, Monday.com, or Trello account your team actually uses for project tracking
• An OpenAI account with API access ($0.01-0.10 per report using GPT-4o-mini)

The Concept

A Zapier workflow is like a series of dominoes set up in advance. When one thing happens, it triggers the next automatically. In this case: Monday morning arrives (trigger) → Zapier pulls your task list from Asana (action 1) → formats the tasks into a status report prompt (action 2) → sends to OpenAI to write the narrative (action 3) → emails the draft to you (action 4).

The total AI writing cost per report is typically $0.02-0.05, cheaper than 2 minutes of your time.

Build It Step by Step

Part 1: Set up your Zapier account and understand the interface

1. Go to zapier.com → create a free account (5 free Zaps; multi-step automation requires Starter plan at $19.99/month)
2. Click "Create Zap" (orange button, top left)
3. The Zap editor shows two main areas: Trigger (what starts the Zap) and Actions (what happens next)
4. Each step in the Zap connects an app and defines what information passes to the next step

Part 2: Build the trigger: schedule every Monday morning

1. Click "Trigger" → search for "Schedule by Zapier" → select it
2. Choose "Every Week" as the trigger event
3. Configure: Day of week → Monday; Time → 8:00 AM in your timezone
4. Click Continue. Zapier will test the trigger (it just confirms the schedule).

What you should see: A green checkmark confirming the schedule trigger is set up. Zapier will now fire this Zap every Monday at 8am.

Part 3: Pull tasks from Asana

1. Click + to add a new step → search for "Asana" → select the "Find Tasks" action
2. Connect your Asana account if not already connected (authorize Zapier to access Asana)
3. Configure the search:

   • Project: Select your client's Asana project (or "All Projects" if you want multi-client in one report)
   • Completed since: Set to "7 days ago" so you're capturing the past week's completed + in-progress tasks
   • Filter by assignee: Optional. Filter to your tasks only, or all team tasks for that client.
4. Test this step. Zapier will pull real tasks from your Asana and show you what data comes through.
5. Important: Note what fields come through. You'll need Task Name, Status, Due Date, and Assignee.

Troubleshooting: If "Find Tasks" returns too many tasks, add a Project filter to limit to one client project at a time. Build a separate Zap for each client if needed.

Part 4: Format tasks into a status report prompt

1. Add another step → search for "Formatter by Zapier" → choose "Text" → "Replace" action
2. This step lets you assemble the task data into a formatted prompt string
3. In the "Input" field, build your prompt using Asana task data fields:

Write a professional weekly status report for [Client Name] covering these projects and tasks:

[Insert Task Name fields from Asana, each on a new line with their status]

Format: For each major project area, write: Status (one word), What happened this week (1-2 sentences), What's next (1-2 sentences), Open items requiring client input (if any).

Keep it client-ready: professional tone, concise, no internal jargon.

The Zapier "Insert Data" function lets you pull the Asana task fields into the prompt automatically.

Part 5: Send to OpenAI and get the report

1. Add another step → search for "OpenAI (ChatGPT)" → select "Send Prompt" action
2. Connect your OpenAI account (you'll need an OpenAI API key from platform.openai.com; create one under "API Keys")
3. Configure:

   • Model: gpt-4o-mini (fast and cheap, ~$0.03 per report)
   • Prompt: Select the formatted prompt from your Formatter step
   • Max Tokens: 800 (enough for a 2-3 project status report)
4. Test. Zapier will send your test prompt to OpenAI and return the AI-generated report text.

Part 6: Deliver the report draft to your inbox

1. Add a final step → search for "Email by Zapier" (or Gmail/Outlook) → "Send Email" action
2. Configure:

   • To: your email address
   • Subject: "Weekly Status Draft: [Client Name], [date]"
   • Body: Select the OpenAI response text from the previous step
3. Test the full Zap. You'll receive an email with the AI-generated draft status report.
4. Turn the Zap ON

Real Example: Dental Studio Client

Setup: Connected Asana project "Dental Studio Campaign Q2" → Zap pulls tasks each Monday

Input (auto-pulled from Asana):

• Social Content Creation: In Progress (due 3/25, assigned to Jenny)
• Client Review Call Prep: Complete (completed 3/18)
• Budget Reconciliation: Not Started (due 3/28)
• OTT Video Asset Delivery: Blocked (waiting on client footage)

Output (AI-generated, delivered Monday 8:15am): "Social Content Creation (In Progress): The team is currently developing Q2 social assets targeting dental anxiety audiences. Final concepts are due for internal review on March 25 before client presentation. Client Review Call Prep (Complete): This week's prep materials are finalized and distributed. Budget Reconciliation (Coming Up): Q2 budget reconciliation is scheduled for completion by March 28, no client action needed at this time. OTT Video (Blocked): Production is on hold pending receipt of client-supplied footage. Please confirm the footage delivery timeline so we can update the production schedule."

Time saved: 45-90 minutes per client per week → 15-minute review

What to Do When It Breaks

• Asana connection drops → re-authenticate in Zapier (Asana settings → connected apps); this happens every 6-12 months
• OpenAI returns an error → usually a rate limit or API key issue; check your OpenAI usage dashboard and billing
• Report covers the wrong tasks → tighten the Asana filter (add Project filter, date range, or assignee filter)
• Report misidentifies project status → your task naming in Asana may be unclear; standardize task status labels (Not Started / In Progress / Blocked / Complete) for cleaner AI output

Variations

• Simpler version: Skip the automation and just manually paste your Asana task export into ChatGPT each Monday morning. 80% of the time saving, 0% of the setup.
• Extended version: Add a step that sends the draft to a shared Slack channel for team review before emailing to client; or chain multiple clients' reports in one Zap using a loop

What to Do Next

• This week: Test the Zap manually (using Zapier's "Run Zap" button) before turning on the schedule. Verify the output quality.
• This month: Refine the prompt based on the first 4 weeks of real output; adjust the Asana filters if the report is too long or too short
• Advanced: Connect multiple client Asana projects; build one Zap per client; set up a Friday afternoon version for weekly wrap-up notes

Advanced guide for advertising agency account manager professionals. This automation requires an OpenAI API account with usage-based billing (typically $1-5/month for typical AM usage).