Projects
Python · Sql · Automated Workflow · Data Extraction
Full funnel automation: download, editing, and republishing
Python automation tool for marketing funnel management. The system extracts funnel data from the database via SQL queries, downloads funnels via links, applies modifications using POD/PDR and clustering logic, and republishes them automatically. Key Results: Reduced manual funnel editing time from hours to minutes Ensured precise, repeatable updates at required steps Minimized human errors and maintained consistency across multiple funnels
python · Automated Workflow · Data Analysis · SQL · Data Extraction
Data Automation & Reporting Tool
Developed a Python tool that extracts data from a database and processes three CSV files. The system cross-checks records against multiple controls and generates a comprehensive multi-sheet Excel report, including summaries, detailed records, and control-specific data. Key Results: Reduced manual processing time from hours to minutes Eliminated human errors and ensured data consistency Delivered structured, ready-to-use reports for business use.
Python · smtplib · Twilio · SQLite · cron
Invoice & Payment Reminder Automation
Python script that scans unpaid invoices, sends progressive reminders via email and WhatsApp at 7, 14 and 30 days, auto-escalates the tone of communication, and logs every received payment in a local database.
Python · Meta Graph API · LinkedIn API · OpenAI API · cron
Automated Social Media Scheduler
System that automatically generates captions with AI from a product sheet or text brief, schedules posts at optimal times for each platform, and publishes automatically on Instagram, Facebook and LinkedIn — without manually touching any app.
Python · Google Sheets API · pandas · smtplib · Twilio
Inventory & Stock Alert System
Automatically monitors stock levels from Google Sheets or ERP, sends email and WhatsApp alerts when a product falls below the minimum, and triggers an automatic order to the supplier when the critical level is reached.
Python · Twilio SMS · smtplib · Google Calendar API · SQLite
Automated Appointment Reminder System
Automatically sends SMS and email reminders 24 hours and 2 hours before each appointment, tracks client confirmations, handles cancellations and generates a daily no-show report — reducing them by an average of 80%.
Python · pandas · matplotlib · ReportLab · smtplib · REST API
Automated Daily Sales Report
Collects sales data from all active channels (POS, online shop, phone orders), processes it with pandas, generates a full PDF report with charts and KPIs, and automatically emails it to the owner every evening at 20:00.
Python · smtplib · Jinja2 · SQLite · cron
New Client Email Onboarding Sequence
When a new client signs up or signs a contract, a personalised email sequence starts automatically over the following days: welcome, getting-started guide, check-in, and feedback request — with no manual action required from the owner.
Python · Twilio SMS · smtplib · Google My Business API · SQLite
Post-Service Review Request Automation
Automatically sends an SMS or email to the client 2 hours after service completion asking for a Google or TripAdvisor review. Filters already-reviewed clients, manages direct platform links, and notifies the owner for every new star received.
Python · python-docx · ReportLab · Jinja2 · Google Forms · smtplib
Automatic Contract & Quote PDF Generator
Automatically fills contracts and quotes as PDFs from a Google Form or webhook, replaces all variables (client name, services, amounts, dates) in a Word or PDF template, and sends the signing-ready document via email within seconds.
Python · BeautifulSoup · requests · pandas · smtplib · SQLite
Real-Time Competitor Price Monitor
Automatically scrapes competitor product or service prices every day, compares with own prices, calculates percentage deviation and sends an email alert whenever a competitor changes a price by more than 5%.
Python · Google Drive API · Dropbox API · pathlib · cron · smtplib
Automatic Document Cloud Backup
Creates automatic nightly backups of all critical work folders to Google Drive or Dropbox, verifies file integrity, sends a confirmation report every morning and immediately alerts if files are corrupted or storage is insufficient.