Google Drive - Pick a file (.jpeg)

[Donna]

Hey good morning!

I have a flow where a filter will look in a google sheet and pick the correct item from the sheet, let us say item 1.1

In a google drive folder I have images, among them image 1.1

Now I want use the filter value to pick the correct file from google drive so I can use it in the next node (image recognition).

How would I set this up?

Be well!

Bart

[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

[Rithen_Gumloop]

Hey @Donna, hope you are doing well🙂.

I’m assuming you’ve already figured out the part where you pick an item from a Google Sheet. If you have the file name available, you can build a Google Drive MCP node that takes the file name as input dynamically and outputs the file URL from that folder.

I built a custom node that does this and shared it with you for reference, you can customize it further if needed. Once you have the URL from the Google Drive MCP node, you can use it in the next nodes (like for image analysis).

Let me know if this works!

[Donna]

Rithen,

Good morning.

Would be great if you can share it with me!

Thanks,

D

[Rithen_Gumloop]

Good morning Donna,

I already shared the Google Drive MCP node with you. If you go to your Node Library and search for “Google Drive File URL Finder”, you should be able to find it.

When I was building the node, I used this prompt:

“Given a file name and a folder URL, output the corresponding file URL from that folder.”

Let me know if that works!

[Donna]

Thanks. Did not know you could share like this. Could be an idea to set-up a library for all to enjoy these type of “special” nodes

[Donna]

It works … much approciated!

[Rithen_Gumloop]

Awesome! If you hover over the MCP/custom nodes you’ve built, you’ll see a share option to easily send them to others. And yeah, a page for interesting custom nodes could be really cool, appreciate the idea!

[Donna]

@Rithen_Gumloop see this … there is something wromg with the url (I think ) …

[Donna]

hey, and how can I edit the code in a custom node … ?

[Donna]

Because I get this error:

Google Drive File URL Finder Failed!
The code in the function body raised the following error:

Command exited with code 1 and error:
Traceback (most recent call last):
File “/index.py”, line 168, in
print(‘FUNCTION_OUTPUT\n’ + str(main(‘3.3’, {‘Folder URL’: ‘https://drive.google.com/drive/folders/1JtlHvVX4Gt75oJswirqtyYR4bKd1J280’})))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/index.py”, line 89, in main
raise FileNotFoundError(error_msg)
FileNotFoundError: No files found matching ‘3.3’ in folder ‘https://drive.google.com/drive/folders/1JtlHvVX4Gt75oJswirqtyYR4bKd1J280’

[Donna]

Fixed it … (folder was empty)

[Donna]

Not really …

Analyze Image Failed!
Failed to process file from the link: Unsupported content type: text/html; charset=utf-8

Keeps popping up …

[Rithen_Gumloop]

Hey Donna,

You can solve this easily. Once the Google Drive custom node outputs the file link, pass that into a Google Drive File Reader, and then connect it to an Analyze Image node. Just make sure that in the Analyze Image node, instead of using the link input, you switch to the file input — you can do this by hovering over the node, clicking Configure inputs, and selecting the file option. Once you make these changes you should be all set.

Also quick note: You currently can’t edit the custom node I shared, but you can recreate it quickly by prompting a new Google Drive MCP node.

Let me know if you run into any other issues while trying this!

[Donna]

It works … you are the best !
(I ran in such problems a lot since I used Gumloop. You should do a very clean write up on how to use Google drive and folder/file reader and writer)

[Rithen_Gumloop]

Hey Donna, glad that solved it! Also, we have documentation covering all the available nodes here: docs.gumloop.com. If you run into any other issues or edge cases, let us know and we’ll be happy to help.