Pull prices via API into Google Sheets
Task:
DocDream program
https://docdream.com/index.php/uk/whats-new/134-2021-12?start=2
There is a Google sheet that is connected to the website and imports prices from the sheet to the website on request.
Prices are divided into categories and subcategories on the website and in the sheet in the same way.
However, in the Docdream program, prices have a different categorization.
The task is to create a script that, upon request or within a specified time interval, will compare prices from the sheet with prices in the program.
If the price in the program has changed (the names of the prices are the same in the program and in the sheet) - we change it in the sheet.
If no price with that name was found in the program, we highlight it in red in the sheet.
If a service price was found in the program that is not in the sheet, we either add it to the same category (the category matches in the program and in the sheet), or if there is no category match, we place this price in a separate column and highlight it in yellow.
If the price is new, its name is pulled from the program as in the original, and in the adjacent column - an automatic translation into Russian.. currently this is done manually.
-
614 21 0 Hello. I can do your project. I have experience. Write to me and we will agree.
-
988 9 0 Good day!
I have studied your project and have relevant experience.
Such support costs 22000 UAH/month.
If these terms are okay for you - we will prepare a detailed budget estimate.
-
2910 42 0 Good day.
I have experience with Google Sheets, Cron, JS, PHP, Node.js
I can complete the task quickly and efficiently.
-
202 Good day!
I have reviewed your technical assignment. The task is interesting and realistic.
I am ready to take on the development, and from my experience, I can also suggest a few improvements for the reliability of the script. For example, it is better to use a unique article (if available) for comparing services, rather than just the name, to avoid errors due to typos. It is also worth adding a simple report on the script's work so that you are always aware of what has been updated.
I suggest discussing the details in private messages. I am ready to answer your questions.
-
10365 30 0 3 Good day!
I have reviewed the submission, I have ideas for implementation, I will execute quickly and professionally.
-
4464 102 0 Good day. I will be happy to help. I will complete everything quickly and efficiently!
-
981 17 0 Good day!
The idea is clear, I am ready to execute: I have written many scripts for similar tasks. I would like to take a look at the table structure.
-
531 33 0 Good day, I can do it, I have been working with JS, TS, node.js for more than 5 years.
-
1449 24 3 Hello.
I have experience in completing similar tasks, so I am confident that I can deliver everything with quality and within the agreed deadlines. I am ready to start soon. Let's discuss the details in private messages.
-
10063 117 0 Hello.
I have experience working with Google Sheets. I'm ready to take it on. Write to me, we will discuss.
-
4272 25 0 I will write it in Go, it will be possible to use both by schedule and by call (for example, with a GET request). It will be a separate service that needs to be hosted on a server. There will be three integrations: Google, Docdream, translator (you did not specify what to use for translation). There will be category mapping and your described logic.
-
3621 113 7 1 Hello.
I have extensive experience working with Google Sheets and Excel.
I also create scripts for the aforementioned programs.
Check out my portfolio and reviews.
Freelancehunt
I have reviewed the project. I am ready to help with the implementation.
Write to me - we will discuss the details.
-
2882 26 0 Good day, I am interested in your project, I will make a script in n8n/python. I am ready to discuss the details.
-
цены имеют другую категорийность - можно более подробно узнать, что и как нужно стыковать
-
Current freelance projects in the category Data Parsing
Data parsing through mobile APILooking for a person with experience in data parsing through mobile API, for parsing e-commerce, rozetka and similar sites. Tasks: 1. Intercepting traffic from the mobile application (Android), setting up a proxy, analyzing requests. 2. Identifying the necessary API endpoints… Python, Data Parsing ∙ 1 day 5 hours back ∙ 25 proposals |
Looking for a programmer or vibe coding Automation scraping data 2https://drive.google.com/file/d/14tP5XWJB9acV4gn_cJrFwMpihUj3EbQz/view?usp=sharing I accidentally sent that link Web Programming, Data Parsing ∙ 1 day 7 hours back ∙ 33 proposals |
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 6 days 2 hours back ∙ 19 proposals |
Creation of an Excel file for uploading products to the websites of other partners.I am interested in creating an Excel table with all parameters. Here is the website - https://heiztechnik.com.ua/ And the positions I am interested in to be transferred: Manual boilers: 1) TIS UNI 15-95 kW (10) pcs 2)TIS HARD 150-500 kW (7) pcs Pellet boilers: 1)TIS PELLET… Data Parsing ∙ 6 days 6 hours back ∙ 38 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 6 days 9 hours back ∙ 42 proposals |