# Real Estate Open House Thank You Card Mailer

> Automates personalized thank-you greeting cards for open house attendees. Pulls the latest attendee list from Google Sheets (names, addresses, and interests), scrapes the property listing photo AND property details from realtor.com, verifies address match, then creates and mails a custom folded greeting card to each attendee. The front features the listing photo, the back has the agent's logo, and the inside contains a personalized thank-you message with action-provoking phrases that reference ONLY factual property features verified from the listing.

Content type: workflow
Source URL: https://www.agentpmt.com/agent-workflow-skills/real-estate-open-house-thank-you-card-mailer
Markdown URL: https://www.agentpmt.com/api/agent/workflows/real-estate-open-house-thank-you-card-mailer?format=agent-md
Updated: 2026-03-24T16:20:20.897Z
Author: firef1ie

---

Estimated time saved: 60 minutes.

## Tools

- Google Sheets
- Live Web Page Browser
- Send a Custom Greeting Card

## Workflow Outline

1. Get Open House Attendee List: Search the user's Google Sheets for the most recent spreadsheet with 'Open House' or 'Attendee' in the title. Read all rows from the sheet. Expected columns include: First Name, L...
2. Search and Get Listing Photo: Using the property address extracted from the Google Sheet title in the previous step, search for the listing on realtor.com. First, navigate to realtor.com and use their search f...
3. Verify Listing Address Match: Goal: Verify that the property listing found on realtor.com matches the exact address from the Google Sheet title before proceeding. | Inputs: Property address extracted from Google Sheet title AND the property details/...
4. Extract Verified Property Features: Goal: Extract factual property details from the realtor.com listing page to ensure personalized messages only reference real, verified features. | Inputs: Full HTML/markdown content from the realtor.com listing page. |...
5. Prepare Personalized Card Messages: Goal: For each attendee from the spreadsheet, generate a personalized inside-right message for their thank-you greeting card using ONLY verified property features. | Inputs: List of attendees with first name, last name,...
6. Send Card to Each Attendee: Repeat this section for each attendee_card. Iterate over each attendee card payload prepared in the previous step. For each attendee, send a custom greeting card using the Send a Cust...
7. Mail Greeting Card: Send a custom greeting card for the current attendee using these panel assignments: - front_cover_image_url: Use the listing photo URL extracted from realtor.com in the earlier st...
8. Generate Summary Report: Goal: Summarize all cards sent and provide a completion report to the user. | Inputs: Results from all greeting card send operations - success/failure status for each attendee. | Outputs: A clear summary listing: total...