My company is looking for a way to export a project's data (including attachments) when it is checkmarked as complete in our projects list sheet. We would like to append this information to an excel spreadsheet or a google sheet.
The workflow that I had in mind is that when an order is checked as complete, it triggers an event which then notifies my node application. The application knows what order has been marked and fetches further data on that project. Take that data, reformat it, and append it in another file (i.e. Excel or Google sheet).
Webhooks seem like a possible solution to this problem. I have already gone through the node-webhook-sample, but I am stuck on how to create and trigger specific events rather than all events (["."]). Help?