Use Outlook with an AI Browser for Data Extraction

Run data extraction in Strawberry using Outlook as one of the inputs. Specific surfaces, example prompt, real output, and tradeoffs vs alternatives.

Diagram of Strawberry AI browser workflow using Outlook for data extraction

If you use Outlook and you regularly need to extract structured data from websites, the bottleneck is usually the same: Outlook holds part of the context, but data extraction also needs signals that live outside it - on the public web, in LinkedIn, in news, in other connected apps. Strawberry is built to combine the Outlook context with the rest of the browser, and run the full workflow as a companion you can re-trigger every week.

This page describes specifically how Strawberry handles data extraction when Outlook is one of the inputs. It names the Outlook surfaces involved, the signals the workflow actually needs, an example prompt you can paste, and what a good output looks like.

The job a researcher, ops manager, analyst, founder doing market analysis is trying to do

The goal of data extraction is to turn unstructured pages into a clean table or dataset. The success metric is concrete: extraction accuracy above 95% on spot-checked rows, dedup rate above 95%, completeness above 90%. That definition matters because it shapes what Outlook needs to contribute to the workflow.

What signals data extraction actually needs

For each signal below, here is whether Outlook can contribute directly or whether Strawberry has to find it via the browser:

  • Source URL pattern (one page, paginated, search results) - Outlook does not contain this directly. Strawberry uses the browser plus public sources to fetch it.
  • Target schema (which fields per row) - Outlook does not contain this directly. Strawberry uses the browser plus public sources to fetch it.
  • Completion criteria (how many rows expected) - Outlook does not contain this directly. Strawberry uses the browser plus public sources to fetch it.
  • Validation rules (which fields must be present) - Outlook does not contain this directly. Strawberry uses the browser plus public sources to fetch it.
  • Login or paywall barriers - Outlook does not contain this directly. Strawberry uses the browser plus public sources to fetch it.
  • Rate-limit posture of the target site - Outlook does not contain this directly. Strawberry uses the browser plus public sources to fetch it.

What Strawberry can do inside Outlook

Strawberry can read threads, draft replies, scan upcoming events, and combine with OneDrive for follow-ups.

Outlook surfaces Strawberry uses for this workflow: inbox, folders, rules, calendar, search.

How Strawberry runs data extraction with Outlook

  1. Strawberry opens the Outlook inbox that contains the relevant context.
  2. The companion pulls related context from Outlook (folders, history, attached files) where it exists.
  3. For the parts Outlook does not store, Strawberry uses the browser - web search, LinkedIn, news, the prospect's website.
  4. Strawberry synthesises the output in the shape this workflow needs: A CSV or sheet with one row per extracted entity and a confidence column.
  5. A human reviews before any external action (send, update, post). Then the approved output is saved back to Outlook or your system of record.

Example Strawberry prompt

Paste this in a new Strawberry chat with Outlook connected. Adjust the specifics to your actual ICP, role, or topic.

Read this Outlook inbox and any linked context.
Then run a full data extraction workflow on it. Use the browser to fill any gaps not in Outlook.
Return the output in the shape we use for data extraction: A CSV or sheet with one row per extracted entity and a confidence column.
Do not send anything externally. Save the draft to me to review.

What a good data extraction output looks like

Here is what a finished output for data extraction should look like in practice. The specifics will change for your use case, but the shape should look similar:

  • Source: company directory at example.com/companies, 30 pages of 50 companies each
  • Target schema: name, website, employee count, HQ city, sector tag
  • Expected rows: ~1500 (50 x 30)
  • Validation: name + website required; sector tag from a fixed list
  • Output: ./companies.csv with 1485 rows after dedup, 12 rows flagged for human review

Why Outlook for this, and where to use a different tool

Outlook is strong for this workflow because Strawberry can read threads, draft replies, scan upcoming events, and combine with OneDrive for follow-ups.

Where Outlook falls short Shared mailbox access requires explicit delegate permission; some on-prem hybrid setups limit Graph API surfaces.

Consider also a CRM for relationship history beyond a single thread.

Common mistakes when running data extraction

  • No schema defined upfront, leading to inconsistent rows
  • Ignoring pagination and missing 80% of the data
  • Extracting from logged-in pages without confirming the cookies are valid
  • Hammering the target site without rate-limiting

Connecting Outlook to Strawberry

Microsoft Graph OAuth. Once connected, the companion can read the surfaces above without re-authenticating, and any write action still requires explicit human approval the first time the workflow runs.

Caveats

Do not let any AI agent send emails, update CRM records, or change shared systems without a clear approval step. Strawberry is strongest when the workflow combines browser context with connected-app context and a human review for sensitive actions.

How Outlook + Strawberry runs data extraction

1 Outlook

Read

Open the relevant Outlook inbox; pull related context.

2 Browser

Augment

Use the browser, LinkedIn, news, and other connected apps for signals outside the CRM/tool.

3 Output

Compose

Synthesise into the data extraction shape: A CSV or sheet with one row per extracted entity and a confidence column.

4 Human

Approve

Human reviews before any external action; approved output is saved back.

FAQ - Outlook + AI browser for data extraction

Can Strawberry do data extraction entirely inside Outlook?

No, and that is the point. data extraction needs signals Outlook does not store - public web, LinkedIn, news, other apps. Strawberry combines Outlook with the browser, which is where the real value comes from.

Does Outlook need to be the primary CRM or system of record?

Not necessarily. Outlook can be one input among several. Strawberry can read it as context even if your primary system of record is somewhere else.

What permissions do I need on Outlook?

Read access to the surfaces you want Strawberry to use (inbox, folders, rules). Write permissions are only needed if you want Strawberry to update Outlook after a human approves the change. Microsoft Graph OAuth.

What is the realistic success metric for data extraction?

extraction accuracy above 95% on spot-checked rows, dedup rate above 95%, completeness above 90% - that is the target Strawberry helps you hit, not the only thing it measures.

What is the biggest mistake to avoid?

No schema defined upfront, leading to inconsistent rows.

Run data extraction in 10 minutes with Strawberry and Outlook

  1. Open Outlook

    Connect Outlook so Strawberry can read inbox, folders, rules and combine them with the rest of the brief. Pin the specific records or views you want to start from so the agent doesn't drift.

  2. Tell Strawberry the brief

    Drop the prompt below. Replace the placeholder with the actual researcher, ops manager, analyst, founder doing market analysis target - one name, one URL, or one Outlook reference is enough. Keep the goal explicit: turn unstructured pages into a clean table or dataset.

  3. Let it gather signals

    Strawberry pulls source URL pattern (one page, paginated, search results) and target schema (which fields per row), then layers public web sources in parallel. You should see citations next to each fact - that is the audit trail. Watch the Outlook side: Shared mailbox access requires explicit delegate permission; some on-prem hybrid setups limit Graph API surfaces

  4. Review before write-back

    Output lands in the shape you asked for: A CSV or sheet with one row per extracted entity and a confidence column. Read it once. Fix anything off. The success metric is extraction accuracy above 95% on spot-checked rows, dedup rate above 95%, completeness above 90% - if the draft doesn't hit that bar, send it back with a one-line correction.

  5. Save it as a routine

    If you'll extract structured data from websites again next week, click Save as routine. Pick a cadence (daily, weekly, on-trigger). Strawberry re-runs the whole flow on schedule and pings you when the new output is ready.

Paste-ready prompt for data extraction with Outlook

You are helping me extract structured data from websites. Use Outlook as one input and the public web for the rest.

Target: [paste one researcher, ops manager, analyst, founder doing market analysis target here - a Outlook reference, a name + company, or a URL]

Goal: turn unstructured pages into a clean table or dataset.

Signals to gather:
- source URL pattern (one page, paginated, search results)
- target schema (which fields per row)
- completion criteria (how many rows expected)
- validation rules (which fields must be present)
- login or paywall barriers
- rate-limit posture of the target site

Output shape: A CSV or sheet with one row per extracted entity and a confidence column

Rules:
- Cite every fact with a link or a Outlook reference. If you cannot find a signal, say so explicitly rather than guessing.
- Do not invent specifics. Use real, dated signals from the last 90 days where possible.
- If a fact would change the outcome and is missing, pause and ask me before writing the final output.

When the output is ready, surface it in this chat. Do not write back to Outlook or send anything externally until I approve.

Paste this into Strawberry's chat field. Replace the target placeholder before running.

When Outlook + Strawberry is NOT the right fit for data extraction

Skip this setup if any of the following is true:

  • You don't actually need Outlook signals. If everything you need lives on the public web, drop the Outlook step and let Strawberry run on URLs alone - it's faster.
  • A known Outlook constraint blocks the speed gain: Shared mailbox access requires explicit delegate permission; some on-prem hybrid setups limit Graph API surfaces
  • The buyer (researcher, ops manager, analyst, founder doing market analysis) doesn't own the decision. If the brief gets handed to someone who'll redo the research, the audit-trail-in-Strawberry advantage is wasted.

3 mistakes that kill this workflow

  1. no schema defined upfront, leading to inconsistent rows. Outlook is one input. Strawberry's edge is combining it with everything else. Stop at Outlook-only signals and you'd have been faster with native Outlook reports.
  2. ignoring pagination and missing 80% of the data. Pre-check Outlook for a recent touch or duplicate before Strawberry acts on the output. A duplicate hit burns the relationship.
  3. extracting from logged-in pages without confirming the cookies are valid. Strawberry is built so a human reviews before any external action. Skipping that review to save time is how you ship a wrong fact to a real person.

Honest tradeoff vs alternatives

You could extract structured data from websites inside Outlook alone using its native features, or with a dedicated data extraction tool. Outlook alone gives you tighter data fidelity but misses every signal that lives off-platform. A specialised data extraction tool gives you better dashboards but its scope ends where its integrations end, and most of the real signal still lives on the open web.

Strawberry's edge with Outlook: Strawberry can read threads, draft replies, scan upcoming events, and combine with OneDrive for follow-ups The price you pay: an agent run takes 30-90 seconds; a native Outlook action loads in 2. For a one-off question you already know the answer to, use Outlook directly. For an output you need every week and want to systematise, this is where Strawberry pays off.