Summarize school circular emails with Gmail, Gemini, and Google Sheets
Ready for 3.0Ready 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 15 nodes and runs on Gmail events. Along the way it connects Gmail, Google Sheets and Google Gemini.
How it runs
Trigger: On Gmail events.
- Standardize Email Metadata (Code): runs custom JavaScript code
- Check for Circular Attachment (If): checks a condition and branches into true / false
- Fetch Email Attachment Content (Gmail): get
- Extract Circular PDF Text (Extract from File): extracts data from a file (pdf)
- Check OCR Requirement (If): checks a condition and branches into true / false
- Prepare OCR Fallback Content (Code): runs custom JavaScript code
- Assemble Final Circular Text (Code): runs custom JavaScript code
- Generate Circular Duplicate Key (Code): runs custom JavaScript code
- Search Existing Circular Log (Google Sheets): uses Google Sheets
- Check Duplicate Status (If): checks a condition and branches into true / false
…plus 4 more steps. See the full node list below.
Services it uses
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.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (School Email Trigger).
Nodes used (7)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Extract from File
n8n-nodes-base.extractFromFile - Google Sheets
n8n-nodes-base.googleSheets - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini
From the author
Quick Overview This workflow monitors a labeled Gmail inbox for school circulars, extracts text from attached PDFs, uses Google Gemini to generate a structured parent-friendly digest, logs the results to Google Sheets for de-duplication, and emails the final…