{"product_id":"n8n-scrape-nsr-specialist-data-to-google-sheets-pagination","title":"n8n Scrape NSR Specialist Data to Google Sheets (Pagination)","description":"\u003ch3\u003eScrape Malaysia NSR Specialist Data with Pagination—Auto-load into Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow manually scrapes Malaysia’s National Specialist Register (nsr.org.my) for a configured specialty (e.g., Cardiology), paginates through all results, enriches each doctor from their detail page, and appends or updates structured records in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e using the NSR License (NSR number) as the matching key.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts on manual run\u003c\/strong\u003e (you trigger it in n8n).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a session and performs the specialty search\u003c\/strong\u003e on nsr.org.my by requesting a session cookie and submitting the configured specialty search (configured for \u003cstrong\u003eCardiology\u003c\/strong\u003e via code 302).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePaginates through every results page\u003c\/strong\u003e: parses the HTML table and accumulates each doctor’s \u003cstrong\u003eNSR number\u003c\/strong\u003e, \u003cstrong\u003ename\u003c\/strong\u003e, \u003cstrong\u003egender\u003c\/strong\u003e, and \u003cstrong\u003eaccount ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches doctor records\u003c\/strong\u003e: after the last page, it loops through the full doctor list and opens each doctor’s detail page on nsr.org.my.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts graduation year and splits specialty\u003c\/strong\u003e: pulls the graduation year from the \u003cem\u003eBasic Degree\u003c\/em\u003e section and splits the listed specialty field into \u003cstrong\u003eSpecialty 1\u003c\/strong\u003e and \u003cstrong\u003eSpecialty 2\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRate-limits requests\u003c\/strong\u003e using a brief wait to reduce the chance of throttling.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites to Google Sheets\u003c\/strong\u003e: appends or updates rows in your sheet, matching by \u003cstrong\u003eLicense (NSR number)\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain an up-to-date directory of specialist doctors for a specific specialty (e.g., Cardiology) in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eSupport internal research or lead lists by automatically enriching doctor details from NSR detail pages.\u003c\/li\u003e\n  \u003cli\u003eContinuously refresh structured datasets in SaaS ops or analytics workflows using n8n + Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/logic:\u003c\/strong\u003e if, code, wait, sticky note, http request, google sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration:\u003c\/strong\u003e uses an \u003cstrong\u003eOAuth2\u003c\/strong\u003e connection, writes to a specified spreadsheet tab, and updates by \u003cstrong\u003eLicense (NSR number)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired sheet columns:\u003c\/strong\u003e Name, License, Specialty 1, Specialty 2, Gender, Grad Year.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eOptional customization:\u003c\/strong\u003e to scrape a different specialty, update \u003cem\u003eallSpecialty_ForSearch\u003c\/em\u003e in the NSR search request and adjust the specialty label used during parsing if you rely on it downstream.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824202801331,"sku":"N8N-18166","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/VgouFL5_DoF32ZWopb2o3_gSj2JWkl.png?v=1786612326","url":"https:\/\/buyflowscripts.com\/products\/n8n-scrape-nsr-specialist-data-to-google-sheets-pagination","provider":"N8N Commerce","version":"1.0","type":"link"}