ManualTrigger Automate

This workflow is ideal for:

• Journalists looking to stay updated with the latest tech news from Y Combinator.
• Content creators who need fresh ideas and inspiration from current events.
• Researchers interested in tech trends and news aggregated in one place.
• Business professionals seeking insights into the tech startup landscape.
• Email marketers wanting to keep their audience informed with curated news content.

This workflow addresses the challenge of manually gathering and organizing the latest tech news from Y Combinator. It automates the process of:

• Fetching news articles from a popular source.
• Extracting relevant information such as titles and URLs.
• Compiling this data into a structured format for easy access.
• Sending automated email notifications with the compiled news, saving time and effort.

1. Manual Trigger: The workflow starts when the user clicks 'execute'.
2. HTTP Request: An HTTP request is sent to fetch the news page from Y Combinator.
3. HTML Extract: The workflow then extracts news titles and URLs from the HTML content using CSS selectors.
4. List News Title: The extracted titles are organized into a list format.
5. List News URL: Similarly, the URLs are compiled into a separate list.
6. Merge: The titles and URLs are merged together based on their index to create a cohesive data set.
7. Spreadsheet File: This merged data is then formatted and saved as a spreadsheet file named Ycombinator_news_YYYY-MM-DD.fileFormat, where YYYY-MM-DD is the current date.
8. Send Email Notification: Finally, an email is sent to the specified recipients with the spreadsheet attached, notifying them of the latest news.