I already keep a Google Sheet that lists roughly 150 German hospitals together with the URLs of their career pages. What I need now is an automated way to visit each of those sites every week, follow every paginated section, and pull out every open position—even when the page is rendered with JavaScript. The scraped information has to be written back into Google Sheets and also saved as a clean JSON feed (my preferred format). I’m flexible about whether you extend the current sheet or create a second one, as long as the data stays organised and deduplicated on each run. Key points you should be comfortable with: • Pagination handling so no vacancy is missed • JavaScript-rendered pages (Selenium, Puppeteer or similar) • Scheduled weekly execution—Apps Script, Cloud Functions, or any approach you recommend that keeps maintenance low • Direct interaction with Google Sheets API for seamless updates Deliverables • A working script or small service that crawls all 150 links, extracts every job, and outputs JSON plus the refreshed Google Sheet • Clear setup/usage instructions and minimal config so I can add more hospitals later • A quick hand-off call or document confirming everything runs on a weekly schedule without manual intervention Acceptance criteria The job runs end-to-end, populates the sheet with all current vacancies from every paginated section, and produces a matching JSON file on the first scheduled run.