Create a Google Sheet App Script from the menu
The script must take the necessary information from two different .csv files and insert it into the Google Table. Through the user menu it is necessary to specify the required tab and column where to enter the data and download .csv from where the information will be taken. Rarely do one and the same.
In order to find the necessary information in the first .csv file you need to take the name of the product, for example ABC-001, find this line in the .csv file and from the necessary columns to take the data and enter the necessary Google File line.
In order to find the necessary information in the second .csv file you need to take the name of the product, for example ABC-001, to sort all the values with this name and before inserting them into the Google File you need to resume these data.
I wrote a scheme that we take from .csv and where we put it in the Google Table. A total of two .csv values must be 10 values.
More details personally.
Applications 1
Work results
Client's review of cooperation with Artem S.
Create a Google Sheet App Script from the menuThe task is performed quickly and efficiently according to the TZ.
Freelancer's review of cooperation with Vitalii S.
Create a Google Sheet App Script from the menuEverything went well. I recommend cooperation.
-
5899 345 0 I can realize the reading of the required data from the csv files in the Google table after a detailed task discussion.
-
4945 491 0 2 Welcome to!
Please show all the materials from which you need to get information and where to place it.
Get back, as soon as I can help you.
-
Де розташовуються файли csv?
-
Я їх завантажую на ПК. Далі зможу зробити зними, що буде необхідне для спрощення задачі. Як я зрозумів, то я можу їх завантажити на Гугл Диск і буде посилання на файл.
-
Current freelance projects in the category Java
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 ∙ 5 hours 2 seconds back ∙ 7 proposals |