Renata Chernyavska
Private message 
Odessa,
Ukraine
24 days 5 hours back
available for hire
on the service 4 months 24 days
Rating
Successful projects
Average rating
Skills and abilities
Writing
Portfolio
-
120 USD CRM bot for guide: automation of booking and client return system
Bot Development
I have developed a comprehensive solution for a private guide that transforms Telegram into a full-fledged order management system. The main goal of the project is to ensure that no client gets "lost" during the excursion selection or booking stage.
What I implemented (Technical part)
In this bot, I focused on tracking user actions and automatic data collection:
…
Interactive excursion showcase: Cards with photos and descriptions, where the selection of each item is recorded as a specific interest of the user.
Deep tracking: I set up a system of tags and variables that mark each step of the client. If a person clicks "Sign up" but does not select a time, the bot sees it.
Automation through Make: I configured complex logic for data transfer. All clicks, selected routes, and contacts are instantly sent to Google Sheets.
Smart "nudge" scenarios: I implemented reminder logic. The bot automatically messages those who showed interest but stopped halfway, helping to lead them to booking.
Analytics of frequently asked questions: The system records which questions are asked most often, helping the project owner optimize content and address objections in advance.
Review gallery with a trigger: A scrollable review section that at the right moment (at the peak of trust) offers a sign-up button.
Project architecture
The bot is built on the ManyChat platform using Make as the "brain" for connecting with external tables. I attached screenshots of the funnel to show how the transition conditions and data recording are set at each stage.
Result for the business
This solution addresses the main problem of private specialists — the loss of applications due to slow responses.
Value of the solution:
Transparent funnel: It is clear at which stage people "drop off," allowing for sales improvement.
Client retention: Thanks to tags, the bot reminds clients of itself, increasing the number of bookings without spending on advertising.
Time savings: The guide does not need to manually transfer data to the table — the system does it for them.
Database for mailings: All interests are segmented — promotions can be sent only to those who showed interest.
-
AI bot for expert: auto sales, recording, consultant
I developed a comprehensive automation system for a psychologist on the ManyChat platform. My goal was to create a full-fledged virtual office that takes care of all the routine tasks: from warming up the audience and answering questions to selling products and managing the schedule of consultations.
What I implemented (Technical part)
In this project, I built a complex architecture with the integration of external services so that the bot operates as a unified ecosystem:
…
ManyChat Flows: I created multi-level scenarios using conditions for user segmentation.
Integration with OpenAI (GPT):
AI Consultant: I set up an assistant that answers users' questions based on the expert's knowledge base.
AI Diagnosis: I implemented a questionnaire where AI analyzes the user's responses and provides personalized feedback in a supportive style.
Sales Automation:
I configured instant delivery of digital products (PDF) immediately after payment.
I implemented data collection for physical delivery with automatic courier notification in a Telegram channel.
CRM and Reporting: I set up automatic transfer of all data (orders, emails, surveys) to Google Sheets.
Appointment System: I developed the logic for booking consultations with checks for available slots and auto-reminders 24 hours in advance.
How I approach work
I design bots systematically, starting with logical diagrams. In the portfolio gallery, I attached screenshots of the "inner workings" from ManyChat. This demonstrates the cleanliness of my assembly, the reliability of connections, and that the bot is ready to operate without failures.
Result for your business
I created a universal architecture that I can adapt to your project.
You will receive:
Complete autonomy: The bot sells and books clients 24/7, even when you are offline.
Order in data: The client database and order history are always structured in Google Sheets.
Customer loyalty: Instant responses and automatic delivery of materials create a sense of high service and care.