Google API

Sheets

  • Register project
    • Google Developers Console 1 & mine 2
    • APIs & Services Credentials 3
    • Authorization OAuth 2.0: legacy v3 4
    • migration 5
    • ASP MVC OAuth 2.0 guide 6 This document describes OAuth 2.0, when to use it, how to acquire client IDs, and how to use it with the Google API Client Library for .NET.
  • Sheets API v4
    • home 7 & intro 8
    • .Net quickstart 9
    • Google API Client Libraries > .NET 10 Get Started
    • Google.Apis.Sheets.v4 11 Client Library
    • C# DOCS 12 Google Sheets API v4
    • sheets-api-explorer 13, sample rest call batchclear 14
    • source code 15 for all generated c# strong types
    • basic writing 16
  • Sheets backend
    • josdeweger/SheetToObjects 17 A simple fluent library which aims to provide developers with an easy solution to map sheets (Google Sheets, Microsoft Excel, csv) to a model/POCO. Install-Package SheetToObjects.Adapters.GoogleSheets.
    • KozTv/GoogleSheetsDatabase 18 Use your Google Sheet as a key-value storage DB. Install-Package GoogleSheetsDatabase. Values are serialized to JSON to be human-readable and easily editable using standard Google Sheets web interface.
    • commercial CData.GoogleSheets. Read, Write, and Update Google Sheets through easy-to-use bi-directional drivers.
  • Apps Script
    • Advanced Sheets Service 19 lets you access the Sheets API using Apps Script.
    • apps-script guides rest quickstart dotnet 20
  • Get file contents as JSON
    • docs.google.com: <Spreadsheet Key [21]>/edit#gid=0
    • spreadsheets.google.com: [List|Cells [22]]/<SPREADSHEET_KEY>/public/values?alt=json gets first sheet only
    • sheet fitness 23 sample
    • atom feed fitness 24
    • Simple example of retrieving JSON feeds from Spreadsheets Data API 25.
    • sample feeds cells 26

Sheetsu

  • Sheetsu test sheet 27
  • Sheetsu api sample 28
  • Sheetsu docs 29

Google Cloud

  • API rate limits 30
  • Cloud Memorystore 31 Fully-managed in-memory data store service for Redis.
  • dbs 32
  • Managing Notifications 33
  • JSON API authorize requests 34

Drive

  • Drive.v3 home 35
  • Install-Package Google.Apis.Drive.v3
  • googleapis/google-api-dotnet-client 36
< «