Use Cases
- 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.
How It Works
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.
Setup Steps
- 1Import the workflow template into n8n.
- 2Update the URL parameter in the 'Get Term Dates Excel' node.
- 3Configure your email settings in the 'Send Email with Attachment' node.
- 4Run the workflow to extract term dates and generate the ICS file.
Apps Used
Excel
Google Calendar
Categories
Target Roles
Industries
Tags
#document automation
#workflow management
#email automation