How to set up a scenario to run at regular intervals (every hour) but only on specific days of the month (eg : 2nd and 3rd...)

How To
1

Hi everyone,

I’ve read the few threads that discuss scheduling options, but couldn’t find exacty what I wanted, therefore, I am opening a new topic.

I would like to run a “Google sheet > Watch New Rows” module every hour but only on selected days : the 2nd, 3rd and 4th day of the month, every month.

When asking Make AI and ChatGPT for advice, they suggested using the “days” field in the “advanced scheduling” and entering 2,3,4… which sounded absolutely wrong to me.

image
image442×619 24.3 KB

It actually returns a warning message.

I saw that @samliew solved a similar issue by Making an API Call (📅 How to schedule scenario for first Monday next month (recurring)), but it seemed to me that the problem to be solved was more complex than mine

Is there a syntax I can use in the “days” field that will trigger the scenario every hour, only on the 2nd, 3rd and 4th day of each month ?

Thanks for your help

Ludo

2

Hey @triplelootz,

This is a little bit complicated based on the available options we have on make scheduling. What I would do:

  • Add this automation to run every 60 minutes every day without advanced scheduling
  • Create another scenario that will run every “Days of the month” where you select 2,3,4 and whatever you prefer.
    The second scenario will be able to turn on and turn off your primary scenario.

Feel free to reach out for deeper explanation :slight_smile:

Thanks
Dimitris Goudis

3

Thanks Dimitris for the recommandation.
I am happy to see that my problem was in fact… not so straightforward to solve.
I’ll give a go to your solution in the next few weeks (not so urgent as I have enough operations to let the current scenario run every hour), and let you know if I am having trouble.

Ludovic