n8n

How to Automate OpenAI Executive News Digest?

Deliver a daily, AI picked news brief to leaders who need quick updates. It collects headlines from two sources, ranks the top five for a senior decision maker, and sends a clean email summary every morning. Ideal for executives who want signal over noise.

The flow starts on a schedule. It reads two RSS feeds, merges the stories, removes duplicates and bad items, and sorts by publish time. ChatGPT chooses the five most relevant links. For each chosen link, the flow loads the web page, pulls a short subtitle with CSS rules for each site, cleans the text, and builds a right to left HTML email. The date is set to Israel time, and the email is sent by SMTP.

Results include a consistent brief with less manual reading and fewer distractions. Setup needs an OpenAI API key and an email account with SMTP. Update feed URLs, the CSS selectors, and the email template to match your brand. Expect a clear summary in the inbox at the same time each day with a strong cut in prep time.

What are the key features?

  • Schedule trigger runs the digest at a set time each day
  • Reads two RSS feeds and merges them into one unified list
  • Removes empty or invalid items and sorts stories by publish date
  • Custom code deduplicates articles by link and cleans the list
  • ChatGPT 4o selects the five most relevant stories for a senior leader
  • Fetches each article page and extracts subtitles with site specific CSS selectors
  • Builds a right to left HTML email with branding and clear layout
  • Formats the date in the Israel timezone and sends email by SMTP

What are the benefits?

  • Reduce manual scanning from 30 minutes to 5 minutes each day
  • Automate 90 percent of article curation with AI
  • Improve relevance with a ranked top five picked for executives
  • Deliver at the same time every day using a fixed schedule and timezone
  • Unify two news sources and remove 100 percent of duplicate links
  • Support right to left reading for clear local language emails

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with OpenAI and Gmail. See the Tools Required section above for links to create accounts with these services.
  3. Open the Schedule Trigger and set the run time that fits your morning routine. If needed, set the timezone to match your team.
  4. Double click each RSS Feed node and confirm the feed URLs for your sources. Click Execute Node to make sure items load as expected.
  5. Check the merge and clean steps: run the Merged RSS, Remove NaN, Sort List, and Clean List nodes one by one. Confirm that duplicates are removed and the list is sorted by date.
  6. Open the ChatGPT 4o node. In the 'Credential to connect with' dropdown, click 'Create new credential' and paste your OpenAI API key from your OpenAI account. Keep the model as gpt 4o and JSON output enabled.
  7. Test the ChatGPT 4o node with sample data and confirm it returns five selected articles in JSON. Adjust the system message if you want different selection rules.
  8. Verify the HTTP Request and Extract Text nodes. Execute one article and check that the CSS selectors return a subtitle. Update selectors if the source sites change their HTML.
  9. Open the Create HTML node and update the email style, colors, and logo. Keep the right to left setting if you need that layout.
  10. Configure email sending: double click the Send Daily News node, set From, To, and Subject, then in the credential dropdown choose 'Create new credential' and enter your SMTP server, port, username, and app password. Send a test email to confirm delivery.
  11. Review the Get Date function to ensure the timezone is correct for your region. Update it if your team is in a different location.
  12. Enable the workflow. Check the Executions list after the first run. If emails fail, verify SMTP settings or allow app passwords. If the AI step fails, confirm your OpenAI key and rate limits.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Gmail

Sign up

No cost: Personal Gmail (Gmail API has no usage-based pricing; quotas apply)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Credits:
Elay Guez

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.