Quick overview
Quick overview This workflow takes a research topic from an n8n chat message, uses Groq to generate optimized Google Scholar queries, fetches paper results via SerpApi, enriches missing DOIs using the Crossref API, deduplicates the results, and appends the final paper list to Google Sheets. How it works Receives a research title/description as an n8n chat message. Uses Groq (Llama 3.1) to generate multiple optimized Google Scholar search queries and parses them into structured JSON. Runs each query against Google Scholar via SerpApi with a publication date filter (2018–2025) and flattens the returned organic results into one list. Extracts DOI and year from the Scholar result when possible, and for items without a DOI it looks up the DOI in Crossref by title (with a short wait between requests). Merges the enriched items back into a single dataset and removes duplicate entries based on the paper link. Appends the final fields (query, title, authors, year, link, abstract/snippet, DOI, and DOI URL) to a target Google Sheets worksheet. Setup Add Groq API credentials for the Groq Chat Model used to generate and parse Google Scholar queries. Add SerpApi credentials and ensure your SerpApi plan supports the Google Scholar engine. Ensure Crossref requests use a valid User-Agent email by updating the mailto:your@email.com value in the Crossref HTTP request headers. Add Google Sheets OAuth2 credentials and update the spreadsheet ID and sheet/tab in the Google Sheets append step. Create the target Google Sheet with matching columns (Query, Title, Link, Abstract, Authors, DOI-URL, DOI, Year) or adjust the column mapping to your schema. An n8n automation workflow template by Muhammad Salman Anwar.
Muhammad Salman Anwar
web
free
Others in the same category, ranked by how often they are opened.
