Apps Script

Integrating with Apps Script

You can directly access and call the Tables API from Apps Script, the Tables service allows scripts to read and edit rows within Google Tables programmatically.

You can also execute Apps Script functions to run custom logic with our Apps Script bot action, which can trigger on events and interactions within the table.

Tables API service & documentation

This is an advanced service that must be enabled before use.

Apps Script developer documentation and sample code: 
https://developers.google.com/apps-script/advanced/tables.

Enabling the Tables service in Apps Script

You will need to add the Area120 Tables API service to enable the Area120Tables.Tables javascript bean to be able to call the Tables API and create/update/delete rows.

In the new Apps Script editor:

  1. Click on the "+" next to the Services section of the left sidebar, find the Area120 Tables API service, and click "Add".

In the old Apps Script editor:

  1. Open the Advanced Services menu in the Apps Script editor.


     
  2. Find and toggle on the Area120 Table API service.


     

Calling the Tables API in Apps Script

 

Now you can call the API to create/update/delete rows within a table (need to use the table ID). See the Apps Script reference for the Tables service for more details: https://developers.google.com/apps-script/advanced/tables.

 

 

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false