{"product_id":"careclinics-scraper-n8n-workflow-google-sheets-locations-log","title":"CareClinics Scraper n8n Workflow: Google Sheets Locations Log","description":"\u003ch3\u003eScrape CareClinics locations into Google Sheets—automatically\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eCareClinics Scraper n8n Workflow: Google Sheets Locations Log\u003c\/strong\u003e manually scrapes CareClinics clinic listings page-by-page, extracts key details (clinic name, address, phone, email), infers the Malaysian state from the address, and \u003cstrong\u003eappends or updates\u003c\/strong\u003e the results in a \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e spreadsheet under the correct state tab.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual run:\u003c\/strong\u003e Start the workflow whenever you need the latest CareClinics location listings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP scraping with pagination:\u003c\/strong\u003e Sends a \u003cstrong\u003ePOST\u003c\/strong\u003e request to the CareClinics locations endpoint, parses the returned HTML, and repeats requests until all pages are processed (with a short delay between pages).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData extraction:\u003c\/strong\u003e Pulls clinic \u003cstrong\u003ename\u003c\/strong\u003e, \u003cstrong\u003eaddress\u003c\/strong\u003e, \u003cstrong\u003ephone\u003c\/strong\u003e, and \u003cstrong\u003eemail\u003c\/strong\u003e from the page content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eState inference:\u003c\/strong\u003e Infers each clinic’s Malaysian \u003cstrong\u003estate\u003c\/strong\u003e from the address.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets logging:\u003c\/strong\u003e After the last page, processes each clinic record one-by-one and writes it into the worksheet named for the detected state.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppend\/update logic:\u003c\/strong\u003e Uses \u003cstrong\u003e“HCO Name”\u003c\/strong\u003e as the unique match key so existing rows can be updated rather than duplicated.\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 \u003cstrong\u003eclinic directory\u003c\/strong\u003e for lead generation teams.\u003c\/li\u003e\n  \u003cli\u003eContinuously refresh location datasets for \u003cstrong\u003ehealthcare operations\u003c\/strong\u003e and reporting.\u003c\/li\u003e\n  \u003cli\u003eBuild an internal \u003cstrong\u003eMalaysia clinic contact log\u003c\/strong\u003e with state-based segregation in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/workflow blocks:\u003c\/strong\u003e if, code, wait, sticky note, HTTP Request, Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegration:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e credential for the target spreadsheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSpreadsheet requirements:\u003c\/strong\u003e Worksheets named for states (e.g., Selangor, Johor, Penang, Kuala Lumpur, Putrajaya, Negeri Sembilan) with columns: \u003cstrong\u003e“HCO Name”\u003c\/strong\u003e, \u003cstrong\u003e“Phone Number”\u003c\/strong\u003e, \u003cstrong\u003e“Email”\u003c\/strong\u003e, and \u003cstrong\u003e“Address”\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eBest for:\u003c\/strong\u003e n8n users, automation engineers, and SaaS operators who need a reliable \u003cstrong\u003eCareClinics scraper\u003c\/strong\u003e and a clean \u003cstrong\u003eGoogle Sheets locations log\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45962015080627,"sku":"N8N-19215","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/QMLfTOAyKw08mrzmnqq2P_JkU8s9wl.png?v=1788599405","url":"https:\/\/buyflowscripts.com\/products\/careclinics-scraper-n8n-workflow-google-sheets-locations-log","provider":"N8N Commerce","version":"1.0","type":"link"}