Automated academic paper metadata & variable extraction with Gemini to Google Sheets

📚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 automates the busywork. Using an LLM, it processes CSV/XLSX/XLS files (exported from WoS, Scopus, EndNote, Zotero, or your own spreadsheets) into normalized metadata and extracted variables, and writes a neat table to Google Sheets. 🔗 Example Google Sheet: [click me](https://docs.google.com/spreadsheets/d/1WiFj0MwieQiSmFyMU2oyaCzbl273sTyknOa80dl8sUA/edit?usp=sharing)

---

👥 Who is this for?

- 🎓 Undergraduate and graduate students or researchers in soft-science fields (psychology, sociology, economics, business) - ⏱️ People who don’t have time to read full papers and need quick overviews - 📊 Anyone who wants to automate academic paper metadata normalization and variable extraction to speed up a literature review ---

⚙️ How it works 1. 📤 Upload an academic paper file (CSV/XLSX/XLS) in chat. 2. 📑 The workflow creates a Google Sheets spreadsheet with two tabs: Checkpoint and FinalResult. 3. 🔎 A structured-output LLM normalizes core metadata (title, abstract, authors, publication date, source) from the uploaded file and writes it to Checkpoint; 📧 a Gmail notification is sent when finished. 4. 🧪 A second structured-output LLM uses the metadata above to extract variables (Independent Variable, Dependent Variable) and writes them to FinalResult; 📧 you’ll get a second Gmail notification when done.

---

🛠️ How to set up 🔑 Credentials - Google Sheets OAuth2 (read/write) - Gmail OAuth2 (send notifications) - Google Gemini (or any LLM you prefer) 🚀 Quick start 1. Connect Google Sheets, Gmail, and Gemini (or your LLM) credentials. 2. Open File Upload Trigger → upload your CSV/XLSX/XLS file and type a name in chat (used as the Google Sheets spreadsheet title). 3. Watch your inbox for status emails and open the Google Sheets spreadsheet to review Checkpoint and FinalResult. ---