Automated academic paper metadata & variable extraction with Gemini to 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 33 nodes and runs when a chat message arrives (plus 2 other triggers). Along the way it connects Google Sheets, Google Gemini Chat Model and Gmail.
How it runs
Trigger: When a chat message arrives (plus 2 other triggers).
- Create spreadsheet (Google Sheets): work with spreadsheet
- Get Sheet id (Edit Fields (Set)): sets 1 field: ID
- Read Checkpoint Data (Google Sheets): uses Google Sheets
- File Type Router (Switch): routes items into 4 branches
- WOS Field Mapper (Edit Fields (Set)): sets 5 fields: Authors, Title, Publication_date…
- CSV Data Extractor (Extract from File): extracts data from a file
- XLS Data Extractor (Extract from File): extracts data from a file (xls)
- XLSX Data Extractor (Extract from File): extracts data from a file (xlsx)
- Error Message Handler (Edit Fields (Set)): sets 1 field: output
- Batch Processor (Loop Over Items (Split in Batches)): loops over the items in batches
…plus 14 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.
Nodes used (16)
- Extract from File
n8n-nodes-base.extractFromFile - AI Agent
@n8n/n8n-nodes-langchain.agent - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Auto-fixing Output Parser
@n8n/n8n-nodes-langchain.outputParserAutofixing - Code
n8n-nodes-base.code - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Switch
n8n-nodes-base.switch - Edit Fields (Set)
n8n-nodes-base.set - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - Gmail
n8n-nodes-base.gmail - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
📚In the social and behavioral sciences (e.g., psychology, sociology, economics, management), researchers and students often need to normalize academic paper metadata and extract variables before any literature review or meta-analysis. 🧩This workflow…