Pull name, phone, and property from listing lead emails into a sheet

Lead notification emails arrive in Gmail. OpenAI extracts the contact and the property, the row goes into Google Sheets, and Slack gets a note.

Updated .

A guide, not professional advice. Test before you use it for real. See terms.

A real-estate agent or small brokerage that receives lead notifications by email.

Not sure which one to use? See Make vs n8n.

Problem

Leads from listing sites arrive as emails in different formats, and agents copy them by hand.

What you need

GmailOpenAIGoogle SheetsSlackMaken8n

How it connects

Steps

  1. Label the lead emails

    Create a Gmail filter that labels notifications from your listing sites, for example by sender address. The flow only reads that label.

  2. Watch the label

    Make: Gmail Watch emails, Filter type Gmail filter, with label:leads. n8n: Gmail Trigger with the same search.

  3. Extract the fields

    Send the subject and body to OpenAI. Ask for JSON with name, phone, email, property address or listing id, and message. Tell it to leave a field empty when the email doesn't say it, never to guess.

  4. Add the row

    Make: Add a Row. n8n: Append Row. Include the received date and the Gmail message id so anyone can open the original.

  5. Ping the agent

    Slack Send a Message (Make) or Message > Send (n8n) with the name, property, and a link to the row. The agent calls; the flow doesn't contact the lead.

Time

Build time is about 45 minutes, estimated by the recipe’s author. It is not a measured average.

Saves retyping each lead. The model can misread a field, so the row keeps a link to the original email.

Cost

The OpenAI API is billed by usage. Gmail and Sheets come with the Google account. Slack, and Make or n8n per their current pricing.

What it doesn’t do

It doesn’t connect to any listing site’s API or reply to leads. If a site changes its email format, check the first few rows again. Phone numbers the model returns should be checked before a call.

Build it

The account is yours. The Make link is an affiliate link.

Create an n8n accountSee MakeMore real estate recipes

Sources

Similar recipes