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 .
