I would like to setup a zap that will take the Printavo Orders Data and export it to the same google sheet overwriting all previous data. 5 times a day every 4 hours would be perfect.
The intent is to capture all changes to the system. Often times an old order will get paid changing the Paid column data from FALSE to TRUE as one example. Or the sales rep on record could get changed. Order Status could get changed. Etc etc.
What i have been able to accomplish is creating a new record when a quote / invoice (their phrasing for order) is created to my spreadsheet but on changes to an order, its creating a duplicate record rather than editing the row in question.