Logical flow for finding values from a sheet

https://www.gumloop.com/pipeline?workbook_id=s1iDtH12yG5rwkKWyK2N3S&tab=3&run_id=3z7Nr96zHuwXtLZb86pdBJ

I have a list of 3 items. My job is to find the items individually from another sheet of 50 items & fetch the corresponding value from the next column of the sheet.

Eg: I have an item INDIA in a list. My automation should skin through a list of all the countries in a sheet, find INDIA & give me let’s say DELHI as output (from a sheet with countries & their capitals). If it doesn’t find INDIA, it should give me a “NOT FOUND”.

Is it possible?

Hey @Arjav_Modi! 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.
    GIF guide

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

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

I used the custom node & created a subflow for the same. It did a great job after a couple of small tweaks. You can consider this thread closed.

Appreciate the update, thank you! :raised_hands:

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.