{"product_id":"n8n-workflow-google-scholar-scraper-with-groq-crossref-sheets","title":"n8n Workflow: Google Scholar Scraper with Groq, CrossRef \u0026 Sheets","description":"\u003ch3\u003eTurn an n8n chat message into a deduplicated research paper list in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow takes a research topic from your chat input, automatically generates optimized \u003cstrong\u003eGoogle Scholar\u003c\/strong\u003e queries with \u003cstrong\u003eGroq\u003c\/strong\u003e, fetches results via \u003cstrong\u003eSerpApi\u003c\/strong\u003e, enriches missing \u003cstrong\u003eDOIs\u003c\/strong\u003e using \u003cstrong\u003eCrossref\u003c\/strong\u003e, and appends the final papers to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a research title\/description\u003c\/strong\u003e as an n8n chat message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates multiple Scholar queries\u003c\/strong\u003e using \u003cstrong\u003eGroq (Llama 3.1)\u003c\/strong\u003e, returning structured JSON that can be executed reliably.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches Google Scholar through SerpApi\u003c\/strong\u003e for each query, applying a publication date filter \u003cstrong\u003e(2018–2025)\u003c\/strong\u003e, then flattens organic results into a single list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches metadata\u003c\/strong\u003e by extracting DOI and year when available; for items missing a DOI, it looks up the DOI in \u003cstrong\u003eCrossref by title\u003c\/strong\u003e (with a short wait between requests).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates results\u003c\/strong\u003e by removing duplicates based on the \u003cstrong\u003epaper link\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends final fields to Google Sheets\u003c\/strong\u003e: query, title, authors, year, link, abstract\/snippet, DOI, and DOI URL.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild a repeatable “literature scan” workflow for SaaS operators—start from a topic and produce a shareable sheet of relevant papers.\u003c\/li\u003e\n  \u003cli\u003eHelp automation engineers generate structured research datasets for downstream processing (tagging, reviewing, or analytics).\u003c\/li\u003e\n  \u003cli\u003eMaintain an up-to-date bibliography by running Scholar searches for specific projects and collecting enriched DOI information.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroq\u003c\/strong\u003e for query generation and parsing (Llama 3.1).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSerpApi\u003c\/strong\u003e to run Google Scholar searches (ensure your plan supports the Google Scholar engine).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCrossref API\u003c\/strong\u003e DOI enrichment, including a required \u003cstrong\u003eUser-Agent email\u003c\/strong\u003e via the \u003ccode\u003emailto:your@email.com\u003c\/code\u003e header.\u003c\/li\u003e\n  \u003cli\u003eWorkflow nodes include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e add Groq, SerpApi, Crossref header configuration, and Google Sheets OAuth2 credentials, then set the spreadsheet ID and target sheet.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45822091821235,"sku":"N8N-18079","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/chIS02PL7wy5B9d86IZDo_FZ3i4s53.png?v=1786525745","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-scholar-scraper-with-groq-crossref-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}