Hello, everyone.
I would like to start an automation and have it trigger at a specific time, but that specific time would be stored in a Google Sheet. Is there a way to configure the schedule settings so that it first checks the time and then executes the scenario at that time? Or is there a way for the automation to run and not advance to a specific module until the current time is the one indicated in the Google Sheet?
The idea is to automate social media posts, but these can vary greatly, so the marketing team will update a Google spreadsheet that will include not only the time but also the content to be posted.
Hey @Manuel_Chirino,
There are a few options available to you here, but I’ll describe a couple…
Create a separate scenario to run every 5 minutes, scan the spreadsheet for any dates that are past due, then run your main automation with that content retrieved from the sheet.
Or, without creating a separate automation, when your main automation runs, have it look for when the next run is due. Use the built-in Make modules to have it re-schedule itself to run when the next execution is due.
Next time it runs, it will do what it needs to do because then will re-schedule itself again to run the next time a post is due.
If nothing is due, then schedule it to run on some default interval until something is due again.
Hope that made sense and hope it helps!
1 Like