This is a test table. Each tab is a separate table with prices that is pulled to the website. From the CRM system, the price can be extracted "in bulk" without separating into categories that are created on the website.

A script is needed that will compare prices from the tab, for example, upload bucha (we upload the entire price list there) with the price list that is divided into categories and structured and pulled to the website - this is the tab "bucha".

The script compares prices in two tabs and follows these principles:

For each clinic, there should be a pair of tabs:

working: bucha, vasilkiv, borodyanka, vestanew, nmdental …
— column H: Ukrainian name of the service
— column J: price (number/UAH)
— 1st row — headers
— RU-column (there is =GOOGLETRANSLATE(...)) is not used and is not touched.
upload: upload bucha, upload vasilkiv, …
— A: Ukrainian name of the service
— B: price or text не діє
— 1st row — headers
— without merged cells.

The script is triggered on demand and changes only the active sheet and automatically searches for a pair of the form upload {sheet_name}. Other tabs will not be touched until I run them. For each clinic, just keep a pair of tabs:

borodyanka ↔ upload borodyanka
vasilkiv ↔ upload vasilkiv
vestanew ↔ upload vestanew
nmdental ↔ upload nmdental
bucha ↔ upload bucha

The active working sheet (for example, bucha) is automatically linked to the sheet upload bucha.
Matching is done only by Ukrainian name (column H on the working, A in upload).
Highlighting logic:
- Red on the working sheet — the service is in the working price list, but not in upload OR in upload marked as “не діє” → needs to be removed from the working. (The script by default just clears the price and colors the row; physical deletion of the row can be enabled as an option — .)
- Green in working and in upload — the price has been updated.
- Blue in working and upload — the price matched.
- Yellow-amber in upload — the service is in upload, but it is not in working → needs to be added to the working.
- Gray in upload — the row is marked as “не діє” (for clarity).
In the upload sheet, a column “Source (H1 etc.)” appears to the right of the price with a link to the cell in the working bucha. to understand which cell in the working price list the price came from.

The script should take into account possible spaces, dashes..i.e. compare by keywords, not identical content.

Proposals 10 Discussions 2

Andrey K.

1 292 1

Budget: 8000 UAH Deadline: 5 days

Hello. I have extensive experience with JavaScript. I am ready for collaboration.

Vladyslav Laba

1 0

Projects -
Rating -
Rating 309

Budget: 5000 UAH Deadline: 3 days

Hello, we are ready to complete your order. We will do it quickly and efficiently.

We look forward to collaborating!

Oleh Patrushev

21 0

Projects 21
Rating -
Rating 612

Budget: 1000 UAH Deadline: 3 days

Hello. I can complete your order. I have experience. Write to me and we will agree.

Anton T.

345 0

Budget: 777 UAH Deadline: 1 day

I write scripts for Google Sheets, will consider the details, will propose implementation.

Sergiy Turenko

11 0

Budget: 2000 UAH Deadline: 2 days

Hello. I am ready to take on the task. Below is a short application. Technologies: connects to Google Sheets API, takes data from a couple of sheets (for example, bucha and upload bucha), compares prices and names considering spaces/hyphens, generates results (price updates, list for deletion/addition, color labels), can even update the table back (coloring cells, adding a "Source" column).

Valery Korovkin

10 0

Budget: 2000 UAH Deadline: 2 days

Hello, Anton!

I have already developed a similar script for matching services based on descriptions - there is a ready-made solution. I will implement the script in Python taking into account all requirements (comparison by keywords, working with tables).

I will complete it in the shortest possible time, and I am also ready to help with updating/improving the script in the future.

I look forward to collaborating!

Tetyana S.

74 4

Budget: 700 UAH Deadline: 2 days

Hello! I have a lot of experience working with Google Sheets! I have written over 300+ scripts for these sheets!!! Contact me!! I can start right now!!!!

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Anton Anton
Kyiv, Ukraine

Projects 30
Rating 5.0
Rating 2 485

It is necessary to create a script for price comparison in Google Sheets.

Client's review of cooperation with freelancer

It is necessary to create a script for price comparison in Google Sheets.

5.0

Anton Anton

Freelancer's review of cooperation with Anton Anton

It is necessary to create a script for price comparison in Google Sheets.

5.0

Andrey K.

Vladyslav Laba

Oleh Patrushev

Anton T.

Sergiy Turenko

Valery Korovkin

Tetyana S.

Proposals are currently absent

Current freelance projects in the category Java

Real-Time Trainer