Curate RSS Feeds into Daily Content Ideas via Email (with Notion & Telegram options)

This n8n workflow is designed to automate the process of gathering and curating content ideas from multiple RSS feeds, delivering them to your inbox daily, with optional integration for Notion and Telegram. It helps you stay updated with your favorite sources and never miss out on potential content inspiration.

What it does

1. Schedules Daily Execution: The workflow runs automatically on a daily schedule (or can be triggered manually for testing).
2. Reads RSS Feeds: It fetches the latest articles from a list of configured RSS feeds.
3. Processes Feed Items: For each article found, it extracts relevant information such as title, link, and description.
4. Formats Content Ideas: It structures the extracted information into a digestible format suitable for content ideas.
5. Sends Daily Email Digest: Compiles all the curated content ideas into a single email and sends it to a specified recipient.
6. Optional: Saves to Notion: If configured, it can create new database items in Notion for each content idea, allowing for further organization and tracking.
7. Optional: Sends to Telegram: If configured, it can send individual content idea summaries to a Telegram chat, providing quick notifications.
8. Error Handling: Includes a basic error trigger to notify you if the workflow encounters an issue during execution.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Email Account: An SMTP server or email service configured in n8n for sending emails.
• RSS Feed URLs: A list of RSS feed URLs you wish to monitor.
• Notion (Optional): A Notion account and an integration token with access to a specific database if you want to save content ideas there.
• Telegram (Optional): A Telegram Bot Token and Chat ID if you want to receive notifications via Telegram.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, click "Workflows" in the left sidebar.
   • Click "New" -> "Import from JSON" and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Send Email: Update the "Send Email" node with your SMTP credentials or select an existing email credential.
   • Notion (Optional): If using Notion, configure a Notion credential with your API token and ensure it has access to the target database.
   • Telegram (Optional): If using Telegram, configure a Telegram credential with your Bot Token.
3. Customize Nodes:
   • Cron: Adjust the schedule in the "Cron" node to your preferred daily time.
   • RSS Read: Add or modify the RSS feed URLs in the "RSS Read" node to include your desired sources.
   • Edit Fields (Set): Review and adjust how data is mapped or transformed if needed.
   • Function: This node likely contains JavaScript logic for formatting the content. Review and modify it if you need a different output structure.
   • Send Email: Update the "To" email address and customize the subject and body of the email digest.
   • If (Notion/Telegram): These If nodes control whether content is sent to Notion or Telegram. Enable or disable them based on your needs.
   • Notion (Optional): If enabled, configure the "Notion" node with your Notion database ID and map the incoming data fields to your Notion database properties.
   • Telegram (Optional): If enabled, configure the "Telegram" node with your Chat ID and customize the message format.
   • Error Trigger: Configure the "Error Trigger" node to send notifications to your preferred channel (e.g., email, Slack) in case of workflow failure.
4. Activate the Workflow: Once configured, activate the workflow by toggling the "Active" switch in the top right corner of the workflow editor.

The workflow will now run automatically based on your schedule, delivering curated content ideas to you.