ManualTrigger Automate

ManualTrigger Automate streamlines the process of gathering the latest news from Y Combinator, extracting key titles and URLs, and compiling them into a spreadsheet. This automated workflow not only saves time but also ensures timely updates, allowing users to receive email notifications with the latest news attached, enhancing information accessibility and efficiency.

7/8/2025
8 nodes
Medium
emailmediumhtmlextractitemlistsspreadsheetfileemailsendapiintegrationfilesstoragenotification
Categories:
Medium WorkflowEmail Triggered
Integrations:
HtmlExtractItemListsSpreadsheetFileEmailSend

Target Audience

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.

Problem Solved

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.

Workflow Steps

  • 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.

    • Customization Guide

    Users can customize this workflow in several ways:
    - Email Settings: Modify the toEmail and fromEmail fields to set the desired sender and recipient addresses.
    - File Format: Change the fileFormat parameter to save the spreadsheet in different formats (e.g., .xlsx, .csv).
    - CSS Selectors: Adjust the CSS selectors in the HTML Extract node to capture different elements from the news page, should the structure change.
    - Trigger Type: Users can change the trigger mechanism from manual to automated, such as scheduling the workflow to run at specific intervals.
    - Additional Nodes: Integrate more nodes for further processing, such as filtering news based on keywords or integrating with other applications.