Est. Budget: $100.00
We have a Google spreadsheet that accepts input from an external source (Zapier).
This data must be reflected to a sheet in the spreadsheet according to a pre-defined algorithm (in the requirements document).
Additionally, every data change (row addition / cell value change) but NO STRUCTURAL CHANGES (i.e. sorting, filtering, row deletion) to that sheet must be reflected to a shadow sheet (which Zapier is using for triggering).
The entire algorithm is defined in the attached document in details.