This is a very simple guide that shows how to make a google sheets endpoint with JS. Once the endpoint is made, I show how to scrape the data from the endpoint and paste them into a html file.
I recommend using "App Script API (Still Supported | As of Aug 24, 2021)/Basic/"