CareClinics Scraper n8n Workflow: Google Sheets Locations Log

Scrape CareClinics locations into Google Sheets—automatically

CareClinics Scraper n8n Workflow: Google Sheets Locations Log manually scrapes CareClinics clinic listings page-by-page, extracts key details (clinic name, address, phone, email), infers the Malaysian state from the address, and appends or updates the results in a Google Sheets spreadsheet under the correct state tab.

What this workflow does

• Manual run: Start the workflow whenever you need the latest CareClinics location listings.
• HTTP scraping with pagination: Sends a POST request to the CareClinics locations endpoint, parses the returned HTML, and repeats requests until all pages are processed (with a short delay between pages).
• Data extraction: Pulls clinic name, address, phone, and email from the page content.
• State inference: Infers each clinic’s Malaysian state from the address.
• Google Sheets logging: After the last page, processes each clinic record one-by-one and writes it into the worksheet named for the detected state.
• Append/update logic: Uses “HCO Name” as the unique match key so existing rows can be updated rather than duplicated.

Use cases

• Maintain an up-to-date clinic directory for lead generation teams.
• Continuously refresh location datasets for healthcare operations and reporting.
• Build an internal Malaysia clinic contact log with state-based segregation in Google Sheets.

Technical details

• n8n nodes/workflow blocks: if, code, wait, sticky note, HTTP Request, Google Sheets.
• Integration: Google Sheets OAuth2 credential for the target spreadsheet.
• Spreadsheet requirements: Worksheets named for states (e.g., Selangor, Johor, Penang, Kuala Lumpur, Putrajaya, Negeri Sembilan) with columns: “HCO Name”, “Phone Number”, “Email”, and “Address”.

Best for: n8n users, automation engineers, and SaaS operators who need a reliable CareClinics scraper and a clean Google Sheets locations log.