I've been playing around with the Google Sheets API to automate some mundane pages. I can't really take credit for figuring out the connection in version 3 of the API. That credit goes to Karl Kranich. From what I can tell, this version was short lived and seems experimental. Just as I got this working Google releases the version 4 API and says we should all use that.... Oh well, I'll move on to that one on my next project, this is already done for now.