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