Are there Spreadsheets (samples) with Google Apps script to work with CiviCRM?
Here's an example. We have a WP-hosted Civi install using the v3 API. This pulls contact records from some smart groups and dumps the entries as a table in a google sheet. Other pages on that sheet automatically parse/filter the data table. I'm a novice coder, so perhaps clunky, but it will give you the guts of the API calls and sheet filling.