Google Sheets data parsing
11 617 USD I use Google Sheets, and I have a similar document there: https://docs.google.com/spreadsheets/d/17Te0Vf_8kyd3MUkB33Yt422f4JV1wcqPleCIRBXpAsM/edit?usp=sharing
I need to check if there are VAT numbers in the system https://ec.europa.eu/taxation_customs/vies/#/vat-validation specified in the Excel file. Column B should display whether they exist.
Important requirements:
- The website https://ec.europa.eu/taxation_customs/vies/#/vat-validation is quite slow, so try to get only the necessary information without attempting to load images, etc. The number of codes in the test table should be checked in 5 minutes or less. If this cannot be implemented, please notify me, and we will discuss solutions.
- Propose all possible solutions. It can be done through app script, or not through app script, but if all else is equal, I would prefer it to work without app script. Suggest possible implementation options. (but in any case, everything must work in Google Sheets; exporting the file and performing any manipulations with it on a PC will not work as I have many connections in Google Sheets, and downloading the file will break those connections)
- I am showing a video on how to perform the check manually: https://svajok.tinytake.com/msc/MTAzNjgxMThfMjQwNTcyODc
Propose prices and solutions
-
1 day11 617 USD
3420 32 0 1 day11 617 USDGood afternoon
I am ready to help with solving this issue through AppScript, for details and price clarification please write in private messages
we get this response
https://imgur.com/zjeHZLi.png
it can be adjusted to your needs or a script can be written in Python, it will work much faster than 5 minutes
-
12 days11 617 USD
8867 60 0 1 12 days11 617 USDДобрый день. Готов выполнить.
Имею большой опыт реализации парсеров.
Мое портфолио:
Freelancehunt
Сделаю решение, которое позволит извлекать необходимые элементы с нужного сайта, сопоставлять их с информацией в таблице и отображать в столбце совпавшие элементы.
Настрою загрузку только необходимых элементов сайта для максимального быстродействия. Получите необходимую скорость проверки и сопоставления кодов.
Пишите, обсудим детали и я приступлю к работе.
-
1 day11 617 USD
428 5 0 1 day11 617 USDhttps://fastestate.xyz/spreadsheet/
I have already implemented it, it collects very quickly
You can test it
-
1 day11 617 USD
93984 1263 1 10 1 day11 617 USDHello. I am ready to implement the task using their API. Please contact me.
-
1 day11 617 USD
1005 9 1 1 day11 617 USDHello, I have already implemented your task on app script, checking all the codes from the example takes a few seconds. Write to me, I will provide the solution 🤝
80 EUR (I indicated the minimum possible in the rate)
-
1 day11 617 USD
2912 44 0 1 day11 617 USDGood afternoon.
I am ready to complete it, we can discuss implementation options in private messages.
-
1 day11 617 USD
5195 210 0 1 day11 617 USDGood evening.
There is a theory on how to do this within Google Sheets without resorting to third-party software.
But I will be home and can check in about an hour. Write in case of anything.
-
1 day11 617 USD
649 6 0 1 day11 617 USDHello, Pavel! There is an implementation option without any scripts, using an automation platform (details in private message). I made a similar integration solution for Google Sheets and OpenAI - everything works great within the spreadsheets, without exports, etc. You just add or edit a row, and the service automatically processes the new VAT value.
-
3 days11 617 USD
4327 215 0 1 3 days11 617 USDGood afternoon, I can implement it in nodejs. Message me privately to discuss the details.
-
3 days11 617 USD
981 17 0 3 days11 617 USDHello!
It seems that the service has an API. I can develop a script that will check the entire list in your file.
I think this is the most suitable solution. Write to me - we will discuss the details of such implementation.
-
2 days11 617 USD
3777 111 3 5 2 days11 617 USDHello, Pavel,
The information you need can be obtained using a regular GET request. If you do not want to use App Script, you can write a small form where you will add the numbers. This form will check the validity of the numbers against the database and record them in Google Sheets. This will cost 200 EUR.
Best regards, Yuri
-
3 days11 617 USD
9120 367 0 3 days11 617 USDGood evening
I am interested in your project.
I would like to discuss everything in more detail.
-
1 day11 617 USD
238 1 0 1 day11 617 USDGood afternoon,
Middle nodejs dev with 4+ years of commercial experience.
Write to me, I have an idea on how to implement it through Google API.
-
10 days11 617 USD
1788 20 0 10 days11 617 USDReady to do it, tests are done, it can be implemented.
What is the approximate volume of checks planned?
Message me privately to discuss the details and implementation methods.
-
Добрый вечер
Скиньте несколько кодов для теста
-
https://fastestate.xyz/spreadsheet/
у меня уже реализовано ,, собирает очень быстро
можете тестировать -
Current freelance projects in the category Data Parsing
Need a parser for the online store https://www.lcsc.com/It is necessary to regularly (once a month, or upon script launch) obtain up-to-date information about the products available in the store. https://www.lcsc.com/ from the catalog of all sections.… Data Parsing ∙ 16 hours 38 minutes back ∙ 39 proposals |
OpenCart — rental catalog of special equipment
135 USD
OpenCart — Equipment Rental Catalog Need to launch an equipment rental catalog on OpenCart. Theme: excavators cherry pickers forklifts generators cranes scaffolding other construction equipment. It is preferable that you already have a ready-made template or developments… Web Programming, Data Parsing ∙ 1 day 9 hours back ∙ 54 proposals |
Transfer the program - the server where the program was located has crashed (officially permitted parsing of government data)
46 USD
Hello! My client has encountered the case described below. We need help transferring to a new server and testing the program. It would be better to have a programmer who understands parsing. Software & Server Configuration, Data Parsing ∙ 1 day 12 hours back ∙ 29 proposals |
Website parsingImplementation of 4 parsers (directory websites) is required. There is a technical specification, and there is a code example as a reference. The tasks include: Writing a parser Integrating a proxy Deduplication logic (transfer the logic from the example) Hashing logic based… Data Parsing ∙ 3 days 5 hours back ∙ 44 proposals |
Collection (parsing) of product database from supplier websites (Excel / CSV)
226 USD
Collection of product database from supplier websites (Excel / CSV) Good day. A specialist is required to collect and structure data from several supplier websites, access to which will be provided.Task: A unified product database needs to be created in Excel (XLSX) or CSV… Web Programming, Data Parsing ∙ 4 days 12 hours back ∙ 107 proposals |
Vilnyus