Outlook to Google Sheets: 4 Ways to Connect Outlook and Sheets

There's no native link between Outlook and Google Sheets. Microsoft would rather you used Excel; Google would rather you used Gmail. So "outlook to google sheets" is a question about which bridge to use, and the answer depends on how many emails, how clean you need the rows, and whether your company already pays for an automation platform.

I build Quicktion, one of the bridges, so read this with that in mind. I've tried to be specific about what each method does with the body, the date and the attachments, because that's where they differ.

Four ways to get Outlook emails into Google Sheets:

1. Outlook forwarding rule + Quicktion (automatic, formatted rows)
2. Microsoft Power Automate (Standard connector, you build the flow)
3. Zapier or Make (general automation, polling)
4. Export to CSV and import (one-off backfills)

There is no Quicktion add-in for Outlook. Quicktion has a Gmail add-on; on Outlook it works through forwarding, which is method 1.

Method 1: Outlook rules + Quicktion forwarding

Connect your Google account to Quicktion, pick the spreadsheet and the tab, map the columns, and you get a private address like xyz@in.quicktion.io. Then create an Outlook rule that forwards the emails you care about to that address.

What lands in the sheet

Each forwarded email appends one row:

• Subject in the column you mapped
• Sender name and sender email in their own columns
• Received date as a real date value, formatted in the spreadsheet's timezone (so sorting and date filters work)
• Body converted from HTML to markdown, with links kept clickable inside the cell
• Attachments uploaded to a Google Drive folder and linked from a column

Column mapping is stored as developer metadata on the sheet, which means it survives reordering and renaming columns. This sounds like a small detail until you've had a Zap silently write into the wrong column for a week because someone inserted "Owner" at position B.

On Pro, AI Email Intelligence can also fill columns you define. Forward invoice emails and have Amount, Vendor and Invoice number filled from the body or the attached PDF.

Setting it up in Outlook

In Outlook on the web: Settings > Mail > Rules > Add new rule. Pick your conditions (from a domain, subject contains, sent to a shared mailbox), set the action to forward to your Quicktion address, save. Rules created on the web or in Exchange Online run on the server, so they keep working when your laptop is shut and they work for shared mailboxes.

Desktop-only rules run when that Outlook is open. If rows stop appearing on the weekend, that's usually why.

The step-by-step for desktop, web and mobile, plus example rules for receipts, client logs and shared inboxes, is in How to Save Outlook Emails to Google Sheets. I won't duplicate it here.

What you don't get

No per-email edit before the row is written. The Gmail add-on has a preview where you can tweak values first; Outlook users get the destination's mapping applied to every email. For rule-based flows that's the point. For hand-picking emails it's a limitation.

And some organizations block outbound auto-forwarding at the Exchange level. If your rule saves but nothing shows up, ask IT before you debug the rule.

When to use it

When a class of emails should always become rows: order confirmations, receipts, form notifications, anything from a client domain. Shared inboxes are the best case, because everyone gets the same sheet without anyone doing anything.

Method 2: Power Automate

Power Automate is the default automation layer for Microsoft 365 shops, and unlike some third-party connectors, its Google Sheets connector is Standard tier. That means it works with a regular Microsoft 365 license without a Power Automate Premium add-on. I checked Microsoft's connector reference before writing that; the Airtable connector, for comparison, is Premium, and people tend to assume they're all the same.

How it works

Trigger: "When a new email arrives (V3)" from the Office 365 Outlook connector, filtered by folder, sender or subject. Action: "Insert row" from the Google Sheets connector, where you pick the file, the worksheet, and fill one value per column.

The two-step version works. The version you actually ship tends to grow:

• The trigger gives you the body as HTML, so you add an "Html to text" step or accept tags in the cell
• Attachments arrive as base64 content, so if you want them you loop over them, save each to OneDrive or Google Drive, and write the link into a column
• Date arrives as a string, so you format it with an expression if you want it sortable

Limits worth knowing

Microsoft's own docs for the connector list a few things that surprise people. Spreadsheets in shared drives can't be picked from the file browser; the workaround is pasting the spreadsheet ID as a custom value. Simultaneous modifications from other flow runs, parallel loops or manual edits aren't supported, which matters if two flows write to the same sheet. Column names get encoded when they contain spaces or symbols (a space becomes _x0020_), which is cosmetic but confusing when you first see it in the flow output. And there's a throttling limit of 100 API calls per connection every 300 seconds, plenty for email volume, tight for backfills.

Mapping is by column name. Rename a header and the flow fails at the next run.

Where it wins

You already run Power Automate flows and IT wants automations inside the tenant with audit logs. Or the email is one step among Teams messages, SharePoint files and Approvals. Power Automate does all of that on one canvas, and for Outlook to Sheets specifically the licensing objection doesn't apply.

Where it loses

Time and maintenance. What Quicktion does with a destination and a rule takes an afternoon in the flow editor, and the flow depends on column names and folder names that drift. Body formatting is your problem. And nobody non-technical is going to change the mapping without opening the flow.

Method 3: Zapier or Make

Both have a Microsoft Outlook (Microsoft 365) trigger and a Google Sheets "Create Spreadsheet Row" action. Zapier's Outlook trigger polls for new email rather than receiving it instantly, so rows show up on a delay that depends on your plan (up to 15 minutes on lower tiers). Make's Microsoft 365 Email module runs on its own schedule.

What you get

A row with the fields you map: subject, sender, body and date are all available from the trigger. Attachments need extra steps and often an extra task per file. Mapping is by column name.

Where it fits

When the email is one input to a longer chain. "Outlook email arrives, add row, post to Slack, create a task, follow up in two days" is what these platforms are for. If the whole workflow is "email becomes row," you're paying $19.99+/month for the engine and using one gear of it. More on that in Zapier Email to Google Sheets.

Method 4: Export to CSV and import

Not an integration, but it's the honest answer for a one-time job. Classic Outlook for Windows has File > Open & Export > Import/Export, which can write a folder to CSV. Open the CSV in Google Sheets or use File > Import.

You get subject, sender, recipients and date. You get the body as plain text, unformatted. You don't get attachments. And it's a snapshot, so tomorrow's emails aren't in it.

Use it to backfill six months of history into a sheet before switching on a forwarding rule for everything going forward. Don't use it as the ongoing process.

Outlook to Google Sheets: method comparison

Which one should you pick

If you need history in the sheet today, do the CSV export once. It's free and takes ten minutes.

For everything after that, an Outlook rule with Quicktion is the least work for the cleanest rows: real dates, clickable links, attachments in Drive, and a mapping that doesn't break when someone tidies the columns. The free plan's 25 emails a month is enough to run one real rule and see if you trust it.

If your company already lives in Power Automate and IT wants automations in the tenant, build the flow. The Google Sheets connector being Standard tier removes the license question; you're signing up for maintenance, not fees.

If the email is one step in a bigger cross-app process, Zapier or Make.

Get started

Sign up for Quicktion, connect your Google account, pick a spreadsheet, and copy the forwarding address. Then create the Outlook rule following How to Save Outlook Emails to Google Sheets. Forward one test email, check the row and the date format, then let the rule run.

Related guides

• How to Save Outlook Emails to Google Sheets, the step-by-step for desktop, web and mobile
• Outlook to Google Sheets, product overview
• How to Forward Emails to Google Sheets Automatically, more on column mapping and forwarding
• Gmail to Google Sheets: 4 Ways to Connect Gmail and Sheets, if part of your team is on Gmail
• Zapier Email to Google Sheets, the automation-platform trade-off in more detail