I’ve been using Sheetgo for this exact thing! It’s a tool that connects websites and Google Sheets to insert data from the website into Google Sheets.
You can set it up to auto-update, and it’s pretty user-friendly. They have a free tier, so you can test it out before committing.
You can set it up to auto-update, and it’s pretty user-friendly. They have a free tier, so you can test it out before committing.