How can I easily insert data from the website into Google Sheets?

For automation, I’d recommend Google Apps Script. You can write a simple script to fetch data from a website and insert it into Google Sheets.

There’s a bit of a learning curve, but once you get the hang of it, you can set it to run on a schedule. I found some great tutorials on YouTube that walk you through it step by step.