Відкрито

Google Drive automation -- 2

We are in need of someone that can write a google script that will pull image links from a drive folder.

Those links need to be assigned to rows based on their names.

The image names are the same as product names on the sheet.

While this is a quick task, we often run into needing to do these kinds of things in google docs,

so we'd like for whomever we hire to keep this contract open indefinitely to help us from time to time.

Inventory sheet.

This is a copy of a working file.

You may check the developer resources for Shopify CSV upload,

but I think it needs to be linked not embedded images.

Here is inventory data sheet and image folder.

[login to view URL]

Image folder: [login to view URL]

Inventory sheet. This is a copy of a working file.

You may check the developer resources for Shopify CSV upload,

but I think it needs to be linked not embedded images.

We just need to populate the image column mapped to the Option 1 value column. Some of them have a link to the image that they manually placed on Shopify. While spot-checking through these though, it looks like some of the image files (i.e. 3327_02) do not match to a value.

After spot-checking this further, I see the issue there's a lot of obscure image file names that have no name matches to anything in the sheet.

Okay, I'm going to use Amber 4045- 1 in the option1 value column as an example. The image for that in the drive folder is just called [login to view URL], so this just got a little trickier. Some of the image names. However, something just got a little easier. We only need to map to the rows that have a value in the title column NOT the option1 column. Using Amber as an example again. It has a bunch of color variants, but they do not have images for it, so they're just using the one pic, so we don't want images on all of the variants.

Ohh... Most of them already have an image link.

I've been back and forth with them, but I think we have it figured out. The image field does, in fact, need to be mapped to the Option1 Value column. But it's not quite that direct. Some of the images will match a name and some images will map to a number at the end of the name (i.e amber 4045- 1 = [login to view URL]). She added a sheet called product guide that has some of the alternate names. On that note (using amber 4045 as an example again), you'll see it has a couple of different variants but no other images that relate. If that's the case, it just needs to be the [login to view URL] or left blank - whatever's easiest (preferably blank). I added a sheet called image directory that has all of the images and drive links. Some of the images will not have a product in the inventory (they have some products that will not be offered on Shopify). Let me know if that makes sense.

If it helps, typically anything after a "-" is the color code. They have a color chart of 915 colors that correspond to those codes.

Thank you

Навички: Інтелектуальний аналіз даних, Обробка даних, Data Scraping, Google Sheets, Process Automation

Деталі: google drive api-python, google drive api pricing, google drive api java, python download file from google drive, google drive api create folder, google drive api list files in folder v3, google drive api, google drive rest api example, google api server gps tracking using aspnet, use google maps map addresses database using aspnet, eyeos google drive, google maps distance calculator api using address, thank using shopping system cart, google map api sidebar directions using map, google drive distance calculator, download file from google drive using java, download file using wget from google drive, upload file to google drive using java, using google drive to host a webpage, automatic file upload in google drive using php(without login)

Про роботодавця:
( 0 відгуки(-ів) ) Vang Vieng, Lao People's Democratic Republic

ID Проекту: #25656374

11 фрілансерів(-и) у середньому готові виконати цю роботу за $12/годину

corporatessc

Hi There, I can write a google script which will pull the image link & place them on the rows in the sheet. I am a Google Apps Script developer with more than 5+ years of experience. I run a company specialized in d Більше

$15 USD / година
(5 відгуків(и))
3.7
BaNgan

Hi there I can use google apps script to grab the image name and inject them into spreadsheet using google apps script Let me know Ngan Le

$25 USD / година
(7 відгуків(и))
3.8
$11 USD / година
(0 відгуків(и))
0.0
$13 USD / година
(0 відгуків(и))
0.0
Abdulmalik795

Hello, I can help you write the Google script for Google drive automation. I would like to know what's need to secure this bid. Thanks.

$8 USD / година
(0 відгуків(и))
0.0
bhabeshmahato574

I will very carefully handle your project. I am an experience of 2 years in data entry field. So you don’t mine.

$8 USD / година
(0 відгуків(и))
0.0
RealSolutionz

Dear Booking Manager, I have read your requirements regarding google drive automation , and find myself efficient enough to fulfill [login to view URL] will be no compromise with the quality of my work. Kindly provide me the c Більше

$8 USD / година
(0 відгуків(и))
0.0
tusharsingh8585

i m agree to do this work if you are satisfy so give me that work to me i will be complete in given time and amount

$11 USD / година
(0 відгуків(и))
0.0
prajvalmandawdha

Hello sir/ madam I am interested in your project. I am expert in typing i am brilliant in it . My typing speed is 60-70 words per minute. I am skilled in MS word ,MS powerpoint,Excel,typing I have done my studies in Більше

$8 USD / година
(0 відгуків(и))
0.0
chiarahdt

Hello I have seen your project details. I have knowledge about it, working in this field for 3 years at the academic planning department of Thomas More University. Besides that I can do it for a super cheap price in co Більше

$8 USD / година
(0 відгуків(и))
0.0
consuelocamargop

Hello, I hope you are doing well My name is Consuelo, I am a professional in international business with more than 7 years experience in various corporate fields such as sales, import/export, customs, logistics and w Більше

$12 USD / година
(0 відгуків(и))
0.0