ManualTrigger Automate

For ManualTrigger Automate, streamline the process of importing university term dates from an Excel file, extracting key events using AI, and generating an ICS calendar file for easy sharing. This workflow automates tedious data entry, ensuring accurate event organization and seamless integration with calendar applications like iCal, Google Calendar, and Outlook. Save time and enhance productivity by automating the extraction and distribution of important academic dates.

7/8/2025
18 nodes
Complex
manualcomplexlangchainconverttofilesticky notesplitoutgmailadvancedapiintegrationfilesstorage
Categories:
Communication & MessagingComplex WorkflowManual Triggered
Integrations:
LangChainConvertToFileSticky NoteSplitOutGmail

Target Audience

This workflow is ideal for:
- University Students: Those looking to automate the process of adding term dates to their calendars.
- Administrative Staff: Individuals responsible for managing academic calendars and communications.
- Educators: Teachers and professors who want to share important dates with students effortlessly.
- Developers: Tech-savvy users interested in integrating AI and automation into existing systems.

Problem Solved

The workflow addresses the tedious task of manually inputting academic term dates into calendars. It automates the extraction of dates from an Excel file and formats them into an ICS file for easy import into calendar applications like iCal, Google Calendar, and Outlook. This saves time and reduces the potential for human error in data entry.

Workflow Steps

  • Manual Trigger: The workflow starts when the user clicks ‘Test workflow’.
    2. Get Term Dates: It fetches the term dates from a specified Excel file hosted online.
    3. Markdown Conversion: The Excel file is converted into a markdown format using Cloudflare's Markdown Conversion Service.
    4. Extract Events: Key events and dates are extracted from the markdown using an AI Information Extractor.
    5. Sort Events: The extracted events are sorted by their dates to ensure chronological order.
    6. Fix Dates: Adjustments are made to the date format for consistency.
    7. Generate ICS Document: The sorted events are transformed into an ICS file format suitable for calendar applications.
    8. Email the ICS File: Finally, the ICS file is sent as an email attachment to the specified recipient.

    • Customization Guide

    Users can customize this workflow by:
    - Updating the Excel File URL: Modify the URL in the 'Get Term Dates Excel' node to point to a different Excel file containing relevant data.
    - Changing Email Recipients: Update the 'Send Email with Attachment' node to change the recipient's email address and customize the message.
    - Modifying AI Extraction Logic: Adjust the parameters in the 'Extract Key Events and Dates' node to refine how events are extracted based on the structure of the new Excel files.
    - Customizing Calendar Event Details: Users can enhance the ICS file generation by adding more event properties or modifying the Python code in the 'Events to ICS Document' node to include additional details like descriptions or locations.