Schedule a reminder text via twilio when date on a google sheet is in 3 days time

How To
1

I have a workflow that looks at a googlesheet and send a summary text via Twilio containing selected info. This is working. I want to add a step that then looks at the sheet for appointment dates that are in 3 days time and sends reminder text via twilio. I am not sure if i need a new module or need to connect it the current flow. I also can’t see how to check the sheet daily for the date -3.
Thanks In advance
googlesheets watch new rows.txt (1.1 KB)
Twilio create a message.txt (1.0 KB)

2

Welcome to the Make community!

How does the dates in your sheet look like? Can you create a scenario with a “Search Rows” module, and provide the output bundle of your sheet?

To allow others to assist you with your scenario, please provide the following:

Please provide the output bundles of each of the relevant modules by running the scenario (you can also get this without re-running your scenario from the History tab).

Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.

490×338 23.5 KB

A. Upload as a Text File

Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking on this button:

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved, and help you with mapping the raw property names from collections.

Sharing these details will make it easier for others to assist you.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

3

Hi Sam, I think i have done as you asked:
googlesheets watch new rows.txt (1.1 KB)
Twilio create a message.txt (1.0 KB)

4

Hey Jamie,

schedule the scenario to run once a day and have the first module be Search Rows with a filter that checks if the date field matches today’s date minus 3 days. Something like addDays({{now}};-3) should work as long as you format it to the same format that the date field is in.