Telegram-bot with daily unloading from Google Tables

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.

Hello! Task: Develop and place an agent on a WordPress page (the programmer will insert the code into WordPress). The user should be able to communicate with the AI agent in text or voice format (if possible) based on a specific uploaded topic (content: texts, photos). Functionality: The user visits the website page. Sees the AI agent interface: chat + voice communication button (if possible). Can request text. Can speak, and the agent should recognize the speech and respond. The agent responds only based on the uploaded materials on the specific topic. If the question goes beyond the topic, the agent should correctly inform that it can only respond based on materials related to Skovoroda. Responses should be lively, understandable, and educational. The administrator should be able to upload and update materials: texts, PDFs, images, audio, links. Interested in the cost and timeline for developing the agent.

A technical specialist is required to assemble the architecture and logic of an interactive bot. The project is a gamified product with a deep storyline (U.S. market). What needs to be done: Transfer the finished script (dialogue tree) into the working logic of the bot. Set up strict timings, delayed messages, and conditions (if/else) depending on user actions. Implement the ability to integrate audio files and call external APIs. Platform: to be discussed. Suggest the optimal builder (ManyChat, SendPulse, etc.) or a custom solution if it is more feasible. Important: Your task is specifically the engineering assembly of the script into a functioning, fail-proof mechanism. The complete script will be provided to the selected specialist. In your response, please include: 1. Describe your experience in assembling bots with complex branching (autoresponders, gamification). 2. Which platform would you recommend for the bot, where messages must arrive strictly on a timer the next day (considering time zones), and why? 3. Provide your cost for completing the project and estimated timelines.

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.

Need a DevOps / Linux administrator for deploying a Telegram bot on a VPS. Specifically, server setup and production deployment are required. Project stack: Node.js 20+, Telegraf, Express, Prisma, PostgreSQL, Redis, Docker, Docker Compose, Telegram Mini Apps, OCR. What needs to be done: 1. Prepare Ubuntu VPS. 2. Set up SSH access with keys. 3. Configure the firewall. 4. Install Docker and Docker Compose. 5. Set up PostgreSQL. 6. Set up Redis. 7. Configure Nginx. 8. Connect the domain and SSL Let’s Encrypt. 9. Configure production .env. 10. Run Prisma migrations. 11. Launch the Node.js application. 12. Set up Telegram webhook. 13. Check /health and /ready. 14. Set up PostgreSQL backup. 15. Leave instructions on how to update, restart, view logs, and restore backup. Important: - No need to rewrite the code. - The project needs to be deployed on a VPS. - A person with experience in Docker + Node.js + PostgreSQL + Redis + Nginx is required. - It is preferable to show 2–3 similar projects.