Connecting google sheet in If-Else node in workflow

[chriswaterman]

Hi there, I’m trying to create this workflow but not seeing how I connect the Google Sheet node to the If-Else to the ‘Conditions’ section.

Proposed Workflow

1. View sender email address via Gmail
2. Check if email address is on google sheet
3. if email address exists do nothing
4. if email address does not exist, add email and other information fields to the google sheet

[Wasay-Gumloop]

Hey @chriswaterman - The condition in the IF-ELSE node can’t be exposed as a dynamic input as of now. You can use a Filter node here though. Something like this would work: https://www.gumloop.com/pipeline?workbook_id=grNxqerySRrwGc6grjA7hw

Let me know if this makes sense.

[chriswaterman]

Thanks for quick response and that makes sense. So I’d just drop in the google sheets URL into this workflow then?

[chriswaterman]

I just tested this using my personal email (as it’s not included in the google sheet). Even though it says it added the row, I don’t see a new row with my personal email address added to the google sheet.
https://www.gumloop.com/pipeline?workbook_id=5DdLeLwAqt6kH25QX6twcY&run_id=Bmukxu9uZXWdTKjWYy6h4A

[Wasay-Gumloop]

I’ve requested access to view the flow. You can also enable ‘anyone with the link can view’ under the share button.

[Wasay-Gumloop]

I see the issue (subflow was not updated properly). Try using this workbook: https://www.gumloop.com/pipeline?workbook_id=grNxqerySRrwGc6grjA7hw

[chriswaterman]

that worked!! thank you so much for the help.