If

For the If workflow, automate the collection and classification of sustainability news articles from the EU News website every morning at 08:30 AM. It filters articles based on their relevance to sustainability, generates a visually appealing email digest, and sends it to your mailing list, ensuring timely updates on important environmental topics. Integrates seamlessly with LangChain, Google Sheets, and Gmail for efficient data management and communication.

7/8/2025
21 nodes
Complex
schedulecomplexlangchaingooglesheetsgmailschedule triggersplitoutsplitinbatchessticky noteautomationadvancedlogicconditionalcronapiintegration
Categories:
Communication & MessagingSchedule TriggeredComplex WorkflowData Processing & Analysis
Integrations:
LangChainGoogleSheetsGmailSchedule TriggerSplitOutSplitInBatchesSticky Note

Target Audience

This workflow is designed for:
- Environmental Advocates: Individuals or organizations focused on sustainability and environmental issues, looking to stay updated on relevant news.
- Researchers and Academics: Those who require curated information on sustainability for studies or publications.
- Businesses: Companies aiming to align their operations with sustainable practices and wanting to keep track of industry developments.
- Newsletter Creators: Marketers or content creators who wish to distribute sustainability-related news to their audience effectively.

Problem Solved

This workflow addresses the challenge of staying informed about sustainability news by automating the collection, classification, and dissemination of relevant articles. It ensures that users receive a daily digest of news articles that are specifically marked for their relevance to sustainability, thus saving time and effort in manual searches.

Workflow Steps

  • Trigger at 08:30 AM: The workflow initiates every morning at 08:30 AM, ensuring timely updates.
    2. Query EU News Website: It fetches the latest news articles from the EU's official news site.
    3. Extract Articles: The workflow extracts article blocks containing essential information such as title, link, image, and description.
    4. Parse Article Blocks: Each article is parsed to gather relevant details for further processing.
    5. Filter Articles: An If node filters the articles based on the date (5 days back) and type (specifically looking for 'News article').
    6. Loop Over Articles: The workflow processes each article individually to classify its relevance to sustainability.
    7. Agent Classification: Utilizing an AI model, each article's title and description are analyzed to determine if it is related to sustainability.
    8. Flag Sustainability: Articles confirmed as relevant are flagged accordingly.
    9. Merge Data: The original article data is combined with the sustainability flag.
    10. Record Results: Finally, the relevant articles are recorded in a Google Sheet for easy access and future reference.
    11. Generate Email HTML: An HTML email is generated to summarize the articles.
    12. Send Email: The digest is sent to a specified mailing list, keeping subscribers informed.

    • Customization Guide

    Users can customize the workflow by:
    - Adjusting the Trigger Time: Modify the schedule trigger to fit their preferred time for receiving updates.
    - Changing the News Source: Update the HTTP request URL to fetch articles from different websites or sources.
    - Modifying the Filters: Alter the conditions in the If node to include different types of articles or adjust the date range.
    - Customizing Email Content: Edit the HTML code in the Generate Email HTML node to change the email's appearance and content.
    - Altering Google Sheets Settings: Change the document ID and sheet name in the Record Results node to store data in a different Google Sheet.