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:
- 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:
- Open the Advanced Services menu in the Apps Script editor.
- 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.