{"product_id":"enrich-dois-in-google-sheets-with-crossref-api-n8n-workflow","title":"Enrich DOIs in Google Sheets with Crossref API (n8n Workflow)","description":"\u003ch3\u003eEnrich your pending DOIs in Google Sheets using the Crossref API—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e reads \u003cstrong\u003eDOIs\u003c\/strong\u003e marked as \u003cstrong\u003e“Pending”\u003c\/strong\u003e in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, fetches publication metadata from the \u003cstrong\u003eCrossref REST API\u003c\/strong\u003e, and appends a clean \u003cstrong\u003esuccess or failure\u003c\/strong\u003e record (including title, authors, journal, abstract, and status) back to an output tab—batch by batch.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts manually\u003c\/strong\u003e when you click \u003cem\u003eExecute\u003c\/em\u003e in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads DOI rows\u003c\/strong\u003e from your input Google Sheets tab and \u003cstrong\u003efilters\u003c\/strong\u003e to only rows where \u003cstrong\u003eStatus = “Pending”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses DOIs in batches\u003c\/strong\u003e and calls the \u003cstrong\u003eCrossref REST API\u003c\/strong\u003e for each DOI.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates lookup success\u003c\/strong\u003e by checking whether the Crossref response indicates a successful match.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats a normalized output record\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eOn success: includes \u003cstrong\u003epublication metadata\u003c\/strong\u003e (title, authors, journal, abstract) and a processing status.\u003c\/li\u003e\n      \u003cli\u003eOn failure: writes a standardized failure record when the DOI is missing or the API call fails.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends results\u003c\/strong\u003e to an output Google Sheets tab and \u003cstrong\u003ewaits 2 seconds\u003c\/strong\u003e between items to help reduce API rate-limit risk.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomatically enrich DOI lists for \u003cstrong\u003ecitation management\u003c\/strong\u003e or \u003cstrong\u003eresearch databases\u003c\/strong\u003e stored in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eMaintain an \u003cstrong\u003eaudit trail\u003c\/strong\u003e of successful vs. failed DOI lookups for ongoing dataset cleanup.\u003c\/li\u003e\n  \u003cli\u003eReduce manual metadata entry by enriching DOIs as soon as they’re added and marked “Pending.”\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/nodes:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003efilter\u003c\/code\u003e, \u003ccode\u003ehttp request\u003c\/code\u003e, and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCrossref API:\u003c\/strong\u003e uses the Crossref REST API and recommends setting your own \u003cstrong\u003eUser-Agent email\u003c\/strong\u003e (replace \u003ccode\u003emailto:research@example.com\u003c\/code\u003e with your contact email).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets setup:\u003c\/strong\u003e create an \u003cstrong\u003en8n service account credential\u003c\/strong\u003e and share the spreadsheet with the service account email; update the spreadsheet ID and input\/output tab names.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45748948664499,"sku":"N8N-17666","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xCvMpsE9JYdaaszxKx74Z_p7bg5kXV.png?v=1785575965","url":"https:\/\/buyflowscripts.com\/products\/enrich-dois-in-google-sheets-with-crossref-api-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}