Only update Google Sheet if item does not already exist

I am scraping profiles and adding them to a Google sheet.

Before adding the profile (A unique link) I want to check to see if the file already has the profile.

I have tried using if/else and filter - but both have their own challenges.

https://www.gumloop.com/pipeline?run_id=9EoJpDcP53RKFK3jVV3h5y&workbook_id=qdaYVPEFTqbcKcK2Ufmuzt&tab=2

How would you achieve this?

Hey @enroh! 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

Hey @enroh – There are a couple of ways to do this, but I think the easiest option is to use the Search Value feature on the sheet reader node. That’ll let you check if a value exists and take action based on that result.

Here’s a quick Loom video walking through it.

You can also take a look at the workflow here for reference.

Let me know if this makes sense and works for you :slightly_smiling_face:

This helps, but how does this work if you are passing multiple URL to check, basically looping.

I am scraping to find multiple URLs, which provides a list to the Google Reader. It seems that can only handle one input at a time?

Yeah it’s easy to do that. Since the flow works for a single URL/Search Query, you can use that as a subflow and loop over a list of URLs.

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