Yehor Medunytsia
Offer Yehor work on your next project.
Private message
Offer work
Kyiv,
Ukraine
6 months 22 days back
available for hire
on the service 6 months 22 days
Rating
Successful projects
Average rating
Skills and abilities
Portfolio
-
800 USD Automation of daily reporting and sales analytics for inter
Bot DevelopmentIndustry: IT and Software
Industry: E-commerce / Retail
… Problem
Before automation, the project manager of the company manually generated daily sales reports by logging into the CRM system, filtering orders, and exporting data for analysis. This process was:
Time-consuming - required manual report creation every evening;
Prone to errors, as data had to be filtered manually;
Delayed, as reports were often reviewed hours or even days after the actual shipment;
Opaque, making it difficult for the manager to track employee performance or overall daily revenue.
Solution
We created an automated daily reporting and analytics system, integrated with the CRM and the client's Telegram.
How it works:
Triggered via webhook:
Every time an order was shipped, a webhook from the CRM sent shipping data to the reporting system.
Data aggregation:
All order data for the day was automatically aggregated - number of orders, responsible managers, and total revenue.
Report creation:
Data was processed and formatted into a clear, easy-to-read report with:
Date
Total number of shipments
Total daily turnover
Manager performance breakdown (orders and revenue)
Telegram delivery:
The report was automatically sent via Telegram to the project manager's chat every evening after shipments were completed.
STACK:
Technology stack
Telegram bot API (for report delivery)
Google Sheets (for data storage and aggregation)
Google Apps Script (for automation and formatting)
CRM API / Webhooks (for real-time data transfer)
-
600 USD Automation of Gmail order processing in real time
Client Management & CRMIndustry: E-commerce / Retail / Customer Service Automation
Problem
The client's online store received orders from customers via Gmail every day. Each new order required manual processing:
…
The manager had to open the "Inbox" folder,
Manually copy all order details into the CRM system,
Assign a responsible manager,
Confirm the order for shipment.
This manual processing caused several problems:
Delay in order processing if the email was not received on time,
Missed or late shipments,
Human error during data transfer,
Unclear responsibility, as any manager could open the "Inbox" folder and process the order.
Stack:
Google Mail API (real-time email monitoring)
Trigger Nodes / Watch Nodes (N8N / Make)
Data Parsing & Merge Code Node
HTTP Requests / REST API (CRM integration)
Conditional Logic for order routing
Data Enrichment (discounts, client info, shipment details)
Solution
We created an automation system that connects Gmail with CRM to ensure instant order creation and error-free assignment of responsible managers.
How it works:
Gmail Trigger:
The automation continuously monitors incoming emails in real-time.
When a message arrives from a recognized customer or order source, it triggers the process.
Data Extraction:
The system analyzes the body of the email and attachments, extracting all relevant details:
Product name and quantity
Customer data
Shipping address
Discount information (if any)
Creating an order in CRM:
Automatically creates a new order record in the CRM system.
Assigns the appropriate manager based on predefined business logic (e.g., region, client, or category).
Notifications and Verification:
The assigned manager receives a notification to confirm readiness for shipment.
The system checks key data (address, contact information, payment) to ensure no information is missing.
-
1600 USD Automated SEO audit and lead generation system
Website SEO AuditIndustry: Marketing
Problem:
SEO companies needed a scalable and automated way to conduct quick SEO audits for potential clients. Manual audits required significant time and human resources, limiting lead generation capabilities. Additionally, uncontrolled access to artificial intelligence models led to excessive token usage, increasing operational costs.
…
Stack:
n8n, HTTP Requests, OpenAI API, Claude API, Gemini API, Google Drive API, Google Mail API
Solution Steps:
Creating a form:
A custom form was created (via n8n Forms or an external landing page) to collect client data — website URL and specific SEO questions.
Website scanning:
The system automatically collects website content for analysis.
AI analysis:
Technical audits were conducted using OpenAI, Claude, or Gemini agents.
Content audits were conducted separately for semantic and quality assessment.
Data aggregation:
The results of both audits were enriched, combined into one structured report, and formatted in Markdown.
Automatic delivery:
The final SEO report was automatically sent to the client via Google Mail, and a copy was saved on Google Drive.
CRM integration:
The workflow created a new lead in the CRM and assigned it the appropriate status for further action.
Access control and token management:
Access to the audit tool was restricted to prevent excessive usage and control API token consumption.
Sales funnel integration:
Clients used the audit as a free entry point into their sales funnel, subsequently converting free users into paying customers through automated email campaigns.
-
1200 USD Automated client booking system for the hair salon
Bot DevelopmentIndustry: Retail (Beauty and Care)
Problem:
The client - a recently opened hair salon - managed bookings manually through Google Calendar. This led to delays in response time, double booking errors, and a significant administrative burden. Clients often waited up to 15 minutes for booking confirmation, and as the team expanded, managing multiple hairdressers and services became increasingly complex.
… Stack:
Google Calendar API, NoCodeDB, Gemini, OpenAI, Claude, SimpleMemory, PostgreSQL (Memory), MCP Server, Webhooks, Calendly (optional)
Solution Steps:
Data Structuring: A centralized NoCodeDB database was created containing information about hairdressers, their availability, offered services, prices, and service durations.
Calendar Integration: Each hairdresser's Google Calendar was connected via API for real-time access to availability information.
AI Agent Development: An intelligent chatbot agent was created using Gemini/OpenAI, capable of analyzing user requests and matching them with available slots and corresponding hairdressers.
Slot Calculation: Automated identification and segmentation of available time slots based on service duration and hairdresser availability.
Smart Booking Logic: Compatibility was ensured between the requested service, hairdresser skills, and available time. Conflicts of double booking were prevented.
Client Interaction: A conversational chatbot interface was implemented where clients can instantly check availability, book, or reschedule appointments.
Scaling Automation: Easy scalability was ensured as more hairdressers join - there is no need to increase administrative staff.
-
2500 USD Automated processing of bank statements and reconciliation of payments.
Bot DevelopmentIndustry: Fintech (accounting and bookkeeping)
Problem: The accounting company manually processed bank statements for each client, checking transactions against defined criteria and manually recording incoming payments by date on separate client cards. This was a slow process — it took 3–10 minutes for each client for each bank statement and often delayed financial analysis and reporting.
… Stack:
Google Forms, Google Sheets, Google Apps Script, Python, PrivatBank API, Monobank API, OCR/Parsing Logic, Google Drive API
Solution Steps:
Data Entry Automation: A Google Form was created for accountants to upload bank statements directly.
Data Extraction: Parsing and scraping logic was implemented to extract transaction data from PrivatBank and Monobank statements.
Client Identification: Extracted data was matched with the existing client database in Google Sheets to determine which client each transaction belonged to.
Automated Data Entry: Automatic filling of client-specific records with transaction details (date, amount, and payer) in the respective client cards.
Quality Control: Error detection and compliance checking rules were added to flag discrepancies and identify potential data inconsistencies.
Performance Optimization: Automated data processing now takes 30–60 seconds per client, even for annual statements.
Reporting and Daily Monitoring: Daily updates were enabled instead of bi-monthly reconciliations, providing real-time analytics and improved oversight.
Activity
| Latest proposals 1 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Project
226 USD
|
