Improvement of the system on Google Apps Script (adaptive interface, Telegram, dashboards)
📄 Project Description:
There is a ready-made system based on Google Sheets + Google Apps Script, which is used for accounting production (cooking) and shipments (logistics).
Forms are working — data is correctly recorded, there are reference books and logic.
It is necessary to improve the appearance, make it responsive, integrate with Telegram, and add dashboards for analytics.
🔧 What has already been implemented:
Working web forms (cooking and shipments) via
doGet;Connection with Google Sheets;
Reference books (products, clients, etc.);
Automatic recording of date and time.
💡 Required improvements:
1️⃣ Responsive Interface
Bring all forms to a unified modern design (UI/UX, corporate colors);
Optimize for mobile devices (no horizontal scrolling, neat display on smartphones);
Add a visual notification of saving (success/error).
2️⃣ Main Menu
When opening via the link — start page with section selection:
→ Cooking
→ Shipment
(future expansion possible — Receiving, Inventory).
3️⃣ Integration with Telegram
When saving the form, send a message to the Telegram bot, for example:
✅ New shipment
Client: Store 1
Quantity: 120 pcs
Date: 12.11.2025 09:30
Ability to send notifications to a Telegram group (via ID).
Work through
UrlFetchAppor Telegram Bot API.
4️⃣ HTML Dashboards
Create a page with analytics (Chart.js / Google Charts):
volumes by days and weeks,
top clients,
production dynamics.
Separate link
/dashboardfor viewing reports.
5️⃣ (Optional) Authorization
Simple login form (username/password or via Google OAuth).
Client's review of cooperation with Symon Baikov
Improvement of the system on Google Apps Script (adaptive interface, Telegram, dashboards)Semen is a great guy! He did everything even better than it was needed. Thank you!
Freelancer's review of cooperation with Narek Marti
Improvement of the system on Google Apps Script (adaptive interface, Telegram, dashboards)Very satisfied with the collaboration! The client was always in touch and had clear requirements. Thanks to cohesive communication, the order was completed in a timely manner! Highly recommend!
-
7 days295 USD
1786 19 0 1 7 days295 USDHello!
We are working on the development of software, websites, automation systems, and more.
We accept projects for development "from scratch" as well as for technical refinement.
We work with a wide stack: WordPress, Opencart, Shopify, WIX, Python, JavaScript, C++, C#, Unity 3D, SQL, MSSQL, WPF, WinForms.
We have practical experience in:
– system and application programming
– business process automation
… – information security
– technical project management
After project delivery, we provide free technical support for 14 days.
We work quickly, clearly, and results-oriented.
We look forward to collaborating!
-
14 days750 USD
421 14 days750 USDHello Narek,
I have reviewed the requirements for your production and logistics system and I am confident enough in my ability to make the requirements aforementioned, into reality.
Kindly inbox me, so that I give you my implementation plan.
-
1 day35 USD
1328 6 0 1 day35 USDHello!!!
I can start your work right now, I have experience
Feel free to contact me
-
7 days75 USD
2587 51 1 7 days75 USDHello!
I have experience in developing complex integrated systems, including on Google Apps Script with Telegram integration, dashboards on Chart.js, and custom interfaces.
Your project is very close to me — essentially, it is already a formed system that needs to be given a modern look, convenience, and a bit of "intelligence."
What I will do:
• I will bring all forms to a unified responsive design (neat display on mobile, modern UI);
• I will implement Telegram notifications for new entries (via Bot API, stable and error-free);
• I will create dashboards with analytics on Chart.js / Google Charts (volumes, clients, dynamics);
• I will set up the main menu with logical navigation between sections;
… • If necessary — authorization (Google OAuth or a simple login form).
The approach — maximally tidy code in GAS, with caching and structured functions, without breaking existing logic.
The result — a stable, fast, and pleasant-to-use system that can be presented to the team as a finished web application.
Timeline: about 7 days (depending on the detail of the dashboards).
After delivery — I will help with the publication of the Web App and technical instructions for users.
I would be happy to join and help make your system truly convenient for daily work.
-
1 day50 USD
10123 117 0 1 day50 USDHello.
I am a NodeJS developer. I have experience with Google Apps Script and Telegram. I am ready to take on the task. Write to me, and we will discuss.
-
3 days25 USD
981 6 3 3 days25 USDHello, Narek! I am ready to complete it, write to me in private messages, we will discuss.
Current freelance projects in the category HTML & CSS
Layout of a page for a website on Khoroshop + and editing 2 written pages
112 USD
Hello! Task: To create the "Loyalty Program" page and make adjustments to the "Wholesale Cooperation" and "Corporate Orders" pages Page "Loyalty Program": - Create the page in HTML code according to our design in Figma - Adapt for desktop and mobile versions, iOS and… HTML & CSS ∙ 14 hours 21 minutes back ∙ 27 proposals |
Need a developer for WordPress
607 USD
Looking for a developer to implement a website on WordPress. Below I have detailed the project and requirements. About the project Here is the link to the design https://www.figma.com/design/htJTa5T5vY3oIlMOlZlI1o/Estate-Services?node-id=6315-2&t=gNsXRNevlb0hpS9h-1 Currently,… Content Management Systems, HTML & CSS ∙ 17 hours 48 minutes back ∙ 62 proposals |
I am looking for a person who can help fill the advertising agency website on WordPress.I created the pages in the cloud and now I have done everything on WordPress. I am looking for someone who can help fill the website with content. Quickly and efficiently, certain photos will probably need to be generated in GPT. I will try to help. There are about 15 pages. AI Content Creation, HTML & CSS ∙ 20 hours 6 minutes back ∙ 33 proposals |
I need to create a website from a PDF, is it possible?The design is already fully drawn but we only have it in PDF, as the Figma file was lost... There may be discrepancies with it. This is acceptable. Do we need to redraw it in Figma? Or is it possible to layout and put it on a CMS, and if so, which one? There will be a lot of… HTML & CSS, Web Programming ∙ 20 hours 8 minutes back ∙ 98 proposals |
Development of a WordPress + WooCommerce online store# Development of an Online Store for Agricultural Equipment The design mockup is currently in the final stages of development. I fully understand that without a ready mockup, the final estimate will be inaccurate. However, if you have already implemented similar e-commerce… Content Management Systems, HTML & CSS ∙ 1 day 4 hours back ∙ 63 proposals |