
Real Estate Open House Thank You Card Mailer
Saves ~1 hr
Details
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.
Tools In This Workflow
Workflow Steps
- 1Get Open House Attendee List
- 2Search and Get Listing Photo
- 3Verify Listing Address Match
- 4Extract Verified Property Features
- 5Prepare Personalized Card Messages
- 6Send Card to Each Attendee
- 7Mail Greeting Card
- 8Generate Summary Report
Step 1 of 8
Tool1
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, Last Name, Address (street, city, state, zip), and optionally Interests or Notes about what the attendee liked about the property. IMPORTANT: The property address for the open house listing is contained in the title of the Google Sheet itself (e.g. 'Open House - 123 Main St, Springfield IL'). Extract the property address from the sheet title as it will be needed in the next step to find the listing photo on realtor.com. If no interests column exists, leave interests blank. Return all attendee data as structured records plus the property address extracted from the sheet title. Ask the user which sheet to use if multiple matches are found.





