API Automation Nova Poshta via Excel / Google Sheets + NOVA POSHTA Scanner (registry reconciliation)
Task:
It is necessary to verify the parcels available in the New Post registry by scanning the parcels in the warehouse with a barcode scanner.
There may be ready-made solutions - I would appreciate any help...
There is a barcode scanner like the one at New Post (Android). So it can be directly on that Android, or on a computer in Google Sheets. I see it like this - we scan with the scanner into Google Sheets, we upload the registry via API from New Post into the spreadsheet, and formulas highlight those that match (scanned and available in the registry) and in other colors those that are missing in the registry, duplicates, etc.
I would appreciate any suggestions and proposals for implementation.
Applications 1
Client's review of cooperation with Andrey Krasik
API Automation Nova Poshta via Excel / Google Sheets + NOVA POSHTA Scanner (registry reconciliation)The result exceeded my expectations, new ideas and additions - highly recommend.
Freelancer's review of cooperation with Igor Zhyravka
API Automation Nova Poshta via Excel / Google Sheets + NOVA POSHTA Scanner (registry reconciliation)It was comfortable to work, quick responses. And quick implementation of the client's task.
Thank you for the collaboration!
-
Hello, I worked on automating warehouse accounting with API integration for a logistics company - the barcode scanning and database reconciliation system processed over 1000 packages a day ✅
I’m curious if you also plan to add a feature for automatic real-time status updates for packages via Nova Poshta's API?
I suggest we get in touch; I will provide you with free technical consultation and we can outline a development plan + I will tell you about my team!
-
516 Hello, Igor!
To understand the task in detail, please clarify:
1. Do you have access to the Nova Poshta API for uploading registers?
2. How many parcels usually go through scanning?
3. Is integration with any other service needed, besides Google Sheets?
4. Are there any requirements for visualizing the results (colors, formats)?
Approach to work:
… - First, I will set up data import from the Nova Poshta API into Google Sheets.
- Next, I will integrate the barcode scanner with Sheets for automatic entry of scanned data.
- I will use formulas to highlight matches that are missing in the parcel register and duplicates.
- I will ensure the stability of the system and ease of use for the user.
As a result, you will receive an automated system that allows for quick and easy reconciliation of parcel registers, significantly simplifying the inventory process in the warehouse.
Igor, please send your answers to the questions above in personal messages - we will discuss the details and I will suggest the optimal implementation option.
-
3139 31 0 Hello! I am ready to implement a convenient and reliable reconciliation system for you. I suggest we go with the option of Google Sheets as the most flexible and quick to develop. The scan code will automatically go into the sheet, and my script (Python/Apps Script) will instantly pull the current registry through the Nova Poshta API, automatically marking matches, duplicates, and missing items with colors. I will deliver the project "turnkey" in 1-2 days, including testing and error adjustments (for example, if the NP API is temporarily unavailable). Let's discuss the details!
Current freelance projects in the category Web Programming
Responsive Portolio Website Design ( wordap - selling and buying website )I need a clean, modern portfolio site that follows my existing brand guide and adapts beautifully to desktop, tablet, and mobile. The site’s job is simple: highlight my work through high-impact photos, embedded videos, and detailed case studies so visitors immediately understand… Content Management Systems, Web Programming ∙ 13 hours 28 minutes back ∙ 31 proposals |
Moved the website from OpenCart to the Khoroshop platformHello. There is a website on OpenCart, an online store. It is necessary to transfer the structure of the site to the GoodShop platform, select a design for the new site, and make it fully functional. HTML & CSS, Web Programming ∙ 17 hours 8 minutes back ∙ 25 proposals |
Making edits to the website (WP, Elementor)Good day. We need to make 2 changes to the website: 1. The main menu "jumps" when hovering the cursor, plus in the Ukrainian version it is vertically centered (as it should be), while in the Russian version it is not centered, at the top. We need to center the Russian version… Web Programming ∙ 19 hours 44 minutes back ∙ 65 proposals |
It is necessary to modernize the admin panel in Open Cart for convenience.Technical assignment for configuring/improving OpenCart 1. Catalog → Products Task 1. Add a "Category" column to the product list Task 2. Add a "SKU" column to the product list Task 3. Add a "Creation date and time of the product" column Task 4. Quick edit of main product data… Web Programming ∙ 20 hours 1 minute back ∙ 53 proposals |
Improvement of the catalog for the websiteFor the catalog website, improvements need to be made: (the work can be divided into stages or taken by qualification part) 1. In the admin panel, the ability to upload SQL files for updating prices (in the archive it is price_balluff_2026_for_site.sql). (currently they are… AI Content Creation, Web Programming ∙ 20 hours 9 minutes back ∙ 31 proposals |