Real Estate Email Tracking in Airtable: Leads, Properties, and Contracts

Real estate inboxes are a specific kind of chaos. A Zillow notification at 7:14am, a Realtor.com inquiry at 7:22, a direct referral at 7:40, then a contract attachment from a buyer's agent at 8:05 with three PDFs and a question about closing date buried in the body. By the time you sit down with coffee, you've already lost track of which property the 7:22 inquiry was about.

I built Quicktion partly because I kept watching real estate teams type all of this into a spreadsheet by hand and wonder why their pipeline reporting was a week behind. Airtable handles the structure. Quicktion handles the inbox-to-Airtable part. This post is about how those fit together for a real estate workflow: leads, properties, agents, and the contracts that flow between them.

I'm assuming you already know the basics of forwarding into Airtable. If not, the Gmail to Airtable integration guide covers the four ways to connect them, and the Airtable CRM email integration post walks through the linked-records pattern in general terms. This post stays on the real estate workflow.

The base: three linked tables

The mistake most people make is starting with one giant table of emails. That gets you a searchable archive, not a working CRM. The structure that actually holds up under real listing volume is three tables linked together.

Leads (the table emails land in)

Properties (the listings the leads are about)

Agents (the people on your team)

Open a Properties record and you see every email about that listing, who asked about it, what budget they had, and which agent picked up the lead. That's a real CRM. A spreadsheet can't do this; more on that in a minute.

Source tagging by forwarding address

Here's the trick that makes Source tagging work without anyone touching a dropdown.

Create a separate Quicktion destination for each lead source. Each one gets its own forwarding address (zillow-xyz@in.quicktion.io), and each one writes to the same Leads table. The difference is the Default value you set on the Source field: destination 1 defaults Source to "Zillow", destination 2 to "Realtor.com", destination 3 to "Trulia", destination 4 to "Direct" (for your team's contact form forwards), destination 5 to "Referral".

Then set Gmail filters that auto-forward by sender domain. Anything from zillow.com goes to destination 1, anything from realtor.com goes to destination 2, and so on. Every row that lands arrives tagged with the right source. Your kanban grouped by Source works on day one, not after three weeks of cleanup.

Default values are a Pro feature. If you're on Free and only running one source through Quicktion to try it, leave Source blank and fill it manually until you upgrade.

AI extraction for free-text inquiries

The hard part of lead intake is that the useful information lives in unstructured text. Zillow gives you a name and an email, but the buyer's budget, timeline, and target neighborhood are buried in a paragraph like "Hi, I saw your listing on Maple Street and I'm hoping to find something around 600k in the next couple months, we're moving from Austin."

Quicktion's AI Email Intelligence reads that and fills the structured fields. On the destination, you write a prompt once. Something like:

Extract these from the email:

• Buyer Name: first and last name if present, otherwise just first
• Budget Min and Budget Max: parse phrases like "around 600k" as 575000–625000, "under 800" as null–800000, "500-700k" as 500000–700000
• Target Neighborhood: the area name they mention if any
• Timeline: classify as "Now" if they mention urgency, "1-3 months" for "couple months," "3-6 months" for "this summer/fall," "6+ months" otherwise

Then tell AI which Airtable fields to fill: Buyer Name, Budget Min, Budget Max, Target Neighborhood, Timeline. When a Zillow inquiry lands, AI reads it and drops the values into the right fields. Anything not in the email stays blank. No fake budgets, no invented timelines. The activity feed shows which fields got filled on each save, which is useful for tuning the prompt the first week.

AI Email Intelligence is a Pro feature. The Free plan still captures the email; it just doesn't auto-fill the structured fields.

Attachments: contracts, comps, inspections

This is where a lot of email tools fall apart for real estate. Buyer's agents send purchase contracts as PDFs. Inspection reports come back as 40-page PDFs. Comps land as PDF exports from MLS. Disclosure photos arrive as JPEGs from someone's phone.

Quicktion uploads all of those directly into a Multiple Attachments field on the lead's Airtable record. Not URLs that expire, not Drive links that broke when someone reorganized folders. Actual files on the row, visible in gallery view, downloadable from the mobile app.

With AI Processing on, Quicktion can also read PDF and image attachments. If a buyer's agent forwards a signed offer, AI pulls the offer price, earnest money amount, and proposed closing date off the contract page into structured fields, not just the email body. PDFs and images only so far; DOCX and XLSX aren't supported yet.

Pipeline views

Once leads land structured and tagged, the views take over.

A grid view filtered to Status = "New", sorted by date descending, is your morning triage. New Zillow inquiry at the top, you skim Buyer Name, Budget, Timeline, click into the row to read the body, decide whether to call now or assign.

A Kanban view grouped by Status (New → Contacted → Showing → Offer → Closed) is the pipeline. Drag cards across as the deal progresses. Color by Source to see whether Zillow leads or referrals close at a higher rate.

For showings, add a Showing Date field and create a Calendar view. Anything with a date set appears on the calendar, useful when you're juggling six showings across three properties on a Saturday.

For a listing-side view, group the Leads table by the Property linked-record field. Now you see every lead per listing — the view I'd want before a price-reduction conversation with a seller.

Why not a spreadsheet

Quick detour because someone always asks. Real estate has many-to-many relationships a flat spreadsheet can't model. A buyer inquires about four properties before making an offer. A property gets emails from a dozen buyers, each with their own budget. An agent owns 30 leads at once. In a Google Sheet, you flatten that into one row per email, and the moment you ask "show me every lead who looked at the Maple Street listing," you're writing FILTER formulas and hoping the address strings match exactly.

In Airtable, you click the Property field on a lead record and you're looking at the linked record. From the property, every lead. From an agent, their workload. Relationships are first-class. If your workflow is two or three properties, a sheet is fine. For a working agent or team, Linked Records pay for themselves the first week.

Linking emails to properties and agents

The one piece Quicktion doesn't do automatically is resolve linked records from email content. If a Zillow inquiry mentions "123 Maple Street," Quicktion won't search your Properties table and link it for you. What it will do is set a static default linked record per destination, useful if a specific forwarding address is dedicated to one listing (a Zillow campaign on a single property).

For the dynamic case, an Airtable Automation on top of the Leads table is the right fit. When a new row gets created, the automation reads the Subject or Body, matches the address against the Properties table with a Find Records step, and updates the Property linked field. Quicktion writes the row; Airtable resolves the link. Same approach works for assigning an Agent by round-robin or geography.

What this looks like end-to-end

A Zillow inquiry hits your inbox at 7:14am for 123 Maple Street. Gmail's filter sees the zillow.com sender and forwards it to your Zillow Quicktion address. Within a few seconds:

1. A new row appears in Leads with Source = "Zillow" (from the default value).
2. AI reads the body and fills Buyer Name = "Sarah Chen", Budget Min = 575000, Budget Max = 625000, Target Neighborhood = "East Side", Timeline = "1-3 months".
3. The email body lands as clean markdown in the Body field. Any photos the buyer attached land in Multiple Attachments.
4. An Airtable Automation matches "123 Maple Street" against your Properties table and links the Property field.
5. A second Automation assigns the lead to whichever Agent has the lowest active count.
6. The kanban view updates. The agent gets a Slack ping from a third Automation.

You haven't opened Gmail.

Getting started

If you want to set this up, start with a Quicktion destination pointed at your Leads table. Build it with one forwarding address first (Zillow is usually highest-volume), confirm the rows look right, then add the rest. The Airtable CRM post covers the linked-records pattern in more depth, and the Gmail integration guide covers the forwarding setup.

Free plan is 25 emails a month, enough to see whether your Zillow notifications parse the way you expect. Pro at $12/month adds AI extraction, default values per destination, and unlimited destinations, which is what you'll want once you're tagging by source.