Using Make to subscribe *specific* rows from a google sheet

Hi everyone!

Trying to set up a Make scenario that does the very standard, “take a new row from Google and add subscriber to Email Client.” However, we are pulling users from a general contact form and only want to subscribe those who check the “add me to your email list” checkbox.

I tried to use an “if” formula to check said column and generate a successful subscription status if the text was present and an ineligible status if not (so Make would trigger on every row, but essentially fail to create subscribers if the checkbox wasn’t present). But that seems like a very inelegant method (and also wasn’t creating any contacts).

Make seemed to think it was being successful (no error messages), but no new contacts appeared in my email client.

Any suggestions? I can’t imagine I’m the first to encounter this hurdle, but I was having trouble finding the right terminology to find other help threads.

Thanks in advance!

In google sheets search
you can add a filter for that column to have data equal to add me to your email list

Some thing like this


If you are using a watch module
instead of doing filter in module do it in between the two modules

2 Likes