Google API如何连接以从电子表格接收值

I embarked on this project thinking it would be simple. Many hours later I'm realizing the Google API is a bit of a labyrinth with multiple APIs and libraries. I really need please clear directions on how to go about doing this.I embarked on this project thinking it would be