Hi there. I have two tables in an auditing app. One a master checklist and a related audit checklist that is populated by dereferencing the master checklist conditions, with additional audit questions regarding each condition of the master checklist.
I have set up a series of actions that triggers a workflow rule to write the master checklist items (based on a subset as specified in an audit table).
The workflow then posts the master checklist item to zapier that then populates the audit checklist sheet… However, this burns through the free or even low tier price plan allowance for amount of actions per month very quickly.
I would rather like to go the route of cutting our zapier and post directly via webhook from appsheet to the audit checklist google sheet via json and a suitable google sheet script. Can anyone assist with setting up the json template and an appropriate script?