How to Save Email Newsletters to Google Sheets

A spreadsheet is actually a great place to track newsletters — better than most people give it credit for. You can see at a glance which ones you've read, sort by sender to find everything from a specific source, and use conditional formatting to make unread issues stand out. It's also something your whole team can access without needing a Notion or Airtable account.

Here's how to set up automatic newsletter archiving with Quicktion. If you're new to saving emails to spreadsheets, start with our guide to saving emails to Google Sheets.

Why Archive Newsletters in Google Sheets?

Sheets is good for this because it's low overhead. No new tool to learn. Use CTRL+F or filter views to find articles by keyword, source, or date. Sort and filter by topic, sender, or read status. The newsletters stay in your archive even if you unsubscribe, and you can share the sheet with anyone who has a Google account.

Honestly, the main advantage over fancier tools is the formula layer. You can count how many newsletters you've actually read vs. let pile up, spot patterns across sources, or add a simple COUNTIF to see which senders you're getting the most from. That kind of lightweight analysis is where Sheets earns its place.

Setting Up Your Spreadsheet

Create a Google Sheets spreadsheet with these columns:

Use data validation on the Status column to create a dropdown with "Unread", "Read", and "Starred" options.

Connecting Your Email (via Quicktion)

Method 1: Email Forwarding

Best for hands-free archiving. Set up Gmail filters to automatically forward newsletters to your Quicktion address, and they appear as rows in your spreadsheet.

1. In Quicktion, create a destination linked to your newsletter spreadsheet
2. Map email fields to your spreadsheet columns
3. Copy your unique forwarding address

Then create Gmail filters for each newsletter:

1. Go to Settings > Filters and Blocked Addresses
2. Click Create a new filter
3. Enter the newsletter sender's address in the "From" field
4. Check Forward it to and enter your Quicktion address

For multiple newsletters, combine them in one filter:

from:(morningbrew@morning.brew OR dan@tldrnewsletter.com OR newsletter@thehustle.co)

For more filter strategies, see our forwarding guide.

Method 2: Gmail Add-on

Best for saving specific issues rather than every newsletter. Open a newsletter in Gmail, click Quicktion, and save it to your archive. See the Gmail integration guide for setup.

Organizing Your Archive

Filter Views

Create filter views to browse your archive without changing the sheet for others:

• Reading Queue — Filter Status to "Unread", sort by Date (newest first)
• Favorites — Filter Status to "Starred", sort by Date (newest first)
• By Source — Sort by Source, then Date, to see all issues from one newsletter together
• This Week — Filter Date to the last 7 days

Conditional Formatting

Gray background for "Read" rows so unread newsletters stand out. Yellow background for "Starred" rows to highlight your favorites. Once you set this up, the unread/read distinction is visible at a glance without reading any cell value.

Quick Search

Google Sheets' built-in search (CTRL+F / CMD+F) works across all columns. Search for a keyword and it highlights every matching cell — useful when you remember a topic but not which newsletter covered it.

Tips

Be selective. Don't archive every newsletter — focus on the ones you actually reference. Use the Status column to track what you've read, and mark the best issues "Starred" so they're easy to find later. When you read something worth remembering, jot down key takeaways in the Notes column.

I'd also suggest reviewing your archive monthly. Scroll through it and unsubscribe from newsletters you never open. The archive makes this obvious in a way your inbox doesn't — you can literally see the read/unread ratio. Use simple, consistent tags like "tech", "business", "design" so filtering stays reliable over time.

Get Started

Set up your newsletter archive in under 5 minutes. Sign up for Quicktion, create a destination linked to your spreadsheet, and set up your first Gmail filter. Newsletters will start flowing into Google Sheets automatically.

Prefer a different platform? You can also archive newsletters in Notion or Airtable.