n8n Workflow: Scrape MMC Doctors by APC Year to Google Sheets

Scrape MMC MeRITS doctors by APC year and save the matches to Google Sheets—resume-safe

This n8n workflow manually scrapes the MMC MeRITS registeredDoctor directory, filters doctors by a target APC year, and writes matching results to Google Sheets. It’s built to be rate-limited and resume from where it last stopped, so you can run it repeatedly without losing progress.

What this workflow does

• Run manually and set a target APC year plus a maximum number of matches to collect per run.
• Resume from saved progress by loading the last processed page and row index from n8n workflow static data.
• Request and parse MMC search results (MMC MeRITS registeredDoctor search): extract doctor IDs, row data, and total page count.
• Fetch each doctor’s detail page and extract fields such as:
  • full name
  • qualification
  • provisional registration date
  • registration number
  • APC year
  • place of practice
• Filter by APC year: when the extracted APC year matches your configured year, the workflow appends or updates the doctor record in Google Sheets.
• Rate-limit and persist progress: after each doctor, it updates the saved page/row state, waits briefly, and stops once the per-run match target is reached (otherwise it continues through pages).

Use cases

• Maintain an up-to-date Google Sheets roster of MMC MeRITS registered doctors filtered to a specific APC year.
• Run scheduled “data refresh” jobs in n8n while limiting daily volume and avoiding repeat work via resume state.
• Support internal reporting for SaaS operators or automation engineers who need structured directory data in Google Sheets.

Technical details

• Google Sheets via OAuth2 (select target spreadsheet and sheet for append/update).
• Workflow nodes listed: if, set, code, no op, wait, sticky note.
• Uses n8n static data to store and reload the last processed page and row index for resume-safe scraping.