I'm currently in the brainstorming phase for approaching the development of a new application. The application would involve managing a user database consisting of approximately 3,000 users, each with their name and phone number. The primary goal is to establish a means of sending SMS messages to all users, while also enabling targeted messaging based on user groups (utilizing tags within the database). Additionally, the most challenging aspect is the ability to occasionally target users based on their geographical location through a geofencing feature.
I'm aware that a combination of Retool and Twilio can handle the SMS messaging aspect, but I'm grappling with the integration of the geofencing feature. One potential solution I'm exploring is the incorporation of services like Radar or PlotProject to achieve this.
It's important to note that all users in the database have opted in for this communication, so it's not a random targeting process. Nevertheless, I'm currently uncertain about how to seamlessly bring together all these functionalities and whether it's technically feasible