Question about automating data collection and messaging with Make.com

What are you trying to achieve?

Hello Make.com Community,

I’m working on automating a process for two types of users through messaging services like WhatsApp, Telegram, and SMS. I would like to know if Make.com can help me accomplish the following.

For the first user type – the seller:

Sellers should be able to add information to a shared database in the form of text with at least five key points, for example:

Company Name: Company 1
Service Name
Service Description
Address: Example Address 1
Day and Time: Day of the week, start and end times
Service: Example service
This information should automatically be saved somewhere for easy retrieval. It should be possible to filter and sort this data based on the day of the week and time to send it out as messages when queried by customers.

For the second user type – the customer:

Customers will interact via WhatsApp, Telegram, or SMS, and receive automated responses based on their preferences.

Here is an example interaction flow:

Customer: “Hello”
Automation: “Hi, how can I assist you today? Please choose from the list: Service 1, Service 2, Service 3.”
Customer: “Service 1”
Automation: “Great! Please select your city from the list: City 1, City 2, City 3.”
Customer: “City 1”
Automation: "Here are the available services in City 1 for today (services should be filtered based on the current date, time, and day of the week from the database):
Company 1 Service Name Service Description Address Available today at (specific time)

Company 2 Service Name Service Description Address Available today at (specific time)

Company 3 Service Name Service Description Address Available today at (specific time)"

I would like to know if Make.com can handle this type of automation, particularly for:

Collecting and storing seller data.
Filtering and displaying services based on time, day, and city.
Sending responses via WhatsApp, Telegram, and SMS.
Any guidance on how to approach this or examples of similar workflows would be greatly appreciated!

Thank you in advance!

Steps taken so far

Exploring options