If you run a service-based business, you probably receive leads via email. Whether they come from a contact form on your website, a real estate portal like Zillow, or a third-party lead generation service, manually transferring that data from Gmail to a tracking spreadsheet is a massive waste of time.
In this tutorial, we will show you how to automatically capture incoming lead emails and extract their details (Name, Phone, Email, Budget) directly into Google Sheets.
The Problem with Basic Auto-Forwarding
Gmail has a built-in feature to auto-forward emails to another address. However, you can't just forward an email to a Google Sheet natively. And even if you use a tool to send the email text to a sheet, you'll end up with a messy block of text crammed into a single cell.
What you actually need is an Email Parser that reads the incoming email and extracts the specific variables into their respective columns.
Step-by-Step: Automating Lead Capture
1. Create a Label and Filter in Gmail
First, isolate your lead emails. Go to Gmail settings and create a filter that catches these emails. For example, if all your leads come from a web form, set the filter to match emails with the subject "New Website Lead". Tell Gmail to automatically apply a label named "New Leads" to these messages.
2. Set Up Your Tracking Sheet
Create a new Google Sheet named "Lead Tracker". Set up your column headers in Row 1: Date, Lead Name, Lead Email, Phone Number, and Message.
3. Install Mail Sheet
This is where the magic happens. Mail Sheet is a Google Sheets add-on that acts as a bridge between your inbox and your spreadsheet.
- Open your Lead Tracker sheet.
- Go to Extensions > Mail Sheet > Open.
- Select the "New Leads" Gmail label as your source.
- Map the email fields to your columns. Mail Sheet uses AI to read the body of the email and extract the specific details you need, like the phone number and name, placing them in the correct columns.
Why Mail Sheet Beats Zapier for This Workflow
While you can build this workflow using tools like Zapier, it usually requires a premium subscription and complex regex coding to extract the correct text string. Mail Sheet is built natively into Google Workspace and uses AI to understand the context of the email, eliminating the need for complex rules.
Frequently Asked Questions
Can I use Gmail's native auto-forward feature to send leads to Google Sheets?
No. Gmail's built-in auto-forward only sends a copy of the email to another email address, it cannot write structured data into spreadsheet columns. To get lead details like name, phone, and budget into separate cells, you still need an email parser such as Mail Sheet layered on top of your Gmail filter and label.
What if my lead emails come from different sources with different formats?
This is exactly where AI-based parsing has an advantage over rigid rules. Instead of writing separate regex patterns for each lead source (Zillow, a web form, a third-party service), Mail Sheet reads the context of the email body and extracts the same fields regardless of formatting, so you can route multiple lead sources into the same Gmail label and still get clean, consistent rows in your tracker.
How often does the sheet update with new leads?
Mail Sheet checks the labeled Gmail folder on a schedule and appends new matching emails to your Lead Tracker automatically, so you don't have to manually run an import or copy-paste each new inquiry. This keeps your spreadsheet current without any ongoing manual effort.