Parsing emails on a topic and filling Google tables on data from email

I need a script in Python (or a bot) that will monitor posts in a specified Telegram channel (source) in real time, process them, and publish them in a Telegram channel. Technical requirements: Monitoring: The script must instantly intercept new posts from the source channel (even if I do not have admin rights there — via UserBot/Telethon/Pyrogram). Filtering and cleaning: Automatic removal of all external links (http://, https://). Automatic removal of usernames. The ability to set a "blacklist" of words and phrases (for example, advertising, names of other brands), upon which the post is either cleaned or completely ignored. Integration with AI (Uniqueness): The cleaned text must be sent via API to a neural network (ChatGPT / Claude / or a free alternative) for deep rewriting. I must have the ability to easily change the prompt (instruction) for the AI in a separate file. Publication: The script must be able to transfer media files (images, videos) if they were in the original post and attach the already modified text from the neural network to them. Optional: The ability to send posts not immediately to the channel, but to a closed chat for pre-moderation or to scheduled messages, so I can check the quality before publication.

A project needs to be implemented for collecting and structuring a large array of images from open web sources (initially 2000 images). The task includes: - automated image collection; - uploading files in the highest available quality; - classifying images by categories. Expected results: - a structured image database; - a clear cataloging system; - delivery of the results via Google Drive or another agreed method;

Task type: video processing speed optimization Python - developer with experience in OpenCV, FFmpeg, MediaPipe

Development of a Telegram Mini App (Bot + WebApp) for selling digital goods and in-game currencies (Python / aiogram) Project description: A Telegram bot with a full WebApp interface is required for the automated sale of digital goods (Telegram Stars, Telegram Premium, in-game currencies/donations for PUBG Mobile, Steam, etc.). The project is called Aspect App. The main focus is on speed, smooth UI/UX in a Web3/minimalist style, and complete automation of product delivery after payment. Technology stack: Backend: Python 3.10+, aiogram 3.x (FastAPI for Webhook/API is welcome). Database: PostgreSQL / Redis (for sessions and caching). Frontend (WebApp): React.js / Vue.js / Next.js (at the developer's discretion, speed and smoothness of animations are important). Integrations: Telegram WebApp API. Main functionality (MVP): 1. Client side (Telegram Mini App): Main screen: Product categories (Telegram Assets, In-game Donations). Banner grid for promotions. Product catalog: Product cards with volume selection (e.g., 50, 100, 500 Telegram Stars or UC). Fields for entering player data (Player ID for PUBG). Cart and Checkout: Quick purchase in 2 clicks. Payment module: Integration of payment methods (CryptoBot API / TON Connect / other fiat gateways by agreement). Personal account: Order history, status tracking, referral system (balance within the app). 2. Admin panel (built into WebApp or separate bot): Catalog management (adding/removing products, changing prices). Order monitoring and sales statistics. User database mailing system. 3. Automation logic (A plus): Readiness of the architecture for integration with supplier APIs (API for auto-purchasing Stars/UC). At the MVP stage, some products may be issued with codes from the database. What is required from the contractor: 1. Development of the database and backend architecture in Python. 2. Layout and integration of WebApp (design mockup to be discussed, clean Web3 style, Glassmorphism is important). 3. Setting up secure transactions and payment webhooks. 4. Deployment on the server (Docker, Ubuntu, SSL setup). Candidate requirements: Experience in commercial development of Telegram WebApps for at least 1 year. Portfolio with launched and working Mini Apps (please provide links in your response). Clean, documented code. Working conditions: Work only through the Secure Deal (Safe / Escrow) of the platform. Payment is staged (the project is divided into Sprint 1: Backend + DB, Sprint 2: Frontend WebApp, Sprint 3: Payment integration and testing). Budget: To be discussed with the successful candidate (please indicate your price range and timelines in your response)

Technical task for a Telegram bot / mini-platform 1. Project goal Create a Telegram bot and mini-platform for finding specialists and posting requests from users. The user can leave a request, the specialist can respond, the administrator controls publications, moderation, payment, and security. 2. User roles User: can register; confirm phone number and email; create a request; view specialists; receive responses. Specialist: can register; fill out a questionnaire; specify services, prices, city, experience; add photos of completed work; respond to requests. Administrator: can moderate requests; verify specialists; review complaints; manage advertising; control payments; block users. 3. Registration Mandatory: confirmation of phone number via Telegram or code; confirmation of email via link or code; without confirmation of phone and email, the request is not published. 4. Requests The user fills out: service category; task description; city/region; deadline; budget; photo (if necessary); contact details. Limitations: no more than three requests per day from one user. 5. Moderation All requests initially go for moderation. Automatically block or send for manual review: photos of category 18+; spam; offensive statements; suspicious links; duplicate requests; mass requests from one account. 6. Specialists Specialist questionnaire: name; city; services; experience; prices; portfolio; photo; description; link; reviews; verification status. Important: the platform is not responsible for the quality of the specialist's services. This must be stated in the user agreement. 7. Payment Monetization options: paid placement of the specialist's profile; paid boosting of the profile; paid access to requests; advertising after approval by the administrator; subscription for specialists. Integrate payment: Stripe / Przelewy24 / PayU / Fondy — as per the developer's capabilities. 8. Administrative panel It is necessary to create a convenient admin panel: list of users; list of specialists; requests under moderation; complaints; payments; statistics; blocking users; editing categories; managing advertising; manual approval or rejection of publications. 9. Security Mandatory: protection against spam; request limit; message limit; protection against mass registrations; action logging; database backup; file and photo verification; CAPTCHA or other spam protection mechanism; blocking by phone number, IP address, or Telegram ID. 10. Responsibility The user agreement must specify: the platform is not an employer; the platform is not responsible for the actions of specialists; the user independently makes decisions about cooperation; the administration has the right to delete a request or profile without explanation; advertising is published only after approval by the administrator; spam, fraud, 18+ content, and any manifestations of aggression are prohibited.