Extract university term dates from Excel using CloudFlare markdown conversion
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Gemini Chat Model and Gmail. It also calls westminster.ac.uk and api.cloudflare.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Term Dates Excel (HTTP Request): calls westminster.ac.uk
- Markdown Conversion Service (HTTP Request): calls api.cloudflare.com (POST)
- Extract Target Sheet (Edit Fields (Set)): sets 1 field: target_sheet
- Extract Key Events and Dates (Information Extractor): extracts structured fields from text with AI, with model: Google Gemini Chat Model
- Events to Items (Split Out): splits a list into separate items
- Fix Dates (Edit Fields (Set)): sets 1 field: week_beginning
- Sort: sorts the items
- Events to ICS Document (Code): runs custom Python code
- Create ICS File (Convert to File): converts data to a file (to binary)
- Send Email with Attachment (Gmail): uses Gmail
Services it uses
HTTP calls to: westminster.ac.uk, api.cloudflare.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Edit Fields (Set)
n8n-nodes-base.set - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Convert to File
n8n-nodes-base.convertToFile - Code
n8n-nodes-base.code - Sort
n8n-nodes-base.sort - Split Out
n8n-nodes-base.splitOut - Gmail
n8n-nodes-base.gmail
From the author
This n8n template imports an XLSX containing terms dates for a university, extracts the relevant events using AI and converts the events to an ICS file which can be imported into iCal, Google Calendar or Outlook. Manually adding important term dates to your…