Report: Webhook: Action "Add a new row to another table"

I have 2 Tables.
The first table is read only, because it get’s filled with Google App Script.
When a new row is added to Table1, the values should be copied to Table2.
I can’t use Webhook, because Table1 is not edited by AppSheet.
So I thought I could use Report that runs once a day.

I would like to use an Action “Add a new row to another table” that is fired with webhook in that Report.
In the HTTP Body I would like to use <<Start>> and <<End>> to copy all the rows that are new.

I forgot to mention: For this copy I can’t use Google App Script, because I have calculations in AppSheet.

Does anyone has experience with that?

0 3 363
3 REPLIES 3
Top Labels in this Space