Webscraping

Title: Playwright (or better alternative) automation — login to aviation parts portal, pull prices into Google Sheets The job: We have a business account on 1) https://ww2.txtav.com/Parts 2) my.businessaircraft.bombardier.com and 3) https://parts.mhirj.com/ We need a Python (or better alternative) script that logs in, looks up a list of ~XYZ part numbers every day, and writes price into a Google Sheet. These sites have log-ins and force 2FA via email or phone. Two things matter to us: It saves the login session so it isn't re-authenticating every run (there's MFA). It alerts us if a run comes back empty. Stale prices that look current are worse than no prices. We can't get flagged. Deliverables: production tool that works, code in our GitHub repo, a README, and a short Loom of it running. To apply, answer two questions: The saved session has expired when a scheduled run starts. What does your code do? The page loads fine but the results table is empty because a selector broke. How does my script catch that?