So, as deals are updated, removed or change deal stage. There should be a function to remove data from google sheets
Yes please this would be so useful!
I believe once the data is in the Google Sheet, you can write an Apps Script that would remove it based on a value in one of the cells. For example, in my use case, if a Deal is marked as Closed Won or Closed lost, I would want the deal to be removed from the sheet.