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

Most Gmail-to-Sheets workflows start the same way: someone needs to track emails in a spreadsheet and doesn't want to copy-paste. Maybe it's receipts, lead inquiries, order confirmations — something that arrives predictably in email and needs to end up in a spreadsheet where it can be filtered, sorted, and shared.

Despite being Google products, Gmail and Sheets don't natively connect in the way you'd want. There's no button in Gmail to log an email as a new row. No forwarding rule that maps email fields to columns automatically. If you want this to work, you need a third-party tool or one of a few workarounds.

There are four solid methods, each suited to different workflows:

1. Gmail add-on (manual, one-click saving from Gmail)
2. Email forwarding (automatic, rule-based saving)
3. Google Apps Script (free but technical, requires coding)
4. Automation platforms (Zapier, Make)

Method 1: Gmail Add-on (Quicktion)

A Gmail add-on is the most direct way to save emails to Google Sheets. You stay in Gmail, click a button, and the email appears as a new row in your spreadsheet.

Quicktion's Gmail add-on works as a sidebar panel inside Gmail. When you open any email, you click the Quicktion icon, choose a destination spreadsheet, and hit save.

How to Set It Up

Open the Google Workspace Marketplace, search for "Quicktion," and click Install. Grant the requested permissions (read email and display sidebar).

Open Gmail, click the Quicktion icon in the right sidebar, and sign in with your Google account. Then connect your Google account and authorize access to Google Sheets and Drive.

In your Quicktion dashboard, create a destination linked to a Google spreadsheet. Choose which sheet tab will receive emails and configure which columns map to which email fields — subject, sender, date, body, attachments.

Open any email in Gmail, click the Quicktion icon, select your destination, and click Save to Google Sheets. Done.

What Gets Saved

The add-on maps the full email to your spreadsheet. Subject goes to a column you configure. Sender name and email go to separate columns. Date received is saved to a date column, formatted to your spreadsheet's timezone. The full email body is converted to markdown with clickable links preserved as rich text. Attachments are uploaded to Google Drive and linked in an attachments column.

One thing worth highlighting: rich text with clickable links in Sheets. Most methods dump plain text in the body cell. Quicktion uses Sheets' textFormatRuns API to preserve links as actual clickable hyperlinks inside the cell. This matters a lot when you're reviewing emails from a spreadsheet.

Pros

• One-click saving from inside Gmail
• Preview before saving — see exactly what data will be added to your sheet
• Full email formatting preserved as rich text with clickable links
• Attachment handling — files uploaded to Drive and linked automatically
• No email forwarding rules to configure

When to Use It

The Gmail add-on is best when you want to cherry-pick individual emails. You read an email, decide it belongs in your spreadsheet, and save it on the spot. It's ideal for logging important client emails, one-off receipts, or anything that doesn't follow a predictable pattern.

For more on email-to-Sheets workflows, see our complete guide to saving emails to Google Sheets.

Method 2: Email Forwarding

Email forwarding is the set-it-and-forget-it approach. Instead of manually saving each email, you forward them to a unique address and they automatically appear as new rows in your spreadsheet.

How It Works

In your Quicktion dashboard, create a destination linked to a Google spreadsheet. Quicktion generates a unique forwarding address like abc123@in.quicktion.io.

Configure which email fields map to which columns — subject to column A, sender to column B, date to column C, body to column D, and so on. You control the order and which fields to include.

You can forward emails manually by sending them to your Quicktion address, or set up automatic forwarding with Gmail filters.

Setting Up Auto-Forwarding in Gmail

Gmail's filter system lets you automatically forward matching emails to your Quicktion address.

1. In Gmail, click the search bar dropdown and define your filter criteria (from a specific sender, containing certain words, with attachments, etc.)
2. Click Create filter
3. Check Forward it to and select your Quicktion forwarding address
4. Optionally check Also apply filter to matching conversations to process existing emails

From that point on, every matching email is automatically saved to Google Sheets. You don't need to open Gmail, click anything, or even be at your computer.

For the full setup process, see our email forwarding to Google Sheets guide.

Pros

• Fully automatic once configured
• Works with any email client, not just Gmail
• Rule-based — save only emails that match specific criteria
• No manual action required per email
• Bulk processing — handles high volumes without manual effort

When to Use It

Forwarding shines for high-volume, predictable workflows. Receipts from specific vendors. Order confirmations from e-commerce platforms. Newsletter subscriptions you want archived. Lead inquiries from a contact form. Anything where you can define a rule like "all emails from X go to spreadsheet Y."

Many users combine forwarding with the Gmail add-on: forwarding handles the automated, predictable emails while the add-on handles selective saves. See our comparison of both methods for more detail.

Method 3: Google Apps Script

Google Apps Script is Google's JavaScript-based scripting platform. It can access both Gmail and Google Sheets APIs, so you can write code that reads emails and writes them to a spreadsheet.

This is the free, DIY option. You write the script yourself, and Google runs it on their servers.

How It Works

Open Google Sheets, go to Extensions > Apps Script, and create a new project.

Use the Gmail API to search for emails matching specific criteria — GmailApp.search("from:billing@stripe.com"), for example.

Parse the email subject, sender, date, body, and attachments using Apps Script methods. Then use the Sheets API to append a new row with the extracted data.

Configure a time-based trigger to run your script every hour, every day, or on whatever schedule you need.

Pros

• Completely free — no subscription required
• Full control over the exact logic
• No third-party tools — everything runs on Google's infrastructure
• Custom logic for complex parsing, conditional routing, or data transformation

Cons

• Requires coding knowledge — you need to know JavaScript and understand Gmail/Sheets APIs
• Gmail API has daily quotas that can be hit with high-volume workflows
• Maintenance burden — if Google updates their APIs or your email structure changes, you need to update the script yourself
• No built-in rich text conversion — preserving clickable links in cells requires significant custom code
• Attachment handling is complex — uploading files to Drive and linking them in Sheets is a non-trivial addition
• You need to write your own retry logic, logging, and error notifications

When to Use It

Apps Script makes sense if you're a developer, have very specific custom requirements, or want to avoid subscription costs entirely. In my experience, the time investment to build, test, and maintain an Apps Script solution usually exceeds the cost of a simple tool. A typical implementation takes several hours to build and debug, and needs ongoing maintenance. If you're not already familiar with Apps Script, building this from scratch just to log emails to a sheet is probably not the best use of your time.

Method 4: Automation Tools (Zapier, Make)

Zapier and Make can connect Gmail to Google Sheets through trigger-action workflows. They're flexible, but they come with real tradeoffs — especially around email body handling.

How It Works

In Zapier, you create a Zap with a Gmail trigger (new email matching search) and a Google Sheets action (add row). In Make, same concept — a Scenario with modules.

You define trigger conditions, map fields to columns, and the automation runs whenever a matching email arrives.

Pros

• Flexible trigger conditions
• Chain multiple actions — save to Sheets, then send a Slack message, then log to Airtable
• If you already use Zapier or Make for other workflows, adding email-to-Sheets is not hard
• Conditional logic — route different emails to different spreadsheets

Cons

• Basic email body handling — most workflows only capture plain text, not rich text with clickable links. The cell will have a wall of text with no formatting.
• Complex setup — 15-20 minutes, plus debugging
• Paid plans required for anything beyond minimal use
• Task-based pricing adds up quickly
• No Gmail add-on for manually saving individual emails
• Attachment handling is manual — you need separate actions to upload files to Drive and link them
• Column mapping is fragile — reorganize your spreadsheet columns and your automation breaks

When to Use It

Zapier and Make work best for complex multi-app orchestration: save to Sheets AND create a task in Asana AND send a Slack notification from one trigger. For that kind of flow, they're the right tool.

But if the goal is just getting emails into Google Sheets with good formatting and attachment handling, a dedicated tool delivers better results with less setup.

Gmail to Google Sheets: Method Comparison

For most people, the Gmail add-on combined with email forwarding covers every scenario. Use the add-on for selective saves and forwarding for automated ones.

Popular Use Cases

Expense & Receipt Tracking

Forward purchase confirmations and invoices to a Google Sheets expense tracker. The subject captures the vendor, the date records when the transaction happened, and attachments (PDF receipts) are uploaded to Drive and linked in the spreadsheet.

Set up Gmail filters for common vendors (Amazon, Stripe, PayPal, Square) and every receipt is logged automatically. Filter by date range for tax season or reimbursement requests.

For a Notion-based alternative, see our receipt tracking guide.

Lead Capture & CRM

If you receive sales inquiries via email, forward them to a Google Sheets CRM tracker. The sender becomes the lead contact, the body contains their question, and the date shows when they reached out.

Add columns for status (New, Contacted, Qualified, Closed) and deal value. Filter by status, sort by date, and keep your entire pipeline visible in one sheet. Sheets formulas and pivot tables make this surprisingly powerful once the data is there.

See our email tracking spreadsheet guide for more detail.

Order Confirmation Log

E-commerce businesses and marketplace sellers receive order confirmations via email. Forward these to a Google Sheets order log to track fulfillment timelines and inventory.

Set up auto-forwarding from platforms like Shopify, Etsy, or Amazon Seller Central. Your order history is automatically logged and searchable.

Newsletter Archive

Subscribing to newsletters is easy. Finding that one article three months later is hard. Forward newsletters to a Google Sheets archive and you get a searchable log with subjects, dates, senders, and full content.

Add a column for "Read" status or "Category" to organize what you've consumed vs. what's queued up. Use Sheets' search function to find articles by keyword.

For a Notion-based approach, see our newsletter archiving guide.

Frequently Asked Questions

Can you save Gmail emails to Google Sheets?

Yes. You can save Gmail emails to Google Sheets using a Gmail add-on like Quicktion, email forwarding, Google Apps Script, or automation platforms like Zapier. The simplest methods are Quicktion's Gmail add-on (one-click saving) and email forwarding (automatic saving via forwarding rules).

What is the best Gmail to Google Sheets integration?

Quicktion is the best Gmail-to-Google Sheets integration for most users because it offers both a Gmail add-on for manual saving and email forwarding for automatic saving, with rich text formatting and attachment uploads to Drive. Alternatives like Zapier or Apps Script require more setup and don't preserve rich text as well.

Is there a free way to save Gmail emails to Google Sheets?

Yes. Quicktion offers a free plan that includes 25 emails per month with both the Gmail add-on and email forwarding. Google Apps Script is also free but requires coding knowledge and significant time investment to build and maintain.

Can Google Apps Script save emails to Sheets?

Yes, but it requires writing JavaScript code, handling Gmail API quotas, and maintaining the script yourself. For most users, a no-code tool like Quicktion is faster to set up and more reliable. Apps Script is best for developers with custom requirements.

Can I automatically send Gmail emails to Google Sheets?

Yes. Set up a Gmail filter to auto-forward matching emails to your Quicktion forwarding address. Every forwarded email is automatically saved to your spreadsheet with all fields mapped to the right columns. You can create multiple filters for different email types.

What data gets saved from Gmail to Sheets?

Subject, sender name, sender email, date, the full email body (as rich text with clickable links), and attachments (uploaded to Google Drive and linked). You control which columns appear in your sheet and in what order.

Get Started

Quicktion is the fastest way to set up a Gmail-to-Google Sheets integration. Create a free account, connect your Google account, and start saving emails in under two minutes — either with the Gmail add-on or email forwarding.

For a complete walkthrough of every feature, read our guide to saving emails to Google Sheets.

For more advanced spreadsheet workflows, see our email tracking spreadsheet guide.