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.
To enable the Tables service in Apps Script, click on the "+" next to the Services section of the left sidebar, find the Area120 Tables API service, and click "Add".
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.