Google Sheet Product Scraper

I have the address of a public website (there is only one) that maintains a matrix list of eight (8) fields on the screen. I need a small, delivered bot that scrolls through that list, and captures every single field that is publicly shown — such as names, company details, dates, times, really anything visible in the matrix list.

All collected details from the public website should be written in real time into two Google Sheets (Master GS and Working GS) that I will share with you. The solution has to be desktop-friendly as I want to run it from my own computer: (1) I want the scraper to be able to run automatically on an interval (in minutes) that I can manually set so that when I open up the "Master Google Sheet" or "Working Google Sheet" the fields will already be populated, and (2) as I am reviewing the Working Google Sheet there should be a “START” button that, once clicked, should populate/re-populate the fields in BOTH Google Sheets on-demand. Duplications in either Google Sheet should be deleted. I am happy to discuss more elegant solutions than what I described above.

A lightweight Python script (I’m comfortable with Python, Scrapy, BeautifulSoup, Selenium, or similar stacks) would be perfect, but I’m open to any approach that is easy for me to execute again later.

Deliverables:
• Scraper script or executable that logs in to the public website, extracts all visible data, and sends it to designated Google Sheets.
• De-duplication of all required fields.
• Clear setup instructions and any required dependencies.
• An initialization file that I can use to automate some of the variables that will display only relevant data (Date Range, Scraping Interval (mins), etc.
• Brief walkthrough or recorded demo confirming the scrape runs end-to-end on a desktop environment

Speed to delivery is less important than accuracy.