{"product_id":"n8n-google-sheets-auto-cite-papers-pdf-vector-apa","title":"n8n Google Sheets Auto-Cite Papers (PDF Vector + APA)","description":"\u003ch3\u003eInstantly generate APA \u0026amp; BibTeX citations from your Google Sheets “Pending” queries\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically scans your Google Sheets every minute for research queries marked as \u003cstrong\u003ePending\u003c\/strong\u003e, searches Semantic Scholar, PubMed, and arXiv using \u003cstrong\u003ePDF Vector\u003c\/strong\u003e, then writes back ranked results with \u003cstrong\u003eAPA\u003c\/strong\u003e and \u003cstrong\u003eBibTeX\u003c\/strong\u003e citations—switching each row to \u003cstrong\u003eCompleted\u003c\/strong\u003e when done.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e: executes every minute via a Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads search queries from Google Sheets\u003c\/strong\u003e: pulls rows containing a Search Query and checks their Status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters only “Pending”\u003c\/strong\u003e: continues only for rows where \u003cem\u003eStatus = “Pending”\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches with PDF Vector\u003c\/strong\u003e: queries Semantic Scholar, PubMed, and arXiv for up to \u003cstrong\u003e20\u003c\/strong\u003e matching papers.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRanks and selects top results\u003c\/strong\u003e: sorts by \u003cstrong\u003ecitation count\u003c\/strong\u003e, selects the \u003cstrong\u003etop 10\u003c\/strong\u003e, and prepares summary stats.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates citations\u003c\/strong\u003e: creates a formatted list plus \u003cstrong\u003eAPA Citations\u003c\/strong\u003e and \u003cstrong\u003eBibTeX Citations\u003c\/strong\u003e for the selected papers.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the same Google Sheets row\u003c\/strong\u003e: writes back top papers, total citations, most cited, citations, and the search date, then sets \u003cstrong\u003eStatus to “Completed”\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResearch operations\u003c\/strong\u003e: keep a backlog of literature searches in Google Sheets and auto-fill citation-ready references.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eContent \u0026amp; SaaS teams\u003c\/strong\u003e: rapidly build citation lists for reports or knowledge base articles.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e: demonstrate a practical n8n workflow that combines scheduling, data filtering, and literature search.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e: runs every minute.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e: OAuth credential for both reading and updating results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePDF Vector node\u003c\/strong\u003e (\u003ccode\u003en8n-nodes-pdfvectorpdf vector\u003c\/code\u003e): Semantic Scholar, PubMed, and arXiv search capability.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic\u003c\/strong\u003e: Code + Filter steps to process only “Pending” rows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRow matching\u003c\/strong\u003e: updates by \u003cstrong\u003eSearch Query\u003c\/strong\u003e; ensure Search Query values are unique (or adjust matching columns).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45862243860659,"sku":"N8N-18331","price":58.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/69u2ScIhbv3QaGflQ_TD-_ScbaXnE2.png?v=1786957452","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-sheets-auto-cite-papers-pdf-vector-apa","provider":"N8N Commerce","version":"1.0","type":"link"}