I understand your requirements now. To achieve this, you can follow these steps: 1. Use the Google Forms trigger to start your workflow when a new response is submitted. 2. Extract the due date from the Google Forms response. 3. Calculate the day before the due date using a code step. 4. Use a Schedule component with a Custom Interval trigger in another workflow. This second workflow will be responsible for sending the email. 5. In the first workflow, use an action to create a scheduled event in the second workflow, passing the calculated day before the due date as the scheduled time. 6. In the second workflow, use the Gmail Send Email action to send the email when the scheduled event occurs. Here’s an outline of the first workflow: // Google Forms trigger // Code step to extract due date and calculate the day before const dueDate = new Date(steps.trigger.event.dueDate); dueDate.setDate(dueDate.getDate() - 1); // Action to create a scheduled event in the second workflow And the second workflow: ```
// Schedule - Custom Interval trigger // Gmail - Send Email action