Also in This Week's Premium Deep Dives

→ GPT-5.4 Native Computer Use: 5 Automation Workflows

→ Microsoft 365 E7 Frontier Suite: Deployment Playbook

→ Pro Tip: Automate Browser Workflows with GPT-5.4


💎 PRODUCTIVITY GEM March 11, 2026

Connect Outlook, Teams, Excel, and SharePoint for automated executive summaries every Friday

By Pierre Bradshaw | PromptHacker Premium

What you'll learn:

Microsoft's Copilot Cowork (introduced in Wave 3) is an agentic AI system that connects across your Microsoft 365 applications. Unlike standalone Copilot features that work within individual apps, Cowork operates across applications, pulling data from Outlook, Teams, Excel, SharePoint, and OneDrive simultaneously. For executive reporting, this means you no longer manually gather data from multiple sources.

The practical impact is significant. Most executives and business operators spend 1-2 hours weekly compiling reports: reading email summaries, scrolling through Teams channels, copying numbers from spreadsheets, and pulling updates from shared documents. Cowork automates this entire process, generating a formatted report in minutes.

The reports are not generic summaries. They reflect the specific metrics, objectives, and stakeholders relevant to your business. Cowork learns what matters to you based on the data sources you provide and the format you prefer.

First, verify you have the required Microsoft 365 subscription. Copilot Cowork is available with E5 or E7 licensing, which includes Copilot Pro access. If your organization doesn't have these licenses yet, contact your Microsoft account manager about Wave 3 availability in your region.

Once confirmed, enable Cowork in your Microsoft 365 admin center. Go to Settings > Copilot > Wave 3 Features and enable Copilot Cowork. You'll see new Cowork options in Outlook, Teams, and SharePoint within 24 hours.

In Outlook, you'll see a new "Cowork Insights" panel on the right side of your screen. In Teams, look for a "Cowork" tab in your team channels. In SharePoint, the Cowork option appears in document libraries.

For weekly report generation, the main workflow happens in Outlook. Open Outlook and navigate to Cowork Insights. Select "Create a Report" and choose "Weekly Executive Summary" from the template options.

Ready to transform artificial intelligence from a buzzword into your personal revenue generator

HubSpot’s groundbreaking guide "200+ AI-Powered Income Ideas" is your gateway to financial innovation in the digital age.

Inside you'll discover:

Download your guide today and unlock a future where artificial intelligence powers your success. Your next income stream is waiting.

Get Your Guide

The next step is telling Cowork which data to pull. You'll see checkboxes for each available source: email, Teams channels, Excel files, and SharePoint documents.

For email, Cowork asks which mailboxes or folders to include. Most operators set this to "Inbox and Sent" for a specific time range. You can also specify which senders are most important if you want to prioritize executive communications or customer emails.

For Teams, select which channels should contribute to the report. If you have a "Metrics" channel where people post weekly updates, include it. If you have a "Wins" channel for celebrating closed deals, include it. Exclude general conversation channels that don't contain actionable data.

For Excel, link to specific workbooks and ranges that contain your key metrics. For example, if you maintain a sales pipeline spreadsheet with this week's deal closures, link to that. If you track customer satisfaction scores, link to that range. Cowork can extract current values and calculate week-over-week changes.

For SharePoint, select specific document libraries or folders. If your team maintains project status documents, link to those folders. If you have a "Weekly Updates" library where team leads post their summaries, link there.

Cowork displays the connected sources in a clear list. You can add or remove sources at any time, and future reports automatically use the updated configuration.

After selecting data sources, configure what your report looks like. Cowork offers pre-built templates: Executive Summary (short bullet points), Detailed Report (with sections and subsections), Dashboard Style (mostly metrics and charts), and Custom Format.

For most operators, Executive Summary works best. It produces a one-page overview with key metrics, highlights, and action items. The format is clean and suitable for sharing with executives or boards.

If you want something more detailed, Detailed Report includes sections for each team or functional area, with narrative summaries and supporting metrics. This works better if you're reporting on multiple departments.

The Custom Format option lets you specify exactly what sections appear, in what order, and with what level of detail. You write a template in plain text, and Cowork fills in the template with data from your sources. For example:

WEEKLY EXECUTIVE REPORT

Week Ending: [DATE]

Key Metrics:

- Revenue: $[TOTAL_REVENUE_RANGE_FROM_EXCEL]

- Customer Satisfaction: [AVERAGE_FROM_EXCEL]

- Open Deals: [COUNT_FROM_SALES_PIPELINE]

Team Highlights:

- Sales: [SUMMARY_FROM_TEAMS_SALES_CHANNEL]

- Operations: [SUMMARY_FROM_TEAMS_OPS_CHANNEL]

Issues and Blockers:

[EXTRACT_FROM_EMAIL_FLAGGED_ITEMS]

Cowork interprets the template, finds the corresponding data, and fills it in. The resulting report is formatted according to your template exactly.

To run reports automatically every week, use the Scheduling option in Cowork. Select "Recurring Report" and set the frequency to "Weekly" and the day to Friday at a specific time (most operators choose 6 AM Friday so the report is ready by the time the workday starts).

Cowork automatically generates the report at that time using the latest data from all connected sources. The report is sent to you via email and saved to a designated SharePoint folder so it's accessible to your team.

You can set up multiple recurring reports with different configurations. For example, you might have a broad executive report that pulls from all sources and goes to the C-suite, plus a more detailed operational report that goes to department heads.

The difference in time investment is stark when you actually track it.

Before/After Workflow Comparison

The old process required reading and copying from five different applications. Multiple context switches. Manual organization of disparate data. The new process with Cowork is fully automated. Data is automatically current because it pulls from live sources. Formatting is consistent because the template applies the same structure every time. Distribution is automatic because Cowork emails the report on schedule.

For a business operator spending 1.5 hours weekly on this task, reclaiming that time is worth approximately 78 hours annually. That time redirects to strategy, analysis, and decisions that benefit from human judgment.

One concern operators raise is whether automated reports might pull incorrect or outdated data. The answer depends on how consistently your team updates data sources.

Cowork pulls the most recent data available at report generation time. If your email hasn't been read in the source account, Cowork hasn't seen it yet. If your Excel spreadsheet hasn't been updated since Tuesday, the numbers will be Tuesday numbers. The accuracy depends on how current your data sources are.

The solution is establishing data entry standards. Set a deadline for team input: all spreadsheet updates due by 4 PM Thursday, all Teams channel summaries posted by 5 PM Thursday, etc. If data entry happens consistently, automated reports are consistently accurate.

You can also build in manual review. Rather than having Cowork automatically send the report, have it generate the report and send it to you for review. You spend 5 minutes reading it, making minor edits if needed, then sending to the intended recipients. This hybrid approach takes advantage of automation while maintaining control over final output.

Cowork supports more advanced configurations as you become comfortable with the basic setup.

You can configure conditional logic. For example, "If revenue is below target, include a special section with analysis." You can tell Cowork to flag metrics that show significant changes compared to previous weeks. You can exclude specific emails based on keywords if you want to filter out noise.

You can also create multiple Cowork agents that each handle a piece of the reporting workflow. One agent might handle financial metrics, another handles customer sentiment from emails, another handles project status from Teams and SharePoint. Each agent runs on a schedule and outputs to a shared folder. You can then have a master Cowork agent aggregate those outputs into a final executive report.

This advanced approach is useful in large organizations where different teams own different data sources and you need to coordinate reporting without manual handoff.

Most operators make one mistake early: connecting too many data sources at once. The resulting report becomes overwhelming and loses clarity. Start with your most critical sources: email, one Teams channel, one Excel file. Get that working cleanly. Then add additional sources.

A second mistake is not establishing data entry standards. If teams update their inputs sporadically, the automated report is only as fresh as the oldest data source. Communicate the Thursday 4 PM deadline clearly and enforce it.

Third, not reviewing the first few automated reports before they go to executives. Run the automation in "draft" mode for 2-3 weeks. Check the output carefully. Make sure data is being extracted correctly and formatting matches expectations. Only then enable auto-sending.

If you're managing a team of operators, you can set up Cowork reports for each person or each department. Sales managers can get weekly pipeline reports pulled automatically from their CRM and Teams activity. Operations managers can get weekly metrics reports pulled from their key spreadsheets and channels.

The setup takes about 20 minutes per person once you understand the process. The ongoing time savings add up significantly across a team. A team of five people each saving 1.5 hours weekly saves 390 hours annually. That's equivalent to nearly two full-time employees.

The real value is consistency and timeliness. Automated reports are never late. They're never forgotten. They always use the same format and include the same data sources, which makes it easy to spot trends over time.

Up Next

Optimize Your Sleep with Apple Watch + ChatGPT →

Get the full newsletter every week

This article is part of the PromptHacker Weekly premium deep-dive series. Subscribe to get all 7 articles plus the newsletter every Wednesday. Click here now