HTML Market Update Email Newsletter - Jason Pantana: AI + Marketing Training

What this is:

This resource helps you create a professionally designed, insight-rich real estate market update email—automatically. Using Claude’s Artifact feature (or a similar tool), it transforms MLS data you export into a spreadsheet into a polished HTML email that tells the story of your local market.

The prompt doesn’t just format content—it analyzes your MLS data, identifies noteworthy trends, and wraps everything in a layout that’s ready to send to homeowners. It’s perfect for database nurturing, listing lead follow-up, or any moment when a smart market update could spark a conversation.

How To Use It

Review the full prompt below so you understand its key components—personalized greeting, market insight, charts, offline viewing, and PDF support.
Customize the prompt with your local market. Change any references to location (e.g., Franklin, Tennessee) to reflect your target area. Update the date range mentioned in the intro to match your dataset.
Prepare your MLS data in a spreadsheet. You’ll need Closed (sold), Expired, and Withdrawn listings. Label them clearly and define the time period you’re covering in your data. Otherwise, adjust the prompt if you alter your MLS search.
Upload the spreadsheet to Claude when you run the prompt. Attach the spreadsheet directly in Claude and paste in your customized prompt.
Generate the Artifact and review the output. Claude will generate a complete HTML email based on your MLS data. If you want to include your branding (logo, fonts, or colors), just let Claude know in a follow-up prompt and upload a simple brand kit file. You can also ask for layout or content changes, or make manual edits directly in the HTML.
Make any final edits. Ask Claude to make tweaks if you need to adjust layout, style, branding, or tone. You can also edit the HTML manually if needed.
Send it. Copy the final HTML from Claude and paste it into the “Code your own” section of your email service provider (like Mailchimp, Constant Contact, or KVCore). This gives you full control over formatting and ensures the design displays properly in inboxes.

Prompt

Assume the role of a masterful graphic artist and expert in interactive infographic design. Your task is to create an HTML email newsletter based exclusively on the data in the attached spreadsheet. Do not alter, fabricate, or infer any information beyond what is provided. The spreadsheet contains a list of homes in Franklin, Tennessee, categorized by Closed (sold), Expired (unsold during the listing period), and Withdrawn (removed from the market by the seller). This email newsletter will serve as a Real Estate Market Update, presenting key trends through expertly designed charts, graphs, and interactive visual elements to inform and engage homeowners. Use the date range in the data to generate a relevant title that accurately reflects the time period covered.

• • •

**REQUIREMENTS:**
*All instructions listed below must be followed:*

• • •

**Personalized Greeting:**
– Personalize the greeting by addressing the recipient by their first name if available. If no name is present, default to a friendly salutation like “Friend” or “Homeowner.” Format it according to standard email merge tag syntax.

**Compelling Market Insight:**
– Analyze the data to identify one specific and compelling insight that would resonate with homeowners considering selling their property.
– Write a three- to four-sentence paragraph summarizing this key market trend, highlighting a data point that would make a homeowner stop and think about selling.
– Ensure the language is persuasive yet factual, without exaggeration.

**Data Visualization:**
– Develop interactive charts and graphs that help homeowners visualize key trends and performance metrics year-to-date.
– Use only the spreadsheet data—do not add or assume any missing information.

**Offline Functionality:**
– Ensure the entire infographic, including all charts, graphs, and images, is fully viewable and functional in any web browser without an internet connection.

**Expert Design:**
– Apply advanced graphic design principles to create a visually appealing, easy-to-read, and engaging layout.
– Add section headers and concise explanatory text where appropriate to guide the reader through the data.

**PDF Compatibility:**
– Include a “View Full Report & Save as PDF” button that opens the infographic in a web browser, where it is properly formatted for 8.5×11 inch paper (portrait orientation) and includes a built-in “Save to PDF” option for easy downloading.
– Ensure charts and graphs do not get split across pages—they should be properly formatted to start on a new page if needed.
– Maintain clean margins and proper spacing to avoid content cutting off at the edges.

**Coding Standards:**
– Write clean, structured HTML, CSS, and JavaScript that follows best practices for email design.
– Ensure cross-device and cross-email client compatibility.

**Data Integrity:**
– Use exclusively the data provided in the spreadsheet.
– Do not generate, infer, or hallucinate additional information.

By following these instructions, you’ll create a highly effective real estate market update email that engages homeowners, provides valuable data-driven insights, and encourages potential sellers to reach out.

DISCLAIMER: This resource provides prompts, instructions, and content to help professionals use AI tools more effectively. Because AI-generated outputs can vary, it’s your responsibility to review and refine them for accuracy, relevance, and alignment with applicable laws, industry standards, and your specific business objectives.

Back to Program