I want to use automation to send a tweet when a date field is a day after today. But I don’t want all records that match that condition to trigger sending the tweet at exactly the same time.
The actual time could be any random time during the day or spread out at fixed intervals. The important thing is that they go out on the correct date but don’t go out at exactly the same time as there can be any number of them and that would be poor form on Twitter. :grinning_face_with_sweat:
My thinking is that I can have two conditions, one for the date and another that matches the current time with a sequenced or randomly generated timeslot. But I cannot quite work out how to do that second part…
Personally, I would just use Integromat to stagger the tweets at fixed intervals.
You can use Integromat’s sleep tool to wait up to 5 minutes in between each tweet. If you wanted to wait longer than 5 minutes in between each tweet, that is also possible as well, but you would do it using the approach outlined in this article under the “Sleep” heading:
I managed to set something up by comparing the current minute value with values derived from an autonumber column and that actually worked to a degree. Then Twitter blocked the app after five tweets. Guess it thought I was spamming!