• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Filtering!!

typhon99

Member
Hello everybody>

I have LP connected to google sheet by pabbly , and from google sheet I send emails+whatsapp campaigns by API

The problem is some people already registered but they coming again and putting their data again so they receive same emails and whatsapp messages

this make them angry+ consumes more tasks

I tried to make Google Sheet Lookup to check if they already exist and I added filter (Only continue if >>email does not exist but always shows me error..

Now How can I add filter so somebody already in the google sheet even he put his data in the LP his data doesn't go to google sheet.

Thanks in advance..
 
P

Pabblymember11

Guest
Hey @typhon99

You can use the Lookup Spreadsheet action event in your workflow with filter action step, which will give you the response whether the user has already filled the details or not and if the user is not available then only it will process the workflow.

You can refer to the following screenshot for your better understating. Kindly try this at your end and let us know if that helps you out.

1662021151461.png
 

typhon99

Member
Hey @typhon99

You can use the Lookup Spreadsheet action event in your workflow with filter action step, which will give you the response whether the user has already filled the details or not and if the user is not available then only it will process the workflow.

You can refer to the following screenshot for your better understating. Kindly try this at your end and let us know if that helps you out.

View attachment 14991
Hello @Supreme

I did the same steps you showed out but doesn't work ..I tried to to make the filter doesn't exist it worked with already exist emails but it doesn't register new email which is not in the list!!

All what I want a filter prevent already exist email to register in the google sheet allowing just new emails
 
P

Pabblymember11

Guest
Hey @typhon99

As we can see from your workflow, you haven't applied the filter action step in your workflow.

Though we have added the filter action step and it should work now.

1662123685999.png
 
Top