Send a notification email

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

image

image

the mail part
image

and schedule it by days of the month

select 1 and 15

1 Like

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