How to Save Outlook Emails to Google Sheets

You can save Outlook emails to Google Sheets by forwarding them to a Quicktion address linked to your spreadsheet. Each forwarded email becomes a new row with the subject, sender, date, body, and attachments mapped to columns automatically. It works with Outlook desktop, web, and mobile — no extensions or add-ons needed.

Why Forwarding Is the Way to Do This

Most email-to-spreadsheet tools focus on Gmail. Quicktion has a Gmail add-on too, but it only works inside Gmail — not Outlook. That said, Quicktion's email forwarding works with any email client, and Outlook has strong built-in rules that make auto-forwarding easy.

The setup is simple: you get a unique Quicktion address (e.g., invoices-x4k@in.quicktion.io), forward emails to it, and they appear as rows in your Google spreadsheet. You can forward manually or set up Outlook rules to do it automatically.

For a general overview of all methods for saving emails to Google Sheets, see our complete guide.

Setting Up Quicktion

Before configuring Outlook, you need a Quicktion destination — the link between a forwarding address and a Google spreadsheet.

1. Sign up at quicktion.io and connect your Google account (this grants access to Google Sheets and Google Drive)
2. Create a destination and select which spreadsheet and sheet tab should receive your emails
3. Map your columns — choose how email fields map to spreadsheet columns (subject in column A, sender in column B, date in column C, etc.)
4. Copy your unique Quicktion forwarding address

The whole thing takes about two minutes.

Manual Forwarding from Outlook

The simplest way to start: forward individual emails by hand.

Outlook Desktop (Windows/Mac)

1. Open the email you want to save
2. Click Forward
3. Paste your Quicktion forwarding address in the To field
4. Click Send

Outlook Web (outlook.com / Office 365)

1. Open the email
2. Click the Forward button (or press Ctrl+F)
3. Enter your Quicktion address
4. Click Send

Outlook Mobile (iOS/Android)

1. Open the email
2. Tap the Forward icon
3. Enter your Quicktion address
4. Tap Send

Within 10-30 seconds of hitting send, the email shows up as a new row in your Google spreadsheet.

Automatic Forwarding with Outlook Rules

Manual forwarding works, but rules are where this gets useful. Set up a rule once and matching emails flow into your spreadsheet without any effort.

Outlook Web / Office 365 Rules

This is the recommended approach. Rules created in Outlook Web run server-side, meaning they work 24/7 — even when your desktop client is closed and your computer is off.

1. Click the Settings gear icon
2. Go to Mail > Rules
3. Click Add new rule
4. Name your rule (e.g., "Forward invoices to Sheets")
5. Add conditions (from a specific sender, subject contains certain words, etc.)
6. Add action: Forward to and enter your Quicktion address
7. Click Save

Outlook Desktop Rules (Windows/Mac)

1. Go to File > Manage Rules & Alerts
2. Click New Rule
3. Choose Apply rule on messages I receive
4. Set conditions:
   • From specific people or groups
   • With specific words in the subject
   • Sent to a specific address
5. Set action: Forward it to and enter your Quicktion address
6. Click Finish

Desktop rules only run when Outlook is open. If you need always-on forwarding, use Outlook Web rules instead.

Example Rules

Forward all emails from a client:

• Condition: From = *@clientdomain.com
• Action: Forward to your project tracking Quicktion address

Forward invoices and receipts:

• Condition: Subject contains "invoice" or "receipt"
• Action: Forward to your expense tracking Quicktion address

Forward emails to a shared mailbox:

• Condition: Sent to support@yourcompany.com
• Action: Forward to your support log Quicktion address

You can create multiple rules, each forwarding to a different Quicktion destination (and therefore a different spreadsheet). Route invoices to one sheet, client emails to another, and newsletter subscriptions to a third.

What Gets Saved to Your Spreadsheet

When an email is forwarded to Quicktion, it extracts:

• Subject — saved to the column you designate
• Sender name — saved to a separate column
• Sender email — saved to a separate column
• Date — saved as a date value, formatted to your spreadsheet's timezone
• Body — converted to markdown with clickable links preserved as rich text
• Attachments — uploaded to Google Drive and linked in a column

You control which columns appear and in what order. The column mapping uses Google Sheets' developer metadata, so it stays intact even if you rename headers or reorganize your sheet.

For more on column configuration, see our email forwarding to Google Sheets guide.

Use Cases for Outlook-to-Sheets

Expense and Receipt Tracking

Forward purchase confirmations from vendors to a Google Sheets expense tracker. The subject captures the vendor, the date records when the transaction happened, and PDF receipts are uploaded to Drive. Set up Outlook rules for your common vendors — Amazon, Stripe, PayPal — and every receipt is logged automatically. Add columns for amount, category, and reimbursement status.

Client Email Log

If you manage client work in Outlook (common in consulting, agencies, and professional services), forward client emails to a project tracking spreadsheet. The sender identifies the client, the body captures their request, and the date shows when they reached out. Share the sheet with your team for visibility.

Reporting and Compliance

Some teams need a record of specific emails outside the inbox — for audits, compliance, or simply as a backup. Auto-forward matching emails to a Google Sheet and you have a timestamped, searchable log. This is especially useful in organizations where Outlook retention policies may delete emails after a set period.

Newsletter Archive

Forward newsletters to a Google Sheets archive so you can search and filter them later. Set up one Outlook rule per newsletter sender. Every issue lands in your spreadsheet with the subject, date, and full content.

Outlook-Specific Tips

1. Use Outlook Web rules for reliability. Web-based rules (Office 365) run server-side. Desktop rules only run when Outlook is open on your computer.
2. Shared mailboxes work too. If your team uses a shared Outlook mailbox, set up a rule on the shared mailbox to auto-forward to Google Sheets. Everyone can see the data in the spreadsheet.
3. Exchange Online admins may restrict forwarding. Some organizations block external forwarding for security. If your rule doesn't work, check with your IT team — they may need to allow forwarding to your Quicktion address.
4. Calendar invites aren't supported. Email forwarding works for regular emails, not calendar invites or meeting requests.
5. Test before automating. Forward a few emails manually first to verify the column mapping looks right. Once it does, set up your rules.

Limitations

There's no Outlook add-on or extension for Quicktion. Unlike the Gmail add-on, you can't save emails with one click from inside Outlook. All saving is done through forwarding. You also can't edit column values before saving — properties are mapped automatically based on your destination configuration.

Email attachments are handled by Quicktion and saved to Google Drive, but very large attachments may be subject to size limits.

Get Started

Sign up for Quicktion and create your first destination linked to a Google spreadsheet. Then set up an Outlook rule to start forwarding emails automatically. The whole setup takes about five minutes.

If you also use Notion, you can save Outlook emails there too — see our Outlook-to-Notion guide.