google sheets Notification to the nearest user

Hello, I’m learning, I want to make an order hosted on Google Sheet reach my app but for this order to reach the user closest to the point of the person who placed the order.
What could I review to soak up the topic? thank you