Hey everyone,
I’m working on a project that involves a Google Sheet and Zapier. My sheet has two columns:
- Email addresses
- A true/false field
I’m trying to figure out how to create a Zap that grabs only the email addresses from column 1 where the corresponding value in column 2 is ‘true’. Can anyone point me in the right direction?
I’ve been scratching my head over this for a while now. Any tips or step-by-step guidance would be super helpful!
Thanks in advance for your assistance. Really appreciate the community’s expertise on this one!
Cheers,
Alex
Alex, I encountered a similar challenge before and found a solution that might work for you. Start by setting up a trigger in Zapier for a new or updated row in your Google Sheet. Next, add a filter to allow the Zap to continue only when the true/false field actually shows ‘true’. Then use a formatter to extract the email address and finalize your Zap with your desired action, such as sending an email or adding to a mailing list. This approach should meet your requirements effectively.
hey alex, try using sheets QUERY: =QUERY(A:B, “select A where B = true”). this will output emails with true flag. set your zap for new rows in that filtered list. hope it works out. lemme know if ur stuck
I’ve actually tackled this exact problem in a recent project. Here’s what worked for me:
Instead of relying solely on Zapier, I found it more efficient to use Google Sheets’ built-in FILTER function. Create a new sheet and use this formula:
=FILTER(Sheet1!A:A, Sheet1!B:B=TRUE)
This will automatically populate a list of email addresses where the corresponding value is TRUE. Then, set up your Zap to trigger on new rows in this filtered sheet.
This approach reduces the load on Zapier and ensures you’re only processing the relevant emails. It’s been a game-changer for my workflow, making everything much smoother and more reliable.
Hope this helps streamline your process, Alex!