How to Copy a range of data from google sheets using an Applescript
Although possible with JavaScript interaction, AppleScript is not the best tool to use.

I would suggest using the Google Sheets API.  You can easily read data with their API.  Since the API supports Java, PHP, etc. and not AppleScript it is off-topic for this site. I would suggest asking on StackOverflow.