As I get a lot of requests for this code, I'm making it public for the first time!
A release with original code I made for a client to get and set cels in a google sheet. This is built for that purpose, so some code will be redundant/not of use for you. But hopefully this will help those trying to get google sheet intergration working, set on the right track.