Extract term dates from Excel to create ICS calendar events

• Automate the extraction of academic term dates from Excel files.
• Generate ICS files for easy import into calendar applications.
• Enhance scheduling accuracy for educational institutions.

Fetch term dates Excel file from a specified URL. Convert the Excel data into a markdown format for processing. Extract relevant events and dates using AI information extraction. Sort extracted events by date for better organization. Create an ICS file containing the sorted events. Send the ICS file via email to designated recipients.

1. 1
   Import the workflow template into n8n.
2. 2
   Update the URL parameter in the 'Get Term Dates Excel' node.
3. 3
   Configure your email settings in the 'Send Email with Attachment' node.
4. 4
   Run the workflow to extract term dates and generate the ICS file.