Automated News Extraction and Email Notification Workflow

This n8n workflow automates the process of fetching the latest news headlines from Hacker News, extracting relevant data, saving it into a spreadsheet, and sending an email notification with the news attached. Triggered manually, the workflow begins when the user clicks ‘execute.’ It then makes an HTTP request to Hacker News, retrieves the webpage, and extracts news titles and URLs using HTML extraction nodes. The extracted data is split into separate lists for titles and URLs, which are then merged based on their index positions to align each headline with its URL. The combined data is saved into a structured spreadsheet file named with the current date. Finally, an email notification is sent with the news file attached, providing an automated way to stay updated with the latest headlines.