Templates / Extract university term dates from Excel using CloudFlare markdown conversion

Extract university term dates from Excel using CloudFlare markdown conversion

Ready for 3.0

by Jimleuk ✓ · 1,300 views · created 2025-04-10 · Document Extraction, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What 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”.

  1. Get Term Dates Excel (HTTP Request): calls westminster.ac.uk
  2. Markdown Conversion Service (HTTP Request): calls api.cloudflare.com (POST)
  3. Extract Target Sheet (Edit Fields (Set)): sets 1 field: target_sheet
  4. Extract Key Events and Dates (Information Extractor): extracts structured fields from text with AI, with model: Google Gemini Chat Model
  5. Events to Items (Split Out): splits a list into separate items
  6. Fix Dates (Edit Fields (Set)): sets 1 field: week_beginning
  7. Sort: sorts the items
  8. Events to ICS Document (Code): runs custom Python code
  9. Create ICS File (Convert to File): converts data to a file (to binary)
  10. Send Email with Attachment (Gmail): uses Gmail

Services it uses

Google Gemini Chat ModelGmail

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)

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…

Excerpt from Jimleuk's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.