Case
I have data in Google Sheets as Due Date, and I want to execute the next node ( send email or SMS ) 4 days before the due date, So what should I use please help me i tried lot but not able to find
Case
I have data in Google Sheets as Due Date, and I want to execute the next node ( send email or SMS ) 4 days before the due date, So what should I use please help me i tried lot but not able to find
@chandan988 sounds like you will need to use the Wait node.
Here is an example:
Things to keep in mind:
.toDate()
. If you go the JavaScript route, the wait node’s expression would look something like {{ $json.propertyName.toDate().minus(4,"days") }}
(so we first convert to a date object, then continue with the .minus transform)propertyName
to the name of the key from your Google Sheets stepHope that helps!
Hi @chandan988 ,
From what you describe, the workflow must run some kind of reminder. If so, a simple approach is the following workflow:
Source:
Run the workflow automatically once a day with the Schedule Trigger node.
Then define the variable “date” in the Set node, adding the 4 days margin until the due date.
Format the date field to match the format of the due_date field in the Google Sheets sheet (this step is optional, it will depend on how the fields are formatted).
We list the spreadsheet data, filtering the rows that only match their “due_date” column by the date we have set in the Set node and formatted in the previous node.
From here, you can continue the workflow with the steps you want.
Let me clear
Due date is suppose 25 Feb 2023, Then reminder should go 3 days before due date
@chandan988 have you tried adapting @martinhache or my suggestion? Looking at your Google sheet, either of our solutions sound like they should get you what you’re looking for.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.