Look up Area from entity_id and vice versa

hi, im looking for some suggestions on how to achieve the following:

  1. receive an MQTT message or event when a sensor is triggered. This will contain entity_id
  2. lookup the area that the entity belongs to
  3. look up entity_id for cameras that exist in that area
  4. record snapshots from those cameras

Im looking for help on how to achieve 2) and 3)

Many thanks in advance

That’s not possible currently.