Skip to content

Open House Follow-Up Pipeline

Example prompt: "After an open house, pull the attendee sign-in sheet from Google Sheets. For each person, check their interest level column. If they marked 'very interested', draft an email offering a private second viewing and CC my colleague. If they marked 'browsing', send a lighter follow-up with links to similar properties. Send all emails from Gmail and log what was sent back to the sheet."

The Problem

Open houses generate a cluster of warm leads, but the window to follow up is narrow. By Monday morning, agents are already onto the next listing and the sign-in sheet from Saturday's viewing sits untouched. Writing individual follow-ups — different tones for keen buyers versus casual browsers — takes time agents rarely have, and batch emails feel impersonal enough to waste the goodwill built in person.

How GloriaMundo Solves It

We build a workflow you run the day after an open house. An integration step reads the attendee list from Google Sheets, including each person's name, email, and interest level noted during the event. A conditional step splits attendees into groups based on that interest level. An LLM step drafts a personalised follow-up for each person — offering serious buyers a private viewing and sending browsers details of similar listings. Integration steps send the emails via Gmail and update the spreadsheet with the date and type of follow-up sent. Glass Box preview lets you review every email before it goes out, so you can adjust the tone or add a personal note for someone you particularly want to nurture.

Example Workflow Steps

  1. Trigger (manual): Agent runs the workflow after an open house event.
  2. Step 1 (integration): Read the attendee sign-in sheet from Google Sheets, pulling name, email, phone, and interest level.
  3. Step 2 (conditional): Split attendees into "very interested" and "browsing" groups based on their interest column.
  4. Step 3 (llm): Draft personalised emails — private viewing offers for keen buyers, lighter follow-ups with similar property links for browsers.
  5. Step 4 (integration): Send all follow-up emails via Gmail from the agent's address.
  6. Step 5 (integration): Update the Google Sheet with the follow-up date and email type for each attendee.

Integrations Used

  • Google Sheets — stores the attendee sign-in data and tracks follow-up status
  • Gmail — sends the personalised follow-up emails

Who This Is For

Residential estate agents who run open houses regularly and want to follow up with every attendee within 24 hours without spending an entire Sunday evening writing emails.

Time & Cost Saved

Following up with 20 open house attendees manually — checking notes, writing individual emails, logging what was sent — typically takes 1.5–2 hours. This workflow reduces that to a 10-minute review of the Glass Box preview. The combination of integration, conditional, and LLM steps costs a moderate number of credits per run.