When using connections, there is currently no way to remove items from the map when they are removed from the parent source (Google Sheet or Airtable).
The new solution will create a relationship between map elements and their originating connection. On sync, any map element that is not found in the original data source will be deleted (unless locked).
This will ensure that data connections serve as the single point of data entry into a map.