Apps Script for Google tables

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.

I need a program or Telegram bot for bulk creation of shipping documents through the Nova Poshta API.Main Task I upload 50–100 orders at a time into an Excel/Google Sheets/CSV table or paste a list of orders into the program. Clients provide data in different formats, so the system must automatically recognize the data, sort it into the necessary fields, and create shipping documents through the Nova Poshta API.Input Requirements Possible options: Upload an Excel/CSV file. Copy a list of orders into the program. Paste client messages in free format.What the Program Must Recognize From each order, it is necessary to determine: Recipient's full name; Phone number; City; Nova Poshta branch; Product/comment; Cash on delivery amount; Weight/dimensions, if specified.Operational Logic I upload 50–100 orders. The program processes each order. Data is automatically distributed into columns. The program checks the city and branch through the Nova Poshta API. If there is an error or missing data for an order, it highlights that order and indicates what needs to be corrected. If everything is correct, it creates the shipping document. After creation, it shows a list of completed shipping documents. It allows exporting the result to Excel.Output After Processing For each order, it is necessary to obtain: Shipping document number; Client's full name; Phone; City; Branch; Cash on delivery amount; Delivery cost; Status: created / error / needs verification.Mandatory Functions Bulk creation of 50–100 shipping documents at once; Verification of city and Nova Poshta branch; Ability to edit an order before creating the shipping document; Saving sender data; Working with cash on delivery; Exporting created shipping documents to Excel; Log of created shipments.Desirable Telegram bot or simple program for Windows; Excel/CSV upload; Ability to paste a list of orders as text; Saving a database of regular clients; Reordering with one click; Product and weight templates; Printing/downloading labels for packages.Important I need not just a form for manual filling, but a tool for bulk processing of orders. Main scenario: I upload 50–100 data entries, the program sorts the information itself, checks for errors, and bulk generates shipping documents through the Nova Poshta API.

Good afternoon. I need a keyword parser that outputs results through a Telegram bot. How it should work: Automatic search on 4 websites for keywords that change from time to time. Search queries are sent every few minutes. The words are uploaded in the form of a .txt file. The Telegram bot should have buttons: start bot, stop bot, download file (downloads a file with active keywords), upload file (uploads an edited file with new words). The bot should ignore previously found results, i.e., it should not indicate the same ad twice. The result comes to the bot in the form of a link with a photo, but just a link is sufficient. P.S. searching websites without API, VPS with 6TB and 50 IPs are already available. For detailed information, please contact me via private message.

Good day, it is necessary to set up automation for reminders to people regarding the auto-webinar with automatic changes of dates and times of the auto-webinar. That is, there is a landing page with the date and time of the auto-webinar, the information should be sent to ManyChat, and ManyChat should send the corresponding reminders one day, 6 hours, 2 hours, 1 hour, and at the moment of the start of the auto-webinar.