Automation: Auto-Generate Your Weekly Status Report

For Executive Assistants

Tools: Zapier + Asana + ChatGPT | Time to build: 2 hours | Difficulty: Intermediate-Advanced Prerequisites: Comfortable with Zapier basics — see Level 4 guide: "Email-to-Task Workflow for Action Item Capture"

What This Builds

Every Friday at 4pm, Zapier automatically pulls all tasks you completed that week from Asana, passes them to an AI that writes a structured status report, and emails it to your executive — all without you touching it. Instead of spending 45–60 minutes writing the weekly report, it arrives in your inbox ready to review and forward.

Prerequisites

• Zapier Starter plan or higher ($20/month — needed for multi-step Zaps)
• Asana account with tasks tracked throughout the week
• OpenAI API key (for the ChatGPT step in Zapier) — free tier works for testing; ~$0.01 per report
• Gmail or Outlook connected to Zapier

The Concept

A weekly status report is a repeating pattern: pull what was done, organize it by category, write it up in a consistent format. Patterns are exactly what automation handles well. You set up the recipe once; every Friday afternoon it runs and sends a draft for your quick review.

Build It Step by Step

Part 1: Set up Asana task tracking as your data source

Before building the automation, your task data needs to be usable. In Asana:

1. Create sections (or use tags) for task categories: "Calendar Management," "Communications," "Travel & Expenses," "Documents & Reports," "Events"
2. Throughout the week, make sure completed tasks are marked as complete (not just archived)
3. This discipline is what makes the automation possible — garbage in, garbage out

Part 2: Create the Zap — Scheduled trigger

1. In Zapier, click "Create Zap"
2. Choose Trigger: "Schedule by Zapier"
3. Set it to run: Weekly → Every Friday → 4:00 PM → Your timezone
4. This creates a Zap that fires automatically at 4pm every Friday

What you should see: A trigger step showing "Every Friday at 4:00 PM."

Part 3: Pull completed tasks from Asana

1. Add a step: "Asana" → Action: "Find Tasks"
2. Connect your Asana account
3. Set filter: Project = [your EA project], Completed = True, Completed Since = Last 7 days
4. This step pulls all tasks you completed in the past week

What you should see: A list of Asana tasks in the test output — task names, sections, completion dates.

Part 4: Format the task list for the AI

1. Add a step: "Formatter by Zapier" → "Text" → "Concatenate"
2. Map the task names from Step 3 into a single text field
3. This turns multiple task records into one block of text the AI can read

Part 5: Add the AI step to write the report

1. Add a step: "OpenAI" → "Send Prompt"
2. In the Prompt, write:

You are an Executive Assistant writing a weekly status report for your executive.

Here are the tasks completed this week:
[insert concatenated task list from Step 4]

Write a professional weekly status report with these sections:
1. Summary (2 sentences)
2. Key Accomplishments (bullet list, grouped by category if possible)
3. Ongoing Priorities (what will be focused on next week — infer from patterns)
4. Any notable items requiring executive attention

Keep it concise and professional. Write in first person as the EA.

What you should see: A well-formatted status report in the test output.

Part 6: Send the report by email

1. Add a final step: "Gmail" or "Outlook" → "Send Email"
2. Set To: yourself (for review) or your executive directly
3. Set Subject: "Weekly Status — Week of [formatted date]"
4. Set Body: [AI output from Step 5]
5. Publish the Zap

Real Example: Complete Workflow

Setup: Zap runs every Friday at 4pm, pulling Asana tasks from the past 7 days.

Input (from Asana): "Booked Chicago flights for March conference," "Sent board deck to 8 members," "Scheduled 4 vendor calls," "Prepared Q2 kickoff agenda," "Reconciled February expenses," "Updated contact database"

Output (AI-written email):

Subject: Weekly Status — Week of March 17

Summary: This week focused on Q2 planning logistics and executive
travel preparation. All priority items from last week's list are
complete.

Key Accomplishments:
• Travel: Booked all flights and hotel for Chicago conference
• Communications: Board deck distributed to all 8 members (48 hrs early)
• Scheduling: 4 vendor review calls scheduled for next week
• Finance: February expense reconciliation submitted
• Events: Q2 kickoff agenda prepared and distributed

Ongoing Priorities (Next Week):
• Support Chicago conference logistics on-site
• Follow up on vendor reviews once calls complete
• Prepare materials for Q2 board update

No items requiring executive attention this week.

Time saved: 45–60 minutes of writing, every week, forever.

What to Do When It Breaks

• No tasks appear in Step 3 → Check that tasks are actually marked complete in Asana (not just moved to "Done" column) and that the date filter is correct
• AI report is too short or generic → Add more detail to the prompt: "Each bullet point should be 1 sentence describing the result, not just the task name"
• Report arrives but format is wrong → Adjust the prompt instructions in Step 5 to specify the exact format you want
• Zap fails silently → Check Zap History in Zapier; set up error notifications in Zapier Settings

Variations

• Simpler version: Skip the AI step — use Formatter to assemble a bullet list of task names and email it as the weekly report (less polished, but takes 30 minutes to build)
• Extended version: Add a Slack message step that sends the report draft to your executive's Slack DM, so they can review it before the email version goes out

What to Do Next

• This week: Start being disciplined about marking Asana tasks as complete with accurate names
• This month: Build the basic version (no AI step) and verify the data flow works
• Advanced: Add a second weekly Zap for Monday morning that pulls next week's calendar and generates a "this week's priorities" briefing

Advanced guide for Executive Assistant professionals. Tool pricing and interfaces may change.