Automate University Term Dates to ICS Calendar
detail.loadingPreview
This n8n workflow intelligently extracts university term dates and key events from publicly available Excel spreadsheets, transforms them into structured data, and then generates a universally compatible iCalendar (.ics) file. Effortlessly add complex academic schedules to your personal calendar with a single click.
About This Workflow
Tired of manually entering academic dates into your calendar? This powerful n8n workflow streamlines the process of converting university term date Excel files into a ready-to-import iCalendar (.ics) file. It begins by securely fetching a specified Excel document, then intelligently extracts event details like week numbers, start dates, and titles using an AI-powered LangChain Information Extractor. The workflow meticulously corrects date formats, converting Excel's unique numbering system into standard date strings. Finally, it compiles this structured data into a standard ICS format, perfect for any calendar application. Say goodbye to manual data entry and hello to automated schedule management.
Key Features
- AI-Powered Data Extraction: Utilizes LangChain's Information Extractor node to intelligently parse event details from semi-structured text derived from Excel.
- Automated Excel Download: Fetches remote Excel files directly via HTTP request, ensuring you always work with the latest published data.
- Dynamic Date Correction: Automatically converts Excel's numeric date formats into ISO 8601 strings, ensuring universal compatibility across calendar applications.
- ICS File Generation: Transforms all extracted and processed events into a standard iCalendar (.ics) file, ready for seamless import into Google Calendar, Outlook, Apple Calendar, and more.
- Customizable Event Schema: The workflow's extraction schema can be easily adapted to capture various event properties, such as descriptions or locations, beyond the default setup.
How To Use
- Set up Google Gemini (LangChain) Credentials: Before running, ensure you have configured your Google Gemini (or Google PaLM) API credentials in n8n, as the
Extract Key Events and Datesnode relies on it for AI processing. - Configure the
Get Term Dates Excelnode: Update theURLparameter to point to the specific Excel.xlsxfile containing the term dates you wish to process. - Adjust
Extract Target Sheet(if needed): This node prepares the raw text for AI extraction. If your source Excel data's relevant section is structured differently, modify thevalueexpression in thetarget_sheetassignment to correctly isolate the required text. - Review
Extract Key Events and DatesSchema: Ensure theinputSchemaaccurately defines the structure of the data you want to extract (e.g.,week_number,week_beginning,title). You can customize it to capture more specific event properties from your source data. - Verify
Fix Datesnode: Thevalueexpression forweek_beginningcontains a specific base date (new Date(2025,8,15,0,0,0)) and an offset. Ensure this base date and the offset (- 45915) correctly align with the Excel date epoch of your specific file to ensure accurate date conversion. - Run the workflow: Trigger the workflow manually. The output will be a binary
.icsfile, available for download, which you can then import into your preferred calendar application.
Apps Used
Workflow JSON
{
"id": "eeede1a3-3e38-4f6c-ac77-f50ea1bc145f",
"name": "Automate University Term Dates to ICS Calendar",
"nodes": 11,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: eeede1a3-3e38...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.