I need to be able to do what is explained here and enter the scraped html into a google sheet cell.
[login to view URL]
should be quick and easy for a google apps script guru.
I can provide you a Google App script code that will login to your website and parse information you need in less than a day. All I need to start is a website URL and test login credentials.