Development of a CRM system on Google Apps Script for an online store (integration with Prom.ua, Nova Poshta)
38 USD TECHNICAL TASK: Development of a CRM system on Google Apps Script for an online store (integration with Prom.ua, Nova Poshta, TurboSMS)
________________________________________
1. General project description
Goal: To create an automated order accounting, calculations, and analytics system based on Google Sheets to optimize the online store's operations and minimize manual labor.
Main tasks:
1. Automate the export of orders from the Prom.ua marketplace.
2. Implement mechanisms for manual order management (creating shipping documents, checking statuses, calculating profit).
3. Set up integration with the APIs of "Nova Poshta" and TurboSMS services.
4. Build a comprehensive reporting and analytics system on separate sheets.
________________________________________
2. Detailed functional requirements
SECTION 1: ORDER DATA
1.1. Automatic export from Prom.ua
• Sources: Integration with three stores on Prom.ua via API.
• Frequency: Automatic check for new scheduled orders (for example, every 5 minutes).
• Fields to be exported (mandatory):
o Order number
o Source store name
o Order creation date and time
o Total order amount
o Prom.ua commission
o Customer payment method
o List of products (if there are multiple products, indicate in one cell separated by commas or in abbreviated form)
o Customer data: Full name, phone, city, and "Nova Poshta" branch for delivery.
• Duplicate protection: When trying to add an order with an already existing number, the system should show a pop-up window (via SpreadsheetApp.getUi().alert()) with a warning "An order with this number already exists".
1.2. Manual addition of orders
• Implement a form or highlighting on the sheet for manual order entry.
• Fields: Order number, Date, Amount, Product, Customer data, etc.
SECTION 2: STRUCTURE OF THE MAIN TABLE (SHEET "ORDERS")
The sheet should contain the following columns (sample structure):
• A: No. (auto-numbering)
• B: Creation date/time (auto-fill when adding a row, format DD.MM.YYYY HH:MM:SS)
• C: Edit date/time (auto-update on any row change)
• D: Order ID (Prom.ua)
• E: Source store
• F: Products
• G: Price for the customer (UAH)
• H: Payment method (Dropdown list: "Promo payment", "Tax payment", "Payment to account", "Cashless", "Cash on delivery")
• I: Prom.ua commission (UAH) (Auto-filled or manual entry)
• J: Acquiring commission (UAH) (Calculated automatically based on column H: for "Promo payment" = G*0.017, for "Tax payment" = G*0.0165)
• K: Additional expenses (these can be: extra packaging at the post office, redirection at the seller's expense, seller's error..) — manual entry (95% of this column will not be filled, i.e., will be empty, by default it should be "0").
• L: Cost price (UAH) (Manual entry)
• M: Net profit (UAH) (Calculation formula: G – I – J – K – L)
• N: % profit (Calculation formula: (M/G) * 100)
• O: Shipping document number (Nova Poshta) (if the shipping document is generated on Prom.ua, it should be pulled into the table)
• P: Shipping document status (Automatic update via NP API)
• Q: Customer's full name
• R: Customer's phone
• R: City/Branch NP
• S: Status "Closed" (set manually after confirmation of receipt and calculation).
SECTION 3: INTEGRATION WITH "NOVA POSHTA"
3.1. Checking shipping document statuses
• Frequency: Automatic check every hour via a scheduled script for all "open" orders.
• Row color indication based on status:
o Yellow: "Preparing for shipment"
o Green: "In transit", "Arrived at the branch"
o Orange: "Paid storage" (up to 3 days)
o Red: "Paid storage" (5+ days)
• Notification system:
o When the status is "Paid storage" and if there are less than or equal to 8 hours left before transitioning to paid mode, a modal window should appear (via SpreadsheetApp.getUi().alert()) that blocks work with the table until "OK" is pressed. The window should list such shipping documents.
3.2. Creating shipping documents (OPTIONAL, depending on the capabilities of the Prom.ua API)
• "Create shipping document" button in the order row.
• After pressing, the script sends a request to the "Nova Poshta" API, using customer data from the row.
• Weight, dimensions, and description – standard values are passed or requested from the user via a dialog box.
• The obtained shipping document number is automatically entered into column O.
SECTION 4: INTEGRATION WITH TURBOSMS
• Implement a "Send SMS" button in the order row.
• When pressed, a dialog box will appear with a pre-set message template, where the shipping document number from column O is inserted. The user can edit the text.
• Upon confirmation, the script sends an SMS via the TurboSMS API to the number from column R.
SECTION 5: Service letters and directories
• Sheet "Directories":
o List for the dropdown list "Source store".
o List for the dropdown list "Payment method".
o Table for storing "floating numbers" (acquiring percentages, delivery rules) for easy modification in the future.
• Sheet "Statistics":
o Dynamic reports that update as data is added.
-
3 days335 USD
3 days335 USD
I previously developed a similar CRM system but without integration with Nova Poshta. I can add this functionality.
However, the cost of developing such a system starts from 15,000 UAH.
If you really want a quality product, please contact me.
-
30 days38 USD
3272 10 0 30 days38 USD
Thank you for the detailed project brief. I can implement an integrated CRM system on Google Apps Script with automatic order import, manual entry, profit calculation, and full reporting in Google Sheets, with integration to Prom.ua, Nova Poshta, and TurboSMS. Here’s how I will approach the project:
- Data architecture: the main ORDER sheet will contain the necessary fields, with auto-filling dates, change tracking, and duplicate protection through a pop-up warning at the interface level.
- Automatic import: time triggers for periodic checks of new orders from Prom.ua, data processing, consolidation into a table.
- Manual entry: a convenient form or highlighting for adding orders with a full set of fields.
- Calculations: automatic formulas for Prom.ua commissions, expenses, cost price, net profit, and profit percentage; critical fields are pulled or filled in manually as needed.
…
- Integration with Nova Poshta: checking the statuses of TTNs every hour, updating fields and indicators with color depending on the status, synchronization with data in the table.
- TTNs and statuses: display and update via Nova Poshta API, convenient visualization of statuses.
- Notifications and visualization: alerts for critical statuses and automatic use of row color coding.
- Reports: separate sheets for analytics: sales, profit, dynamics, KPI.
- Security and access: basic access management and change log.
I am ready to develop a solution according to your project brief and adapt it to your requirements. If needed, I can propose a prototype architecture and initial steps to get started.
-
60 days558 USD
428 60 days558 USD
Good day! We can implement a CRM system for you on Google Apps Script for an online store with integration of Prom.ua, Nova Poshta, and TurboSMS. The system will automatically export orders, allow manual management, create shipping documents, and track delivery statuses, as well as send SMS via TurboSMS. All data will be stored in Google Sheets with calculations of profit, commissions, and summarized analytics, a color-coded status indicator, and modal notifications for important events.
Technology stack: Google Apps Script (JavaScript), Google Sheets, Prom.ua API, Nova Poshta API, TurboSMS API. We can implement automatic triggers, buttons for creating shipping documents and sending SMS, protection against duplicate orders, as well as convenient directories for lists and flexible calculation rules. The system will be easy to scale and support all necessary business processes.
-
90 days602 USD
784 2 0 90 days602 USD
Hello, we have extensive experience in CRM development. I am ready to take on your project. We can work under a contract.
-
14 days602 USD
1762 19 0 1 14 days602 USD
Hello!
We are working on the development of software, websites, automation systems, and more.
We take on projects "from scratch" as well as technical refinements.
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!
-
12 days602 USD
95478 1271 1 10 12 days602 USD
Hello. I work with Google Scripts. I am ready for collaboration. Feel free to contact me.
-
1 day67 USD
682 6 0 1 day67 USD
Honestly, Google Apps Script will look quite bad here. I don't understand what you can gain by using a static solution that will only work when you load the page in the browser. Cost savings on hosting? $5 for hosting per month - that's not the money that will save you.
So the solution is simple - create your small site with reports and necessary functionality and all integrations. Development in Python, as you indicated in your ad tags, is a good solution. FastAPI will handle this task well. For data storage, you can use PostgresDB, which will be able to store all your data and make backups for various situations.
So let's consider this option together, and you will see that it will be a more functional solution that will help you make sales more successful.
Current freelance projects in the category Python
I want my first money
16 USD
Earn your first money at 16 years old I'm a guy from a village and have never had my own money, so I want to start earning and I'm looking for a job Python ∙ 20 minutes back ∙ 2 proposals |
Telegram bot for hiring/searching employees. For job searching.
25 USD
1. General Concept Creation of a Telegram bot for automating recruitment and mutual job searching. The system operates on the principle of active response and mutual confirmation of interest (Double Opt-In). The system includes two roles: Employer (Company Owner) and Worker (Job… Python, Bot Development ∙ 43 minutes back ∙ 24 proposals |
Technical support for web platform (Python/Django)There is a working web project that needs to be maintained and gradually organized, without rewriting from scratch. Project stack: Backend: Python, Django, Django Rest Framework Frontend: Next.js Database: PostgreSQL Infrastructure: AWS (EC2), Nginx There are integrations… Python, Web Programming ∙ 2 hours 52 minutes back ∙ 28 proposals |
Development of a web service with paid access to an online chatGood day, it is necessary to develop a web service that includes: * personal links for users; * a page with a description of the service; * payment through PayPal; * online real-time chat; * video display on the user page; * accounting for paid time and automatic access… Python, Web Programming ∙ 1 day 4 hours back ∙ 67 proposals |
Application developmentI wish to create a mobile application for communication, the app should have audio and video calls, group chat creation, the ability to sync with phone contacts, account settings: email binding, 2FA, phone number, the ability to customize app notifications, change the app… Java, Python ∙ 2 days 1 hour back ∙ 36 proposals |
Dnepr