A database-like interface to Google Spreadsheets for .Net
C# Batchfile
Latest commit 9cf64d4 Aug 15, 2015 @mausch Bump version to 0.6.1

README.md

GDataDB

GDataDB is a database-like interface to Google Spreadsheets for .Net.
It models spreadsheets as databases, worksheets as database tables, and rows as records.

NuGet package here.

A few articles documenting it:

Google has changed the authentication scheme since those articles were written. Now it requires OAuth2.
To set this up visit http://console.developers.google.com , create a new project, enable the Drive API, create a new client ID of type "service account" and download the P12 key. Use the service account email address and the P12 key as shown in this example .
If you want to access any documents from your personal gmail account, share them (edit permissions) with the service account email address (the one that looks like "987191231-asdfkasjdjfk@developer.gserviceaccount.com") and make sure that they're in the root folder of Drive.

Original idea for GDataDB borrowed from https://github.com/google/gdata-python-client/blob/master/src/gdata/spreadsheet/text_db.py

Please donate