I have an idea that I would like to use with my social media workflow. As I collect news URLs, I’d like to add them to a spreadsheet. Run them through OpenAI to create a post and an image. This part I understand how to do. What I’m then looking to do is once the spreadsheet is populated, to notify the manager that there are new rows for them to review. The problem is I do not want to email them every time there’s a new row, just once every 15 days if there’s a new row. Does anybody have a suggestion?
you can do it using web hooks, set it up in a different scenario and schedule it for every 15 days and trigger a mail based upon that. What will happen is the triggers will be stored in the webhook queue and get executed on the specified days.
you will need to set up a http make request module after the add new rows module and send some dummy value in the main scenario
then in the second scenario where you set up the webhook add an array aggregator to convert all the bundles in to array and give the length and set up a filter between the aggregator and the email module
the mail part
and schedule it by days of the month
select 1 and 15
Thank you for the excellent, detailed instructions. I do have one question; the first scenario, how should it end?
Just add a http request module after add rows module in scenario 1
use the url from the webhook you set in the second scenario in the url parameter of the http module
this will send the value 1 in request content to the webhook queue
and when the scenario2 run as per the schedule all these data will be passed to the webhook and it will get completed with you receiving the notification