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:

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
Node
Python

API Client Libraries

Dart WIP
Go https://github.com/googleapis/google-api-go-client/tree/b3f5c35ca37cb88b5051dc3cedfcf012dd884f48/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
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