Need ideas ... Google sheet with url's, they point to an image ... need to store them as jpeg

[Donna]

Hey there,

Need some ideas from the community (and @Wasay-Gumloop )

I have a google sheet with url’s. Each url is a picture of an item
I need to open the url, and save the image in a google drive folder
I can not use analyze image …

How could I solve this littel riddle?

Be well,

D

[Gumloop_Bot]

Hey @Donna! If you’re reporting an issue with a flow or an error in a run, please include the run link and make sure it’s shareable so we can take a look.

1. Find your run link on the history page. Format: https://www.gumloop.com/pipeline?run_id={{your_run_id}}&workbook_id={{workbook_id}}

2. Make it shareable by clicking “Share” → ‘Anyone with the link can view’ in the top-left corner of the flow screen.
   

3. Provide details about the issue—more context helps us troubleshoot faster.

You can find your run history here: https://www.gumloop.com/history

[Donna]

I created a custom node, think that is the easiest (and only?) way. But storing it on my google drive is the next hurdle …

Error message
https://www.gumloop.com/pipeline?workbook_id=nrEKpfb7sUq32VuzfNHr2E&run_id=a9ZHd6Hn4up84KAXQwW6QN

Link to flow
https://www.gumloop.com/pipeline?workbook_id=nrEKpfb7sUq32VuzfNHr2E&run_id=a9ZHd6Hn4up84KAXQwW6QN

[Wasay-Gumloop]

Hey @Donna – You could enable Use Link on the Google Drive File Writer node and then pass the URL in the File URL input field.

Eg: https://www.gumloop.com/pipeline?workbook_id=fnJFPoLrrXr7dMyvmjaSf3&run_id=JebQhRSVWtNhtM9dieicMQ

Is this what you were looking for?

[Donna]

But I first need to get the photo (fro the url) before I can store it in a Google drive folder

[Donna]

@Wasay-Gumloop I do not get it. If I follow your flow I just “load” url’s to a google drive File Writer and it just stores the picture …
Is that correct??

[Wasay-Gumloop]

I do not get it. If I follow your flow I just “load” url’s to a google drive File Writer and it just stores the picture …
Is that correct??

Yes.

Sorry I misunderstood, I thought you were starting the image URL. You want to fetch/screenshot the input URL and then save the image correct? If so, could you share the starting URL please, your run link has the image URL.

[Donna]

@Wasay-Gumloop Still a bit confused. Let me try to explain again

1. Your flow (https://www.gumloop.com/pipeline?workbook_id=fnJFPoLrrXr7dMyvmjaSf3&run_id=JebQhRSVWtNhtM9dieicMQ) works.
2. Here I input the url of the image (as you did) (https://portal20.brandsupporter.com/images/koppelingen/WF330-470_2.jpg)
3. Then it extracts the image from the url and stores it in a google drive.
   (please confirm that this is correct (hard to believe (and how easy)

So a bunch of url’s will be transformed in an image using your approach?

Best,

D

[Wasay-Gumloop]

Yes that’s exactly right! The node or flow is not technically extracting the image since you already have the image URL, its simply uploading that to drive.

So to confirm if you have a spreadsheet of image URLs like this, the flow would work and upload them to drive.