Comment by trollied

There's a help page that gives you all the code you need to do this. https://developers.google.com/sheets/api/quickstart/js