Ditutup

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

Keahlian: Pengumpulan Data, Pemrosesan Data, Data Scraping, Google Sheets, Process Automation

Lihat lebih lanjut: 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)

Tentang Pemberi kerja:
( 0 ulasan ) Vang Vieng, Lao People's Democratic Republic

ID Proyek: #25656374

12 freelancer menawar dengan rata-rata $11/jam untuk pekerjaan ini

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 Lebih banyak

$15 USD / jam
(5 Ulasan)
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 / jam
(7 Ulasan)
3.8
$11 USD / jam
(0 Ulasan)
0.0
$13 USD / jam
(0 Ulasan)
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 / jam
(0 Ulasan)
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 / jam
(0 Ulasan)
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 Lebih banyak

$8 USD / jam
(0 Ulasan)
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 / jam
(0 Ulasan)
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 Lebih banyak

$8 USD / jam
(0 Ulasan)
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 Lebih banyak

$8 USD / jam
(0 Ulasan)
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 Lebih banyak

$12 USD / jam
(0 Ulasan)
0.0
barneyishere

For the past 1 month, I was working on a similar thing for my internship. So, I am very used to this work. I can finish it within 1 day at the lowest price because I can use my precious work which is very similar to th Lebih banyak

$8 USD / jam
(0 Ulasan)
0.0