Using the Tables API

Yes! We have an externally available RESTful API where you can query for tables, and update/create/delete rows within tables programmatically. You can also access this API via Apps Script from within the Google Workspace ecosystem (formerly known as G Suite).

Enable API access

You can enable the Tables from the Google Cloud Console here: https://console.cloud.google.com/apis/library?q=tables (APIs > Library > search "Tables").

At a high level, you should be able to query:

/v1alpha1/tables                           // To get a list of tables.

/v1alpha1/tables/{table id}/rows           // To get a list of rows in a table.

/v1alpha1/tables/{table id}/rows/{row id}  // To get a particular row.

Client libraries

We have two categories of API client libraries:

• Google Cloud Client Libraries: see the Google APIs Github page (scroll down) to find our client libraries to call the Tables API in some common languages.
• Google API Client Libraries: open the Google Developers API Client Libraries page and select the language of your choice, then search for "area120tables".

For more information on the difference between these two categories of client libraries, please see: https://cloud.google.com/apis/docs/client-libraries-explained.

Direct links

Cloud Client Libraries
Java	Library: https://github.com/googleapis/java-area120-tables Documentation: https://googleapis.dev/java/google-area120-tables/latest/index.html
Node	Library: https://github.com/googleapis/nodejs-area120-tables Documentation: https://googleapis.dev/nodejs/area120tables/latest/index.html
Python	Library: https://github.com/googleapis/python-area120-tables Documentation: https://googleapis.dev/python/area120tables/latest/index.html
API Client Libraries
Dart	https://github.com/dart-lang/googleapis/tree/master/generated/googleapis_beta/lib/area120tables
Go	https://github.com/googleapis/google-api-go-client/tree/master/area120tables
Java	https://github.com/googleapis/google-api-java-client-services/tree/master/clients/google-api-services-area120tables
Objective-C	https://github.com/google/google-api-objectivec-client-for-rest/tree/master/Source/GeneratedServices/Area120Tables
.NET	https://developers.google.com/api-client-library/dotnet/apis/area120tables/v1alpha1
Node	https://github.com/googleapis/google-api-nodejs-client/tree/master/src/apis/area120tables
Python	https://github.com/googleapis/google-api-python-client/blob/master/googleapiclient/discovery_cache/documents/area120tables.v1alpha1.json
Ruby	https://github.com/googleapis/google-api-ruby-client/tree/master/generated/google/apis/area120tables_v1alpha1