The Scenario
A client you support has been emailing your team for 30 days straight. Your manager wants a report by end of day: how many messages came in, what the average response time looks like, and which senders are most active. The data is all in Outlook. None of it is in a workbook.
You start manually: open Outlook, search the client domain, scroll, count rows in your head.
The bad version:
- Search Outlook for the client domain, scan the inbox, and start writing down subject lines and timestamps by hand
- Realize on message 40 that you forgot to note whether each message had been read, go back through all 40 to check
- Export what Outlook will give you, open the CSV in Excel, find that the timestamp format is wrong and half the fields are missing
The report is due in two hours. The data you need is in Outlook, the analysis goes in a workbook, and right now there's a wall of manual work between the two.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Excel workbook, connects to Outlook, runs the search, and writes the results directly into your table. No export, no CSV reformatting.
Search my Outlook inbox for all emails from '@acmecorp.com' received in the last 30 days and write each message's sender, subject, receivedDateTime, and isRead status into this table
What You Get
- One row per matching email written into your workbook, starting at the next empty row
- Columns for sender address, subject line, received timestamp, and read/unread status
- Messages returned in reverse chronological order by default
- A count of total messages written noted in the sidebar
What If the Data Is Not Quite Ready
You want only unread messages, not everything
Search my Outlook inbox for all unread emails from '@acmecorp.com' received in the last 30 days and write sender, subject, receivedDateTime, and isRead into this table — filter to isRead equals false only
The timestamps are coming in as UTC and you need them in Eastern time
Search my Outlook inbox for all emails from '@acmecorp.com' received in the last 30 days, convert each receivedDateTime from UTC to Eastern time, and write sender, subject, the converted timestamp, and isRead into this table
You need to pull from Sent Items too, not just the inbox
Fetch all emails I sent to '@acmecorp.com' in the last 30 days from my Outlook Sent Items folder and write the to address, subject, sentDateTime, and hasAttachments flag into this table alongside the inbox results
Pull all matching emails, add a response-time column, and flag threads with no reply
Search Outlook inbox and Sent Items for all emails from '@acmecorp.com' in the last 30 days, match each inbound message to the earliest sent reply in the same thread, calculate the response time in hours, and write all fields plus the response time and a "No Reply" flag into this table
The cleanup and the calculation happen in the same prompt — no intermediate steps required.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then tell SheetXAI which inbox to search and what date range you need. See also: Extract emails by keyword into a summary report and the Outlook hub overview.