Good morning,
I have a problem, I can't find how to do this on Zapier, I wonder if it's really possible. My goal is to capture leads through Facebook and then, using paper, to do several actions automatically: fill out a Google sheet, send WhatsApp messages, etc.
Here's what's blocking me and I'm wondering if it's possible on paper:
1- in a Google sheet, I have lines (lead) that I would not like zappier to take into account for its workflow. These lines are checked in a column because they are bad leads. How can I ensure that zapier does not take these lines/lead into account?
2- if a lead comes from Facebook Ads several times, zapper will create several lines in Google Sheet, how can I ensure that Zapier does not create a line (lead) if it is already present in the Google Sheet in question?
3- by putting a date in a cell of the Google Sheet, I want an appointment to be created in Google Calendar. But each time the zap creates an event on today's date and not on the date indicated in the gogole sheet with the rap pointing at the start/end of the event on the "date" column.
4- I would like to trigger/activate the zap from Monday to Friday from 8 a.m. to 6 p.m. in the evening, but for it to be paused in the evening from 6 p.m. How to do ? Because I don't see a way to activate and deactivate the headings according to times.
Thank you for your help because I have the impression that this is not possible under Zapier
