Case Study No. 1

AI Agent that fetches Real Estate news and generates Headlines, Subheadlines, and Viral Scores.

A client is seeking an n8n automation expert to build a hands-free workflow that sends out a daily curated email featuring real estate news articles with viral social media potential.

The automation should scrape top real estate news daily, evaluate each article’s viral potential using AI, generate a headline and subheadline, and compile everything into an email sent at 8:00 AM each day.

Project Objectives

Design and implement a fully automated, low-maintenance workflow that:

  • Scrapes trending real estate news articles daily.
  • Uses AI to evaluate each article’s social media virality potential.
  • Generates a headline and subheadline per article.
  • Compiles the data into a structured daily email digest.
  • Sends the digest at 8:00 AM daily, with clickable source links.

All components, from scraping to AI generation to delivery, must be automated using n8n, with minimal manual upkeep required post-deployment.

Scope of Work
  • Scrapes trending real estate news articles daily.
  • Run daily at 8:00 AM on a schedule.
  • Scrape top real estate news from Google News or similar sources using RSS feeds, HTTP requests, or third-party scraping tools (e.g., Apify).
  • Use AI (e.g., OpenAI) to evaluate each article's viral potential for social media.
  • Generate a custom headline and subheadline for each article using AI.
  • Include the original source URL for each article.
  • Compile the curated results into an email digest, formatted clearly and professionally.
  • Send the email using an n8n-compatible SMTP provider, Mailgun, or similar email module.
  • Integrate and configure all steps end-to-end within n8n for seamless automation.
  • Ensure the entire workflow is low-maintenance, self-reliant, and runs reliably each day.
  • Leverage external APIs or scrapers where needed for accurate article extraction.
  • Provide lightweight documentation for troubleshooting, maintenance, or future updates.

The Solution

A fully automated Real Estate News Curation AI Agent was built using n8n, OpenAI, Google Sheets and Email.

Triggered daily at 8:00 AM using n8n’s scheduler, the workflow handles the entire process from scraping top real estate news via Google News RSS Feeds, evaluating each article’s social media virality using AI, and generating compelling headlines and subheadlines. The curated results are stored in Google Sheets and automatically sent as a structured email digest. The system runs reliably with minimal upkeep, providing consistent and accurate daily updates.

Want the full implementation?

The video below breaks it down step by step.

Play Icon - Elements Webflow Library - BRIX Templates
Set-up

Before setting up the automated workflow in n8n, ensure that the Google Sheet is properly
structured to store incoming data. The sheet should have clearly labeled columns to support smooth integration and accurate data logging. The recommended column setup is as follows:

1

Date Added

Records the date the article was processed and added to the sheet

2

Article Title

Stores the original title of the real estate news article

3

Article URL

Contains the source link to the full article

4

Headline

Includes the AI-generated headline designed to attract attention

5

Subheadline

Includes the AI-generated subheadline that provides supporting context

6

Viral Score

Stores the AI-evaluated score estimating the article's potential to go viral on social media

Building the Solution

1Scraping Real Estate News from Google News RSS Feeds

The workflow begins with n8n’s built-in Schedule Trigger, set to run daily at 8:00 AM. It activates the RSS Feed Read node, which pulls the latest real estate news from a designated Google News RSS feed.

This setup ensures the system checks for new content every day and processes only the freshest articles. The RSS Feed Read node automatically detects and retrieves newly published links, keeping the curated results relevant and timely.

Use the following RSS URL format to get real estate news:

How Prompt Engineering powers this AI Agent

What makes this solution work so well isn’t just the use of advanced AI models, but the way each prompt is carefully designed. Every step that involves AI uses a combination of four key prompt techniques: zero-shot prompting, role instructioning, input referencing, and output constraints.

These methods tell the AI what to look for, how to respond, and how to deliver clear, useful results. Because of this, the curated real estate news comes out exactly the way it should, accurate, engaging, and ready to share. No manual editing, no confusion. Just smart automation doing its job well.
Schedule a call

2Headline Creation Using OpenAI

For each new article, the agent uses OpenAI’s GPT-4o model to create headlines that are designed to catch attention and perform well on social media.

The prompt is carefully crafted to help the AI highlight the most compelling parts of each story while staying aligned with current content trends. This removes the need for manual copywriting and makes the curated results more shareable, consistent, and effective.

Headline Engineering: Smart Prompting

You are a news content generator.

You will be provided with multiple news updates in an unstructured format. For each one, your task is to generate a compelling Headline that highlights the key point of the news and is optimized for viral social media potential.

Here’s the first batch of news updates:

Title: {{title}}

Snippet: {{snippet}}

URL: {{url}}

Return only the Headline per article. Do not include any other text, explanation, or additional formatting.

You are a news content generator.

Prompt Breakdown

using Zero-Shot Prompting

Prompting Technique

How it's used?

Zero-Shot Prompting
The AI generates a headline without relying on pre-written examples, ensuring each output is original and adaptable to the unique tone and topic of the news.
Role Instructioning
The AI is framed as a news content generator, ensuring it consistently produces engaging headlines tailored for social media virality.
Input Reference
The prompt references structured inputs (title, snippet, URL) so the AI knows exactly what to analyze and how to craft the final headline.
Output Constraints
The AI is explicitly instructed to output only the headline for each article, no additional explanations or extra formatting, guaranteeing clean, ready-to-use headlines.

3Subheadline Generation with OpenAI

Once the headline is done, the workflow passes the article details to a separate GPT-4o node to generate the subheadline. 

This second prompt adds supporting context to the headline, teasing more detail and drawing the reader in. It helps make each article more engaging and is perfect for use in social posts or email newsletters.

Subheadline Crafting: Smart Prompting

You are a news content generator.

You will be provided with multiple news updates in an unstructured format. For each one, your task is to write a concise Subheadline that expands on the story’s main point, adding context and detail to the primary headline.

Here’s the first batch of news updates:

Headline: {{results}}

Title: {{title}}

Snippet: {{snippet}}

URL: {{url}}

Return only the Subheadline per article. Do not include any other text, explanation, or additional formatting.

You are a news content generator.

Prompt Breakdown

using Zero-Shot Prompting

Prompting Technique

How it's used?

Zero-Shot Prompting
The AI generates a headline without relying on pre-written examples, ensuring each output is original and adaptable to the unique tone and topic of the news.
Role Instructioning
The AI is framed as a news content generator, ensuring it consistently produces engaging headlines tailored for social media virality.
Input Reference
The prompt references structured inputs (title, snippet, URL) so the AI knows exactly what to analyze and how to craft the final headline.
Output Constraints
The AI is explicitly instructed to output only the headline for each article, no additional explanations or extra formatting, guaranteeing clean, ready-to-use headlines.

4Viral Score Calculation Using OpenAI

To measure how likely each article is to go viral, the workflow sends it to another GPT-4o node dedicated to calculating a Viral Score. 

This score gives a quick snapshot of the article’s viral potential by analyzing factors like topic relevance, emotional tone, and headline strength. It helps prioritize which articles to feature more prominently in social campaigns or email highlights.

Viral Score Analysis: Measuring Impact Potential

You are a social media engagement expert.

You will be provided with multiple news updates in an unstructured format. For each one, your task is to analyze the article’s viral social media potential and return a Viral Score from 0 to 100 based on the following weighted criteria:

Clickbait strength (30%)
Relevance to current real estate trends (25%)
Social shareability (20%)
Emotional triggers (15%)
Clarity and conciseness (10%)

Here’s the first batch of news updates:

Title: {{title}}
Snippet: {{snippet}}
URL: {{url}}

Return only the Viral Score (as a number from 0 to 100) per article. Do not include any other text, explanation, or additional formatting.

You are a social media engagement expert.

Prompt Breakdown

using Zero-Shot Prompting

Prompting Technique

How it's used?

Zero-Shot Prompting
The AI calculates the Viral Score without relying on pre-existing examples, making it adaptable to any real estate news content provided.
Role Instructioning
The AI is assigned the role of a “social media engagement expert,” ensuring it focuses on scoring each article’s potential for virality using the specified criteria.
Input Reference
The prompt references structured inputs (title, snippet, URL), guiding the AI to analyze the right context for each article’s viral potential.
Output Constraints
The AI is instructed to return only the Viral Score
(0–100) for each article, no explanations or additional formatting, ensuring the data is clean and ready for analysis.

5Automated Google Sheets Logging

The agent automatically records each article’s details including date added, title, URL, headline, subheadline, and viral score into a structured Google Sheet.

To capture the exact time each article is processed, the date field is set using this expression in the n8n node:

This setup creates a centralized and searchable log of curated content, making it easy to track trends, generate reports, and plan future content with confidence.

6Curated Data Delivery via Email

After compiling the curated results, the system sends a clean daily summary straight to the user’s inbox. The email includes a direct link to the Google Sheet containing the curated news, along with a customizable subject line—for example: June 6, 2025 Real Estate News Updates. The subject can be adjusted to match branding, tone, or specific user preferences.

In n8n, to ensure that only one email is sent per run and to avoid duplicates, add a Code node before the Gmail node with the following script:

This script compiles all curated items into a single HTML-formatted body. The Gmail node can then send this as one consolidated message.

Each email provides quick access to article headlines, subheadlines, source URLs, and viral scores—offering users a clear snapshot of high-potential real estate content in one convenient summary.

This final step ensures curated insights are not only archived for future analysis but also made instantly accessible, seamlessly closing the loop in the automated curation pipeline.

Results at a glance.
This wasn’t just an automated news curation setup. It was a fully functioning AI powered agent, built with smart prompt engineering and smooth workflow automation.

By combining AI generated headlines, subheadlines, viral scoring, and structured data logging, the client now benefits from faster content delivery and clearer insights every single day.

Consistent Daily Updates

The AI powered workflow ensures new real estate news is curated and delivered daily, eliminating manual tracking.

Engaging, Viral Ready Headlines

Smart AI prompting consistently generates attention grabbing headlines and subheadlines designed for social media.

Data Driven Viral Potential

Viral scoring (0 to 100) offers instant insights into which articles are likely to perform well on social platforms.

Reliable, Automated Pipeline

With Google Sheets and automated emails, the solution runs without intervention, delivering clean and structured outputs for each new article.

Strategic and Prompt Engineering Insight

This implementation offers a key takeaway. The true strength of this automated real estate news curation agent comes from its prompt design. While OpenAI models handle the generation of headlines, subheadlines, and viral scores, the real value lies in how each prompt is intentionally crafted, connected, and aligned throughout the entire workflow to deliver consistent and accurate results.

The process follows a clear, modular structure. It starts with a single input, a daily update from an RSS feed. From there, the workflow smoothly transitions through a series of AI powered nodes. The agent uses well designed prompts to generate compelling headlines, expand them into concise subheadlines, and assess viral potential through a weighted scoring system. Once complete, the results are saved directly into Google Sheets for organized and reliable record keeping. The final step sends a curated daily email to the user, with no manual effort needed.
This layered flow, from incoming data to structured AI output, is powered by techniques like zero shot prompting, role based instructions, direct input referencing, and defined output formatting. Each node builds on the last, removing the need for complex logic, manual post processing, or custom code while making sure every detail is captured cleanly in real time.

The result is a lean and dependable news curation engine that delivers fresh, shareable content and complete data accuracy every day.

What's next?

Book a Call

This AI agent shows that when automation is guided by smart prompt design, the result is not just efficiency. It is transformation.

If you are tired of juggling disconnected tools, rewriting the same content, or struggling to stay consistent with your brand, this is your blueprint.
‍

Built once. Scales without limits.

Whether you are a solo founder, a lean team, or a growing agency, this automation agent can be cloned, tailored, and launched to match your exact workflow and voice.

Ready to build your own AI-Powered content engine without sacrificing quality?

Fill out the form and let’s get started.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.