Extracts and organizes academic publications using GPT-4 Mini, Google Sheets, Gmail
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 23 nodes and runs when someone submits an n8n form (“Academic Staff Publication”). Along the way it connects OpenAI Chat Model, Google Sheets and Gmail.
How it runs
Trigger: When someone submits an n8n form (“Academic Staff Publication”).
- Fetch website content (HTTP Request): calls an HTTP API
- Extract all publications from the page (HTML): parses or builds HTML
- Separate Each Publication (Split Out): splits a list into separate items
- Generate Summary Report (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
- Format as CSV Export (Convert to File): converts data to a file
- Save All to Master Sheet (Google Sheets): append
- Send Notification Email (Gmail): uses Gmail
- Calculate Publication Statistics (Count) (Summarize): summarizes / groups the items
- Switch: routes items into 5 branches
- Sort: sorts the items
…plus 11 more steps. See the full node list below.
Services it uses
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
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 (12)
- HTTP Request
n8n-nodes-base.httpRequest - HTML
n8n-nodes-base.html - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - n8n Form Trigger
n8n-nodes-base.formTrigger - Switch
n8n-nodes-base.switch - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Convert to File
n8n-nodes-base.convertToFile - Sort
n8n-nodes-base.sort - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Summarize
n8n-nodes-base.summarize
From the author
Extract & Organize Academic Publications with GPT-4 Mini, Google Sheets & Gmail Author: CSChin Example Source: https://www.ncl.ac.uk/singapore/staff/profile/chengchin.htmlpublications Overview This automated workflow extracts, processes, and organizes…