Use date as a trigger for automations

Yannis Doukas
Yannis Doukas Member Posts: 27
5 Up Votes First Anniversary Photogenic

What i want to do, is to use expected close date, or a custom field that uses date- as a  starting point for action.

i.e. deal updated- expected  close date has changed - expected close date is prechosen?

Sama goes with custom field that is in date format.

 

Use case could be that i have a custom field "Validity of the offer"-date and when it has been reached you would get an activity "Offer expired, lose the deal or send nyt offer"

25
25 votes

· Last Updated -

«13

Comments

  • Vincent_8340
    Vincent_8340 Member Posts: 3
    First Comment
    edited July 2022 #2

    Bonjour, 

    Je suis passé à la version "Avancé" de Pipedrive pour accéder à la fonction d'automatisation du flux de travail.

    Malheureusement, je ne parvient pas à paramétrer des actions pour gagner en temps et efficacité notamment en donnant une condition de date de déclenchement d'une action.

     

    Est-il possible de déclencher une action automatique à la date du jour (par exemple envoyer un e-mail), avec comme condition une activité qui était planifiée à cette même date du jour ?

    Autrement dit j'aimerai qu'un mail de relance d'un devis client soit envoyé automatiquement via Pipedrive un jour J lors que j'ai planifier au préalable une activité d'envoie de mail le jour J.

     

    Est-ce possible ?

    En vous remerciant.

    Bien cordialement.

     

     

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,077 PIPEDRIVE TEAM
    First Anniversary 5 Likes 5 LOLs First Answer
    edited April 23 #3

    Hi @Vincent I'm happy to let you know the time/date based triggers are in our backlog to work on with our workflow automation team. Unfortunately, it won't be next week but it's on our to-do list!

  • BaptisteBLC
    BaptisteBLC Member Posts: 247
    First Anniversary 5 Likes First Comment Name Dropper
    edited April 23 #4

    Hello @Vincent ,

    Avez-vous regardé du coté des conditions de filtre sur les déclencheurs.

    Voici à quoi je pense :

    • 1- Créer le champ libre de date de relance
      • Dans offre
      • Créer un champ perso
      • type date
      • Stocker la date de relance de devis (Bon c'est galère, car il faut stocker la date de relance manuellement, mais on peut utiliser la modif en masse)
    • 2 - Créer la vue filtrée
      • Dans offre
      • Créer une vue filtrée en se basant sur le champ perso en condition
      • "Date de relance" = date du jour
    • 3 - Créer l'automatisme
      • Type offre
      • En mise à jour
      • Conditions = type "Filtre"
      • Faire correspondre avec le filtre créé en étape 2
      • Action = Envoi email

    Etape 4 en bonus, faire un test lol

    Car je suis pas sûr que ça fonctionne.

    Mais on a hâte que pipedrive fasse évoluer les fonctionnalités d'automatisme pour avoir des trigger sur les dates, des mise en attente entre action etc.

     

    Ca va arriver, mais en attendant vous pouvez tester ça.

    Bon courage

  • Joseph Valenti
    Joseph Valenti Member Posts: 72
    First Anniversary 5 Likes Name Dropper Photogenic
    edited April 23 #5

    Tel qu'indiqué par @Mike van der Valk le fonction n'est pas disponible actuellement mais Pipedrive y travaille depuis maintenant longtemps. Je peux espérer que ce sera en 2020, mais avec la situation actuelle tout est possible. 

    Je vous invite à considéré l'option de vous servir d'un outil externe, tel que Zapier ou Integromat, pour accomplir la tâche. Avec Integromat vous payerez $9/mo. S'il vous faut un consultant (comme nous, d'ailleurs!} vous aurez un coût d'environ $400 (une fois, pas mensuel) pour créer les automatisations. 

  • Vincent_8340
    Vincent_8340 Member Posts: 3
    First Comment
    edited April 23 #6

    Merci à tous pour vos réponses je vais analyser tout cela, faire des tests et trouver d'autres process d'autimatisation sans passer par une date. Et puis on sera patient jusqu'à l'intégration de nouvelles fonctions.

  • Martin Pfeiffer
    Martin Pfeiffer Member Posts: 29
    5 Up Votes First Comment
    edited April 23 #7

    Hey Team,

    support told me that workflow automation triggered by a time based condition is not available as of now. I have been referred to use Zapier instead however could not really work out anything I wanted.

    Let me give You a quick example:

    I love the rotten days feature. But what I really need is a workflow automation that triggers after a deal rottens for x amount of days (amazing it would be if individual stages could be addressed too). The moment am pushing lots of deals through my pipelines am eager to have an automatic house keeping tidy up the stages/pipelines in the background, idle deals and maybe transfer them into another pipeline dedicated for the slow-mo deals.

    Time based triggers can do so much more and users are gonna love this feature!

    THX

  • Marcelo Silva
    Marcelo Silva Member Posts: 243
    First Anniversary First Comment Photogenic
    edited April 23 #8

    Uma das coisas que poucas pessoa usam são Filtros como condições para gatilhos.

     

    Então você pode sim, criar uma automação que é disparada quando um negócio esta sem ser atualizado em X dias.

    1º crie um filtro que corresponda ao tempo que você quer de gatilho.
    2º crie uma automação de NEGOCIO Atualizado

     

    Pronto

    qq coisa pode me chamar 48991555002

     

  • Martin Pfeiffer
    Martin Pfeiffer Member Posts: 29
    5 Up Votes First Comment
    edited April 23 #9

    Thanks Marcelo,

    for the great advice!

    I think I got stuck around the rotten days feature since it pin pointed perfectly the actual problem of the deal hence overlooked the last deal activity time filter. I set up a new automation already and hopefully will see soon the first deals moving based on my condition as expected.

    Cheers,

  • Colin Krieg
    Colin Krieg Member Posts: 5
    First Comment
    edited July 2022 #10

    I would love to be able to set a custom field deadline (or even the closing date) and then be able to schedule an activity to happen x number of days before that date.  Maybe it's to check in to make sure the closing is going as scheduled.  

  • Zachary_25412
    Zachary_25412 Member Posts: 4
    First Comment Photogenic First Anniversary
    edited April 23 #11

    Fyi -we built an integration that can move deals based on the amount of time it has been in a stage. Going on the marketplace soon. If interested contact info@creative813.com

  • Antonio_14378
    Antonio_14378 Member Posts: 4
    First Comment
    edited April 23 #12

    Hello! Did you find a way to do this?

  • Frederik Eriksen
    Frederik Eriksen Member Posts: 2
    First Comment
    edited September 2021 #13

    We could use something like this as well.

    Our use case would be to do a quarterly follow-up with our customers. 

    Example: Every quarter, create an activity on the organisation named "Follow up".

  • Julius Gonzalez
    Julius Gonzalez Member Posts: 2
    First Comment
    edited April 23 #14
    Antonio said:

    Hello! Did you find a way to do this?

    Hey @Antonio and @Colin Krieg , were you able to find a way to do this? I can’t find anything and think I’m going to have to create an software app just to solve this issue.

     

  • Antonio_14378
    Antonio_14378 Member Posts: 4
    First Comment
    edited April 23 #15
    Antonio said:

    Hello! Did you find a way to do this?

    Julius hello! Yes, I found a way, it is a bit cumbersome but works. Basically you have to create a rule so that whenever a date field Zchanges value, it creates an activity automatically with a specific value X on location.  Then create a filter that shows those activities with value X on location created that day... Then on zapier you can detect whenever an activity is added to that filter (trigger when activity matches filter) and, in that instance, trigger the creation of an activity X time before the date value of Z. Hope this makes sense. 

  • Julius Gonzalez
    Julius Gonzalez Member Posts: 2
    First Comment
    edited April 23 #16
    Antonio said:

    Hello! Did you find a way to do this?

    @Antonio AAaaah I think I understand so you solely create an automatic activity for creating another activity that is x days before renewal. How do you ensure that the date value for field z is always changing?

    Also, doesn't this result in a lot of clutter activities?

     

    Basically, I was tasked to create an automation that creates an activity 90 days before a renewal date. I can't find a native way of doing it and even with zapier I don't see a trigger that would make sense so the only solution I think that's "clean" is with a little app that checks every day if there are upcoming renewals and create the task and associate it with the lead and assign it to a rep. 

     

    AND THANKS FOR THE REPLY!

  • Antonio_14378
    Antonio_14378 Member Posts: 4
    First Comment
    edited April 23 #17
    Antonio said:

    Hello! Did you find a way to do this?

    You are welcome! Although the set up is cumbersome, it solves the problem for sure. And you can even set different activities one 90 days before, another 60 days before etc...  First create renewal date field. Then create pipedrive automation, when renewal date changes, then a task is created with due that the "renewal date filed" and location "ZapierRenewalTrigger" or whatever you want. Then create an activity filter named "Zapier Create New Tasks" that shows all activities whose location contains "ZapierRenewalTrigger" AND the subject does not contain "zapok"... then in Zapier trigger "activity matching filter" when an activity matches your filter "Zapier Create New Tasks",  then Update activity the activity with ID matching the activity triggered... on the update change the subject to whatever you want  + "zapok"... then 3rd step is to find organization in pipedrive whos ID matches the one from step 1, then create the activities you want for that company wiuth a due date X days before the "Renewal date value". That's all! All tasks are clean, there's no duplication, all works great. Hope it helps!

  • Lea Weyermann
    Lea Weyermann Member Posts: 3
    First Comment
    edited April 23 #18

    @Julius Gonzalez - I would be interested to know how you solved this issue on your end? I am having a very similar issue - we need to set several activities and reminders that occur a few weeks prior to an installation date and can only get triggered once the installation date is known. Very much appreciate your response. 

  • Jan Pecinovsky
    Jan Pecinovsky Member Posts: 1
    First Comment
    edited April 23 #19

    I second that! it would be also great for delayed emailing.. "IF no reply in 5 days THEN move to the next stage"

  • Edie Mew
    Edie Mew Member Posts: 168
    First Anniversary 5 Up Votes 5 Likes First Answer
    edited July 2022 #20

    I recently tried to build automation where the overall requirements were an organization falling into a filter i had pre-made based on a date field. However I realised that you cant use that as a trigger when creating automations, the organisation has to be updated in some way for it to be triggered. 

    Please can the developers consider using the following as triggers: 

    If org, pers, deal or lead fall into this filter (based on a date that has arrived) then send an email, create an activity etc can be achieved. 

    To me the update is the date arriving on the day its due, therefore the org updates itself into a filter.....

     

  • Arthur_70084
    Arthur_70084 Member Posts: 72
    First Comment
    edited April 23 #21

    Hey  @Edie Mew ,

     

    I can help you build such a thing using Integromat the automation would be instant and filter according to your need. 

     

    If you want, you can book a call here with me (even if you just have some questions ) :https://calendly.com/soustellepro/free-30-minute-audit-and-consultation

  • Andre Vill
    Andre Vill Member Posts: 131
    First Anniversary Name Dropper First Comment 5 Likes
    edited April 23 #22

    Hi Edie!

    I understand your problem and countless times I have suggested this same thing to Pipedrive, for now, it might be easier to fix with Integromat as Arthur said. 

    A reason why Pipedrive probably won't be adding this feature is, if the Automation works once and your Pipedrive filter is built badly, the same automation will begin an endless loop of automations for that specific deal/org/contact.

     

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,531
    First Anniversary First Answer 5 Up Votes 5 Likes
    edited April 23 #23

    I second this with my whole heart. I have set up a number of automation flows based on matching filters. They don't get triggered for this reason. As a result, I have to do a fake bulk update of a custom field I don't use.

     

  • Graham Cox
    Graham Cox Member Posts: 156
    First Anniversary First Comment 5 Up Votes 5 Likes
    edited September 2023 #24

    HI Pipedrive,

    It would be incredibly useful to use a date as trigger for a Workflow automation and to auto-populate date and time custom fields when using scheduler. Examples below:

    1. Trigger an action x days after a date
    2. Trigger an action (eg an email reminder) x days before a date
    3. When sending booking invites out to prospects via scheduler, and the prospect confirms by clicking the Yes button in gmail, have the ability to push the confirmed date and time into custom fields

    Thank you.

     

    Graham

     

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,531
    First Anniversary First Answer 5 Up Votes 5 Likes
    edited April 23 #25
    1. Can be done using Pipedrive Automation using the delay feature with some help from Make/Integromat.
    2. Can be done using Make/Integromat.
    3. Need to check the triggers, but could be set up using Pipedrive Automation or Make/Integromat.

    If you have any other questions or need further help, please don't hesitate to reach out.

    Best,

    Amit Sarda

    Book a Call | Pipedrive Consulting | WhatsApp | Email

  • Graham Cox
    Graham Cox Member Posts: 156
    First Anniversary First Comment 5 Up Votes 5 Likes
    edited April 23 #26

    1. Can be done using Pipedrive Automation using the delay feature with some help from Make/Integromat.
    2. Can be done using Make/Integromat.
    3. Need to check the triggers, but could be set up using Pipedrive Automation or Make/Integromat.

    If you have any other questions or need further help, please don't hesitate to reach out.

    Best,

    Amit Sarda

    Book a Call | Pipedrive Consulting | WhatsApp | Email

    Thanks Amit,

    Could it be done with zapier as well?

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,531
    First Anniversary First Answer 5 Up Votes 5 Likes
    edited April 23 #27

    1. Can be done using Pipedrive Automation using the delay feature with some help from Make/Integromat.
    2. Can be done using Make/Integromat.
    3. Need to check the triggers, but could be set up using Pipedrive Automation or Make/Integromat.

    If you have any other questions or need further help, please don't hesitate to reach out.

    Best,

    Amit Sarda

    Book a Call | Pipedrive Consulting | WhatsApp | Email

    I think it is safe to assume so. But when I made the suggestions above, I evaluated it against what Make/Integromat could do.

  • Graham Cox
    Graham Cox Member Posts: 156
    First Anniversary First Comment 5 Up Votes 5 Likes
    edited April 23 #29

    Agree with Rozzo100, it would be ideal if all these automations could be configured without having to use an external tool.

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,531
    First Anniversary First Answer 5 Up Votes 5 Likes
    edited April 23 #30

    In an ideal world, yes! :)

    But this post is more than 3 months old.

    Not sure how much longer somebody would be willing to wait.

    When I make suggestions to solve a particular problem, especially the ones involving other tools, it is based on the assumption that you can't solve it using existing features.

    My suggestions are based on what tools are available to me, within or outside Pipedrive.

  • Graham Cox
    Graham Cox Member Posts: 156
    First Anniversary First Comment 5 Up Votes 5 Likes
    edited April 23 #31

    Amit, I understand what you are saying and appreciate your suggestions. But when pipedrive has automations which we are already paying for, the ideal would be that those automations could use dates. Thereby avoiding paying additional monthly fees for external tools.