Extracts and organizes academic publications using GPT-4 Mini, Google Sheets, Gmail

Go to Workflow
0 views
Built by Cheng Siong Chin Cheng Siong Chin
Created on June 05, 2026

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 (6)

Gmail
n8n-nodes-base.gmail
Google Sheets
n8n-nodes-base.googleSheets
HTML
n8n-nodes-base.html
HTTP Request
n8n-nodes-base.httpRequest
Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor
OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi