🔬 Extracts and organizes academic publications using GPT-4 Mini, Google Sheets, Gmail
⚡ 204 views · 🔬 Document Extraction & Analysis
Description
Extract & Organize Academic Publications with GPT-4 Mini, Google Sheets & Gmail
Author: CSChin
Example Source: https://www.ncl.ac.uk/singapore/staff/profile/chengchin.html#publications
Overview
This automated workflow extracts, processes, and organizes academic publications from university staff profile pages using AI-powered extraction. Publications are automatically categorized by type and stored in organized Google Sheets while sending email notifications.
Key Features: AI extraction • Auto-categorization • Dual output (Sheets + Email) • Year-based sorting
Target Audience
- Academic Researchers - Track publications across teams
- University Administrators - Manage faculty publication records
- Research Librarians - Maintain institutional repositories
- Department Heads - Monitor research output
- PhD Students - Organize literature reviews
Use Cases
- Automated Publication Tracking - Monitor faculty research output
- Research Portfolio Management - Maintain publication databases
- Citation Database Building - Populate citation systems
- Department Reporting - Generate organized reports by category/year
- Research Impact Analysis - Track publication trends
🔗 Nodes Used
Google Sheets, HTTP Request, Gmail, OpenAI Chat Model, n8n Form Trigger, Convert to File
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File