Hello, as the subject suggests, I’m trying to create a scenario based on the automatic sending of an email that is linked to the automatic creation of a payment link, which I also automatically associate with the email itself. This is done using specific values, particularly the date field, which I retrieve from a Google Sheets document.
The automation consists of sending an email containing the payment link generated by PayPal, based on the date taken from Google Sheets, with a filter that schedules the email to be sent a few days before the date in the Google Sheet (in this example is one day before).
The issue is this:
- If I remove the PayPal app from the scenario, my function works, and the automation runs fine.
- If I remove the function and activate the scenario without any conditions, the automation together with PayPal payment works fine.
- If I keep the PayPal app and the function together, I get an error: The bundle did not pass through the filter (see image).
Am I doing something wrong in the function, or is this function incompatible with PayPal?
I need PayPal in the process because it generates a value, which is the payment link that I automatically insert into the email sent via Gmail.
Hey @Nevere_Before_Italia
While using parseDate() function, do not pass any format. Then only addDays() will work and the filter will pass if there is any bundle date matches with the condition. If not, then it won’t pass.
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
@Msquare_Automation Thank you fo you feedback. So i remove parseDate() function and leave only addDays ?
Regards,
Antonio
@Nevere_Before_Italia
{{addDays(parseDate(DATE_HERE);-1)}}
Please use like this.
Regards,
Msquare Automation - platinum Partner of Make
@Msquare_Automation
Pratically this .
So i need to wait tomorrow to verify if the condition is working or not beacuse if i run once right now the function blocks the bundle, beacuse the condition not match i think
Hey @Nevere_Before_Italia
{{now}} contains time. But your variable might can miss the time or the mismatch with the time when scenario runs. if you are using text operator “equal to”. apply formatDate() function over both {{now}} and addDays() and then run.
Regards,
Msquare Automation - platinum Partner of Make
@Msquare_Automation
@Msquare_Automation i only use format date DD/MM/YYYY without hours.
Actually, is important in this case apply also the formatDate() ?
Regards
By using formatDate(), you can get the date in your desired format without the time and it converts date data type to text. Hence, the text operator “equal to” will be validated in your filter.
i.e 26/11/2024 cannot be equal to 26/11/2024 4:00 am or anytime OR 26/11/2024 4:01 am cannot be equal to 26/11/2024 4:00 am.
Only 26/11/2024 can be equal to 26/11/2024.
I hope I’m clear. feel free to ask if you have further questions.
Regards,
Msquare Automation - platinum Partner of Make
@Msquare_Automation
@Msquare_Automation
Yes u are clear and very helpful.
My condition , if i understand will be this:
{{formatDate(addDays(parseDate(DATE_HERE; ); -1); )}}
{{formatDate(now; “DD/MM/YYYY”)}}
Almost there. It should be this. @Nevere_Before_Italia
{{formatDate(addDays(parseDate(DATE_HERE); -1); DD/MM/YYYY)}}
{{formatDate(now; DD/MM/YYYY)}}
Regards,
Msquare Automation - platinum Partner of Make
@Msquare_Automation
1 Like
@Msquare_Automation
It seems that works fine now , thank you.
I would like to ask you for advice. to check if the payment generated via ID is paid and then send another email with the condition based on the paid (state) of paypal, do I recommend using this add-ons?
Regards
1 Like
@Nevere_Before_Italia
yes you can use this module. If you seems an answer was a solution for you. We would appreciate marking that as a solution. This will keep community healthy and organized.
Regards,
Msquare Automation - platinum Partner of Make
@Msquare_Automation
Yes of course, i marked this as a solution.
Thank you for the support 
1 Like
We appreciate your feedback. @Nevere_Before_Italia
Regards,
Msquare Automation - platinum Partner of Make
@Msquare_Automation
Hi @Msquare_Automation,
in this days i tested the automation but it seems not work.
The filter is this:
{{formatDate(addDays(parseDate(DATE_here); -30); “DD/MM/YYYY”)}}
Date time operator: Earlier than
{{formatDate(now; DD/MM/YYYY)}}
What I would like to do is send the email 30 days before DATE_here
With an example: the DATE_here is 08/01/2025 so today is -30 days before but the bundle doesnt match , i dont know why
Regards.
Antonio
1 Like
Hey @Nevere_Before_Italia
You are using Date time operator. Please note,
parseDate() returns the output of “date” data type. And formatDate() returns the output of “text” data type.
Hence, when you need to use “Text Operator”.
Regards,
Msquare Automation - platinum Partner of Make
@Msquare_Automation
1 Like
